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

Question

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?

Answer 1

Try adding this to your connection string:

Trusted_Connection=False;Encrypt=True;