You have insufficient permissions to create the database project

Question

I am running Vista and I am not using Admin user. I tried with an Admin username too, but it did not work. Any ideas?

Answer 1

Read this blog post here for the answer to your question.

To summarize his post you need to do the following:

1. The user needs a SQL Server login
2. The SQL Server login needs to be a member of the build-in dbcreator role
3. The SQL Server login needs to be a member of the build-in securityadmin role
4. The SQL Server login needs to have the VIEW SERVER STATE privilege granted
5. If running 2005 SP1, Grant the public group execute rights to the sp_detach_db procedure

Answer 2

Check out this: Ozzie Rules Blogging

Do this:

1. The user needs a SQL Server login
2. The SQL Server login needs to be a member of the build-in dbcreator role
3. The SQL Server login needs to be a member of the build-in securityadmin role
4. The SQL Server login needs to have the VIEW SERVER STATE privilege granted
5. If running 2005 SP1, Grant the public group execute rights to the sp_detach_db procedure

Answer 3

I am answering this myself. And the solution is to add the server role of "sysadmin" to "Builtin/Users" login in the SQL Server.

This should be done because the visual studio uses this user account to create a temporary database while we are editing to do design time validation.