.Net Entity Core Update-Database gives System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'sa'

0

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 ?

.net-core
entity-framework-core
connection-string
sql-server-2016
asked on Stack Overflow Aug 24, 2018 by Furqan Misarwala • edited Aug 27, 2018 by Furqan Misarwala

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0