Microsoft Visual Studio error, database schema could not be retrieved

Asked By Derrick E Clayton 30 points N/A Posted on - 06/24/2013

 

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.

• Status: Open
• Question Views: 3292
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Drake Vivian 30 points N/A #187226

Microsoft Visual Studio error, database schema could not be retrieved

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

About Drake Vivian

Questions
0

Answers
820

Best Answers
186

• Vote Up 0 Vote Down

• Posted on - 07/09/2013
• Question Category: Visual basic