I have used the DAC capability and SQLCMD.exe to access our server...but I am unable to use the DAC option when using Management Studio tool.
The BOL state for you to use 'ADMIN:' followed by the server instance....but I get an error message that the "Dedicated Administrator Connection is not supported."
As a member of the sysadmin group...I have the appropriate security credentials. Does anyone have some insight into this problem?
...cordell...
I confirmed that system (using the surface area tool) has been configured to allow a remote system to have DAC connectivity.
...cordell...
|||Few things you need to confirm:
Are you using SQLExpress or SQLExpress with Advanced features?
Are you a local admin on the server and as well as on SQL SErver?
Have you upgraded this SQL instance from previous version?
Check the build version of the tools and ensure they match.
|||The DAC is only supported for a query window, it's not supported with Object Explorer. If trying to connect with a DAC in SSMS, try opening a regular connection first and then open a query window with a DAC.-Sue
Thank you Sue...great suggestion and it worked as you detailed it would.
...cordell...
|||1) SQL Server Enterprise 64-bit (Single Instance)
2) I am local administration credentials on the physical server and have SQL Server SA credentials.
3) I am not sure what the question you are asking.
4) Running SQL Server 2005 SP1 on both server and my desktop system.
...cordell...
No comments:
Post a Comment