SSMS ISSUE: Connection information does not change in SSMS when a new Query is created from Dedicated Administrator Connection

Posted on : 02-01-2013 | By : Devi Prasad | In : SQL Server Issues

0



Description:
Connection information does not change in SQL Server Management Studio for SQL Server 2008 r2 when a new Query is created from Dedicated Administrator Connection.

Steps:
1. Open SQL Server management studio and connect to SQL Server in Dedicated Administrator Connection.
In order to connect to SQL Server in Dedicated Administrator Connection (DAC) you have to add ADMIN: before the SERVER\INSTANCE name.

Dedicated Administrator Connection

2. After connecting the the Server with DAC click on new query.

3. You will get the error that you cannot connect as you are already connected to the server with DAC and only one DAC Connection is allowed.

TITLE: Connect to Database Engine
------------------------------

Cannot connect to ADMIN:..

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (Microsoft SQL Server, Error: 10053)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10053&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

4. Now in the error message popup click OK and change the connection to any other SQL Server.

5. Now you will find that the connection details displayed when you keep the mouse pointer over the SQL Server Query are still showing that of the DAC.

BUG SSMS DAC




Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here