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

asp.net-mvc azure-sql-database c# entity-framework 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?

1
26
9/15/2015 7:42:59 PM

Popular 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;
38
7/9/2014 4:22:38 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow