Microsoft Visual Studio error, database schema could not be retrieved

Asked By 30 points N/A Posted on -
qa-featured

 

Hi,

I get this error shown below, this is a known problem (and why hasn’t it been fixed, and why isn’t it clearly defined in the documentation? I am waiting for your suggestion to resolve this issue. Thanks.

Error Message: Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.

The database has been placed in a state by user ‘Admin’ on machine ‘BIGGUY123’ that prevents it from being opened or locked.

SHARE
Answered By 0 points N/A #187226

Microsoft Visual Studio error, database schema could not be retrieved

qa-featured
Hi there Derrick E Clayton,
 
The error actually says it all – you don't have high enough privileges to access the database. Here are two things you can do to solve the problem.
 
Access the database as an Admin user. Admin user will have all rights so you will be able to connect to the database.
 
Another solution is to login as admin user and change privileges on your database so all users can access it.
 
Best regards,
Drake Vivian

Login/Register to Answer

Related Questions