Skip to content

Instantly share code, notes, and snippets.

@robert-claypool

robert-claypool/domain-user-as-sysadmin.sql

Created August 22, 2014 21:22
Show Gist options
  • Save robert-claypool/c0fdd67d7e16a8e90d10 to your computer and use it in GitHub Desktop.
Save robert-claypool/c0fdd67d7e16a8e90d10 to your computer and use it in GitHub Desktop.
Download ZIP
How to Add a Windows Domain User to SQL Server as ‘sysadmin’
Raw
domain-user-as-sysadmin.sql
USE master
GO
CREATE LOGIN [domain\username] FROM WINDOWS WITH DEFAULT_DATABASE = [Master]
GO
EXEC sp_addsrvrolemember @loginame=N'domain\username', @rolename=N'sysadmin'
GO
@robert-claypool
Copy link
Author

See http://msdn.microsoft.com/en-us/library/ms186320.aspx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment