SqlException:System.Data.SqlClient

Asked Dec 03 '17 at 10:32

Active Dec 03 '17 at 11:52

Viewed 45 times

Windows Authentication for SQL Server failed for Visual Studio 2017 ASP.Net Core 2.0. I have an account Asif\Sakib in SQL Server Management Studio with Windows authentication.

Connection string:

Server=(localdb)\\mssqllocaldb;Database=SalarydemoContext;Trusted_Connection=True;MultipleActiveResultSets=true

Worked for me before but now showing this problem:

An unhandled exception occurred while processing the request.

SqlException: Cannot open database "SalarydemoContext" requested by the login.
The login failed.
Login failed for user 'Asif\Sakib'.
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, object providerInfo, bool redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, bool applyTransientFaultHandling)

edited Dec 03 '17 at 11:52

marc_s

732,580
175
1,330
1,459

asked Dec 03 '17 at 10:32

Md Namus Sakib

2

Well, the error pretty much says for itself. Try connecting to the server with some sql client under user Asif\Sakib. – CodeFuller Dec 03 '17 at 10:34
but this user is present in the sql server management studio. – Md Namus Sakib Dec 03 '17 at 10:36

SqlException:System.Data.SqlClient

0 Answers0