Skip to content

Instantly share code, notes, and snippets.

@JohnLBevan
Created September 22, 2014 10:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JohnLBevan/2582960a23605e0cecec to your computer and use it in GitHub Desktop.
Save JohnLBevan/2582960a23605e0cecec to your computer and use it in GitHub Desktop.
Grant user sysadmin access to a SQL instance from the command line
--::example batch file:
--pushd \\ukexchange\sysgrp\scripts\sql
--sqlcmd -S ccioaxpd05edc\axeam_train -i \\ukexchange\sysgrp\scripts\sql\grantsysadmin.sql -E -o \\ukexchange\sysgrp\scripts\sql\GrantSysAdmin.rpt
--popd
--sql file:
-- - usage:
-- sqlcmd -S <server\instance> -i \\ukexchange\sysgrp\scripts\sql\grantsysadmin.sql -E -o \\ukexchange\sysgrp\scripts\sql\GrantSysAdmin.rpt
use master
go
--give sys admin to the CCIT DBA team
EXEC master..sp_addsrvrolemember @loginame = N'eu\svc-dataway1', @rolename = N'sysadmin'
go
--give sys admin to myself (so I can check the script's worked & validate svc's access)
EXEC master..sp_addsrvrolemember @loginame = N'eu\sejb', @rolename = N'sysadmin'
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment