Posted by Erland Sommarskog on 03/28/07 22:45

raylopez99 (raylopez99@yahoo.com) writes:
> This is a very basic question, perhaps more of a Windows XP
> Professional OS permissions question than a dB or programming
> question: how to create and access SQL SERVER databases from an
> account other than "Administrator"; for example, from a "Power User"
> account?
>
> As anything other than an "Administrator" user (i.e. as a Power User),
> I keep getting (when I try from inside of MS Visual Studio 2005
> development environment) the error message: "CREATE DATABASE
> permission denied in database 'master'

That's indeed an issue of SQL Server permissions.

When you are logged in as an Administrator in Windows and connect to
SQL Server, you account maps to BUILTIN\Administrator which has sysadmin
privilege in SQL Server. That is, you can do anything.

WHen you connect with some other Windows user, no get no such extra
thrills, but you need to grant that login rights to do things. For instance

GRANT CREATE DATABASE TO DOMAIN\PowerUser

You can also add that user a role which has the privileges you want,
for instance to the sysadmin role.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]