C# – How to resolve Azure “Windows logins are not supported in this version of SQL Server”

asp.net-mvcazure-sql-databasecentity-frameworksql server

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?

Best Answer

I was using user/pass and still got the error message. But, I added this to my connection string and it worked.

Trusted_Connection=False;Encrypt=True;
Related Topic