Adding an administrator user to SQL Server 2008

sql-server-2008users

How do you add an administrator user to SQL Server 2008?

Best Answer

If you're doing it via T-SQL:

Granting a Windows Login the ability to connect to SQL Server:

CREATE LOGIN [Domain\User] FROM WINDOWS;

or 

CREATE LOGIN [Domain\Group] FROM WINDOWS;

If SQL Server-based login:

CREATE LOGIN [LoginName] WITH PASSWORD = 'SomePassword';

After that, you can do one of two things. You can add it to the membership of the sysadmin fixed server role using sp_addsrvrolemember:

EXEC sp_addsrvrolemember 'LoginName', 'sysadmin';

or you can grant the login CONTROL SERVER permissions:

GRANT CONTROL SERVER TO [LoginName];
Related Topic