Can you use Visual Studio Team Edition for Database Professionals running as a normal Windows user? Yes!
You have to provision the Windows user with the appropriate rights and privileges on the local SQL Server instance that is used for design time validation. In order for a normal Windows users to use Visual Studio Team Edition for Database Professionals you need to have the following rights on the local SQL Server instance:
To check if you gave the user the appropriate rights you can run the following query which has to return 1 if you done it right.
SELECT 1FROM fn_my_permissions(NULL, N'server') WHERE [permission_name] = N'VIEW SERVER STATE'AND IS_SRVROLEMEMBER(N'dbcreator') = 1AND IS_SRVROLEMEMBER(N'securityadmin') = 1
Now there is one more thing!
If you have SQL Server 2005 SP1 installed you need to grant the public group execute rights to the sp_detach_db procedure. Why? In the RTM version of SQL Server 2005 this was already done for you, but when you installed SQL Server 2005 SP1, this grant was dropped by accident, so to get you back to the original state you need to run the following query:GRANT EXECUTE ON [sp_detach_db] TO [public]
Why public, am I opening up the world? No, the actual validation is done inside the procedure, so granting access to public is not providing this right to the whole world access to this procedure.
Now you should be able to login as a normal Windows user and use Visual Studio Team Edition for Database Professionals.