sp_configure 'remote admin connections', 1 reconfigure with override
Not rocket science but only realised i needed when a box got maxxed out at 99% CPU and I could not get a connection!
(connect using 'admin:Servername' to a QUERY WINDOW in management studio)
DAC functionality is for emergency use and only works with a TSQL query window i.e for you to run sp_who, kill etc.
If you try and open an object explorer with the ADMIN: prefix, you get >
http://www.mydbalife.com/2009/06/dac-is-friend-that-you-need-to.html
No comments:
Post a Comment