I am able to connect to SQL Server Management Studio with this user, but when I run
Update-Database
from the nuget package console, I get this error :
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'sa'. Error Number:18456, State:1, Class:14
Not Working
Server=(local);User Id=sa;Password=[password];Database=[Database]
Working
Server=(local);Trusted_Connection=True;Database=[Database];
What is the issue with first connection string or User ?
User contributions licensed under CC BY-SA 3.0