{"id":264,"date":"2013-01-02T12:00:32","date_gmt":"2013-01-02T12:00:32","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2013\/01\/02\/ssms-bug-connection-information-does-not-change-in-ssms-when-a-new-query-is-created-from-dedicated-administrator-connection\/"},"modified":"2013-01-02T12:00:32","modified_gmt":"2013-01-02T12:00:32","slug":"ssms-bug-connection-information-does-not-change-in-ssms-when-a-new-query-is-created-from-dedicated-administrator-connection","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2013\/01\/02\/ssms-bug-connection-information-does-not-change-in-ssms-when-a-new-query-is-created-from-dedicated-administrator-connection\/","title":{"rendered":"SSMS ISSUE: Connection information does not change in SSMS when a new Query is created from Dedicated Administrator Connection"},"content":{"rendered":"

Description:<\/strong>
\nConnection information does not change in SQL Server Management Studio for SQL Server 2008 r2 when a new Query is created from Dedicated Administrator Connection.<\/p>\n

Steps:<\/strong>
\n1. Open SQL Server management studio and connect to SQL Server in Dedicated Administrator Connection.
\nIn order to connect to SQL Server in Dedicated Administrator Connection (DAC) you have to add ADMIN:<\/strong> before the SERVERINSTANCE name.<\/p>\n

\"Dedicated<\/a><\/p>\n

2. After connecting the the Server with DAC click on new query.<\/p>\n

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.<\/p>\n

[text]
\nTITLE: Connect to Database Engine
\n——————————<\/p>\n

Cannot connect to ADMIN:..<\/p>\n

——————————
\nADDITIONAL INFORMATION:<\/p>\n

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)<\/p>\n

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

——————————
\nBUTTONS:<\/p>\n

OK
\n——————————
\n[\/text]<\/p>\n

4. Now in the error message popup click OK and change the connection to any other SQL Server.<\/p>\n

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.<\/p>\n

\"BUG<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[186],"tags":[],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/264"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=264"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/264\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}