Need T-SQL to GRANT SYSAdmin Role to Windows LOGIN

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Camilo Torres SSCrazy Points: 2034 More actions · Answer 1

Try this

USE <dbname>;GRANT CONTROL SERVER TO <username];GO

Read here:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/7e880a5a-3bdc-491f-a167-7a9ed338be7f.htm

 I understand now. This will not give you what want.

Bill Nye Hall of Fame Points: 3248 More actions · Answer 2

EXEC master..sp_addsrvrolemember @loginame = N'Domain\Username', @rolename = N'sysadmin'

Note that you can find things like this by using the script button that is at the top of many windows such as the Login Properties window.

Bill

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

use master

go

sp_addlogin [domain\username]

sp_addsrvrolemember [domain\username],'sysadmin'

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

David Bishop SSC Journeyman Points: 75 More actions · Answer 4

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.