Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


  • SQL Server 2005 Express
  • Windows 7

When I installed SQL Server, I followed the instructions at to set my computer's admin account as the SQL Server admin.

However, when I try to access a database on my computer through Visual Studio 2008, I get the following error message:

Microsoft Visual Studio
The database 'Parkinsons' does not exist or you do not have permission to see it.

Would you like to attempt to create it?
Yes   No   

Then, if I go to SQL Server and add a user to that database, I get the following error message:

TITLE: Microsoft SQL Server Management Studio Express

Create failed for User 'zian'.  (Microsoft.SqlServer.Express.Smo)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)


The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)

For help, click:


  1. Why doesn't VS piggy back on the dbo account?
  2. If the dbo account is unusable, then why won't SQL Server let me make an account so that I can access my own data?
share|improve this question
up vote 1 down vote accepted

Does this database already exist? If so you'll have to refer to it as dbo.Parkisins Or whatever user schema was used to create it.

share|improve this answer

Try running Visual Studio as administrator. On my Server 2008 box, my user (which is a local administrator and a sysadmin on the DB) cannot connect using SQL Management Studio unless I run the Management Studio as administrator.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.