0 votes
1 view
in Azure by (8.4k points)

I get the following error message when I try to connect to SQL Azure.

Windows logins are not supported in this version of SQL Server

I'm using an Azure connection string. On development, I'm running against SQL Server Express. This specific error is thrown when I try to fetch some data from the database.

The context that I'm using is running in a using clause, see below:

function List<SomeType> GetList(string dbContextName) 

    using (MyDbContext context = new MyDbContext) 

    {

         return context.SomeTypes.ToList();

    } 

}

We're using Entity Framework version 4.2, ASP.NET MVC 3 and .NET 4.0.

How can I resolve this issue?

1 Answer

0 votes
by (16.8k points)

Try adding this to your connection string:

Trusted_Connection=False;Encrypt=True;

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...