Loading

sql server login error

Bruce Zelenka

Unhandled Exception: System.Data.SqlClient.SqlException: Cannot open database "Books" requested by the login. The login failed.
Login failed for user 'DESKTOP-6N6BRC7\bruce'.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar7y ago
Hi Brouce,

Could you please check you connection string. I think you have use table name in Initial catalog. It sould be database name. Check below in your connectionstring.
Initial Catalog= YourDatabaseName;
0
Jeeva Subburaj7y ago
this means, you dont have access to your windows authentication user account for the database. You may have to login with your SA account credndials and grant access for bruce account.
+1