VIEW SERVER STATE Permissioning to an AD Group

[Frank]

Hello,

Does anyone know how to assign VIEW SERVER STATE permissioning to an Active
Directory Group?

I've read dozens of examples and got it to work on SQL Server logins,
however when I try and assign an AD group I get a user not found error.

These are the commands I've tried to run to give the AD Group user
permissioning on the server :

GRANT VIEW SERVER STATE TO DOMAINNAME\Groupname
GRANT VIEW SERVER STATE TO Groupname

Our servers are set up to be Windows Authentication only so a SQL Server
log-in won't be a solution.

Thanks for your time,
Frank

[Frank]

I figured it out. You need to put quotes around the username as such:

GRANT VIEW SERVER STATE TO "DOMAINNAME\Groupname"

Can't believe I wasted my time on something so simple. My next question is
why

GRANT VIEW SERVER STATE TO "DOMAINNAME\Groupname"

worked and

GRANT VIEW SERVER 'STATE TO DOMAINNAME\Groupname'

fails.

What's the difference in using single quotes vs doble quotes????

Thanks again...

Post by Frank
Hello,
Does anyone know how to assign VIEW SERVER STATE permissioning to an
Active Directory Group?
I've read dozens of examples and got it to work on SQL Server logins,
however when I try and assign an AD group I get a user not found error.
These are the commands I've tried to run to give the AD Group user
GRANT VIEW SERVER STATE TO DOMAINNAME\Groupname
GRANT VIEW SERVER STATE TO Groupname
Our servers are set up to be Windows Authentication only so a SQL Server
log-in won't be a solution.
Thanks for your time,
Frank

[Tibor Karaszi]

You use double quotes or square brackets around identifiers (think object names). You use single
quotes around strings (think WHERE lastname = 'Johnson').
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Post by Frank
GRANT VIEW SERVER STATE TO "DOMAINNAME\Groupname"
Can't believe I wasted my time on something so simple. My next question is why
GRANT VIEW SERVER STATE TO "DOMAINNAME\Groupname"
worked and
GRANT VIEW SERVER 'STATE TO DOMAINNAME\Groupname'
fails.
What's the difference in using single quotes vs doble quotes????
Thanks again...

Post by Frank
Hello,
Does anyone know how to assign VIEW SERVER STATE permissioning to an Active Directory Group?
I've read dozens of examples and got it to work on SQL Server logins, however when I try and
assign an AD group I get a user not found error.
GRANT VIEW SERVER STATE TO DOMAINNAME\Groupname
GRANT VIEW SERVER STATE TO Groupname
Our servers are set up to be Windows Authentication only so a SQL Server log-in won't be a
solution.
Thanks for your time,
Frank