March 25, 2011 at 11:21 am
Try this (even though you are Dom. Adm.)
Use subinacl to grant the SQL DBAs group access to query service state on the MSSQLSERVER and SQLSERVERAGENT services
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 25, 2011 at 11:24 am
douglas.strough (3/25/2011)
We use VM templates for our SQL servers, so all servers are set up identical (all 78 that I manage). All are configured with default SQL configurations regarding the port numbers.I am convinced it something with the firewall.
Interestingly - we saw the same issue from doing the same kind of process - using templates to create our servers. Still looking for that doc.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 25, 2011 at 11:59 am
I performed the subinacl command. here are the results where ****** is substituted for my actual domain name. Am I not running the command correctly? Also, I have executed it both on the source and only one target server where source is the administration DB server.
C:\Program Files (x86)\Windows Resource Kits\Tools>subinacl /verbose=1 /service
MSSQLSERVER /grant="******\SQL Server Hosting Admins"=QS
MSSQLSERVER : delete Perm. ACE 4 empire\sql server hosting admins
MSSQLSERVER : new ace for ******\sql server hosting admins
MSSQLSERVER : 2 change(s)
Elapsed Time: 00 00:00:00
Done: 1, Modified 1, Failed 0, Syntax errors 0
Last Done : MSSQLSERVER
C:\Program Files (x86)\Windows Resource Kits\Tools>subinacl /verbose=1 /service
SQLSERVERAGENT /grant="******\SQL Server Hosting Admins"=QS
SQLSERVERAGENT : delete Perm. ACE 4 empire\sql server hosting admins
SQLSERVERAGENT : new ace for ******\sql server hosting admins
SQLSERVERAGENT : 2 change(s)
Elapsed Time: 00 00:00:00
Done: 1, Modified 1, Failed 0, Syntax errors 0
Last Done : SQLSERVERAGENT
March 25, 2011 at 12:01 pm
Looks like it completed successfully and modified some perms. Did it not work for the status?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 25, 2011 at 12:11 pm
I shut down management studio, then reopened it so that it would start at the beginning of the list to poll for service status on the remote db. I purposely selected a remote db server at the top of the list so that I wouldn't have to wait too long for it to try and query the sql service status. I waited for about 3 minutes, given the default timeout period of a few seconds as indicated in this article: http://stackoverflow.com/questions/1169328/stop-monitoring-sql-services-for-registered-servers-in-smss
No dice 🙁
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply