Viewing post 1 (of 1 total)
Sugesh Kumar (6/26/2007)use mastergosp_addlogin [domain\username]sp_addsrvrolemember [domain\username],'sysadmin'
Sugesh Kumar (6/26/2007)
use master
go
sp_addlogin [domain\username]
sp_addsrvrolemember [domain\username],'sysadmin'
sp_addlogin is for SQL Authentication. You must use sp_grantlogin instead.
December 14, 2010 at 12:07 pm
#1262407