Failed to Connect to server admin:servername\instance Error..but it does connect!

At the SQL Pass Summit last week, I attended a Pre con by Paul Randal and while using a Dedicated Admin Connection he seemed to get a strange error in Management Studio. It seemed he was familiar with the error so i thought I’d try to get to the bottom of it as it just happened to me…

The Issue

Whenever you try to open an admin (DAC) connection to an instance via SSMS, a random error pops up even though the connection is successfully made:

image

After you Ok the error…SSMS is still happy!..

image

Why does this happen?

This is all down to how the Management studio Query window is opened. IF an existing normal connection to the database already exists, then you will get the error. The key is to not have any connectivity to the server in management studio so a completely fresh connection can be opened and not a connection switch in the an existing query window!

Normally you will have object explorer open and the normal course of action is to press the ‘New Query’ button which will open a connected session using the connection context in your Object explorer. Then when you try to switch the connection, the error will happen.

Solution

To do cleanly (not that it matters!), close the object explorer or have a clean SSMS GUI and press the new query window. This will prompt for the connection where the DAC details can be entered and it will open the connection cleanly.

SSMS: Failed to connecr to an IPC Port (mscorlib) Opening DTA

Failed to connect to an IPC Port: The system cannot find the file specified.  (mscorlib)

1. started DTA.

2. stopped DTA during process.

3. Got error message when trying to restart the DTA on a query.

Solution was to open the Windows Task Manger and Killing DTAShell.exe and the error messsage went away

Creating an instance of the COM component with CLSID Failed

Creating an instance of the COM component with 
CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory 
failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

image

Problem: When trying to edit a job step in SSMS, the above error occurs.

Although not very practical, restarting SSMS eradicates the error but does not prevent it from reoccurring.

A better solution has been very well documented here: http://geekswithblogs.net/NutAndBolts/archive/2008/06/06/sql_server_2005_event_id_208.aspx

UPDATE:

Ive had a reply to this Blog entry from Sethu Srinavisan from the Microsoft SQL Server team which notes that this issue is resolved in SQL Server 2008 SP3, and SQL Server 2008 R2 SP1. Full Details Here

Thanks Sethu!