September 29, 2011 at 1:12 am
I sucessfully enabled the DAC connection in my SQL 2008
While testing the DAC connection through the command prompt , I am getting an error
An error occurred while obtaining the dedicated administrator connection (DAC) port.
Make sure that SQL Browser is running, or check the error log for the port number [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings
SQL Server does not allow remote connections..
P.S.- Browser is enabled ....
I am also not able to connect through SSMS .
Pls . suggest .
\m/ TIA
September 30, 2011 at 12:38 am
I am able to connect through SSMS now , but the prob still persists for my command prompt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply