SQL Server and EF Migration from local to remote database

c# entity-framework-6 sql-server tsql visual-studio-2012

Accepted Answer

I located the issue. My project uses SQL authentication, as I already mentioned, but if you look at my connection string, there is no SQL user ID.

In the absence of a user ID, Entity Framework will by default utilize the local client user ID.

I am unable to connect since the latter is qualified in the remote domain but the local client is not.

0
1/8/2016 6:06:12 PM

Popular Answer

By using this setting, you have activated Windows authentication (on).integrated security=True; Adjust it tointegrated security=False; or you can completely get rid of that field.

2 hours spent looking for bugs on a previous project. this is the 19-zzz



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