November 17, 2008 at 3:03 pm
I was testing my DAC connection to my sql 2005 server and I can get it to work from the command prompt, however if I try to connect with the GUI with ADMIN in front of the server name (I do have DAC checked in surface config). It fails with windows or sql authentication. It tells me dedication admin connections not supported
November 17, 2008 at 5:05 pm
Make sure sql browser service is started and remote connections are allowed in case of remote DAC connection.
I am able to get DAC connection by following the info in the below mentioned link:
http://msdn.microsoft.com/en-us/library/ms178068(SQL.90).aspx
HTH!
MJ
November 18, 2008 at 11:44 am
Browser started, still will not work
November 18, 2008 at 1:38 pm
Try this:
Go to File menu-->New-->Database Engine Query.
Select Database engine and then enter ADMIN:Servername.
This time it shld work.
HTH!
Manu
November 18, 2008 at 1:42 pm
thanks that worked
November 18, 2008 at 1:45 pm
Actually you can't have DAC from object explorer.
DAC is not supported for the object explorer, only for the query window.
Manu
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply