How to resolve Azure "Windows logins are not supported in this version of SQL Server"?
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;
Set
Integrated Security=False
In Connection String.
Integrated authentication (i.e. SSPI in the connection string) is NOT supported in SQL Azure.Only SQL Authentication is supported (i.e. username & password in the connection string)