The database 'DB Name' is not accessible

Question

I am getting following error each time I tried to select database. The database 'DB Name' is not accessible. (Microsoft.SqlServer.Express.ObjectExplorer)

Note: My OS is Win Vista.

When I tried to open SQL Mgmt Studio as Run as administrator than I can able to access database properly.

Any idea why it is giving error.

I am also getting following error when my asp.net application is trying to access database.

Cannot open database "DBName" requested by the login. The login failed. Login failed for user 'PCName\abcd'.

I am not very good with SQL Server, please let me know how to create user and grant them permission in case that is what causing the problem.

Thanks.

stackoverflow.com/questions/14123917/…

AKP
– AKP

2019-12-05 13:25:54 +00:00
Commented Dec 5, 2019 at 13:25 — AKP
– AKP, Commented Dec 5, 2019 at 13:25

3Dave · Accepted Answer · 2010-06-13 16:43:54Z

5

This is a permissions issue. When you run SSMS as administrator, you have access to everything. Your ASP.NET app is (and should be) connecting with a different user account, and does not have that access.

Create a new login in SQL server for your application, with its own username and password.

Add that login to your database DbName (under the \databases\DbName\security in SSMS) and give it the correct permissions.

answered Jun 13, 2010 at 16:43

3Dave

29.2k18 gold badges91 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

The database 'DB Name' is not accessible

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related