c# – SQL Connection String appsettings.json

c# – SQL Connection String appsettings.json

It should work after You delete Trusted_Connection=True; from connection string.

If you specify either Trusted_Connection=True; or Integrated
Security=SSPI; or Integrated Security=true; in your connection string
THEN (and only then) you have Windows Authentication happening. Any
user id= setting in the connection string will be ignored. Found in here: When using Trusted_Connection=true and SQL Server authentication, will this effect performance?

Please

Please search services in the window menu, it will show you the local services then go to SQL server services and refresh all, then go to the SQL server management studio and by using SQL authentication please provide username and password, you will be able to use the SQL server. for appsetting.json update, trusted_connection is used for window authentication not for SQL server authentication by using username and password

c# – SQL Connection String appsettings.json

Leave a Reply

Your email address will not be published. Required fields are marked *