[SQL Server] how to add a domain account as a database user

1. Create the login

First create a SQL Server login for your domain account.

Create login [your domain account] from windows;

Go

Your domain account has to be replaced with the domain account you want to add. for instance your domain is called Darth and the user Vader than it wocould be create login [Darth \ VADER] from windows; go;

To check if the login was successfully created type in

Select name from SYS. server_principals

Go

And the domain user shoshould appear in the result list.

2. Grant SysAdmin rights

You can retrieve a list of server roles usingSp_helpsrvroleProcedure. So to add the user toSysAdminServer role group type the following (example is still domain Darth user Vader)

SP_ADDSRVROLEMEMBER 'darth \ Vader ', 'sysadmin'

Go

Done.

Quit sqlcmd and open a non elevated instance with your domain account. Type in select user_name () and the result shocould be DBO.

Reference from: http://blogs.msdn.com/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx