TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to connect to an IPC Port: The system cannot find the file specified.
(mscorlib)
------------------------------
BUTTONS:
OK
------------------------------
32bit/x86 standard edtion, build 2047 (sp1)
Launching DTA via "analyze in DTA" context option in SQL Editor failing
clint 2
KevinBurton
Has anyone found a solution I get the same error in a production environment after I installed SP1 (build 2047).
Alexander
Simone1
Did you find a fix for this I get the same thing. Here is my stack trace:
===================================
Failed to connect to an IPC Port: The system cannot find the file specified.
(mscorlib)
------------------------------
Program Location:
Server stack trace:
at System.Runtime.Remoting.Channels.Ipc.IpcPort.Connect(String portName, Boolean secure, TokenImpersonationLevel impersonationLevel, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.ConnectionCache.GetConnection(String portName, Boolean secure, TokenImpersonationLevel level, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.SqlServer.Management.UI.VSIntegration.ISessionController.CreateSessionFromQuery(SqlConnectionInfo connectionInfo, String sqlQuery, String batchSeparator)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnDatabaseTuningAdvisor(Object sender, EventArgs a)
MessiahAndrw
Thanks Alexander for the details. The error seems to be different from the one I was referring to.
Can you please check the following:
- does the problem repro every time or only occasionally
- does the problem go away if you launch an instance of DTA between steps 3 and 4 of your repro
Thanks,
jeff1024
Hello Maciek!
Here comes more information:
OS: Windows Server 2003 (Standard Edition) with SP1
SQL Server: SQL Server 2005 Standard Edition with SP1 (Version 9.00.2047.00)
Platform: Intel x86
Steps to get the error:
1) Start SQL Server Management Studio
2) Press the "New Query" button
3) Write a query
4) Select from the menu "Query -> Analyze query in Database Engine Tuning Advisor"
5) You get the "Failed to connect to an IPC Port: The system cannot find the file specified. (mscorlib)" error
Let me know if you need any more information!
Regards,
Alexander
F.Costa
You first problem (the error in IDC connection) is then some timing issue between SSMS and DTA. Please open a defect for it using connect.microsoft.com site.
The second problem (CRT error) is a known issue on Windows Server 2003. The fix will be in the next version of Windows and the workaround is documented in this KB article: http://support.microsoft.com/Default.aspx kbid=913395
Regards,
sontek
Could someone provide more details on steps that lead to the error We've seen this error occasionally in the following scenario:
- DTA GUI is started wither from SSMS or manually
- DTA GUI is closed by user
- An attempt is made to tune a query from SSMS Query Editor window.
In this case an IPC call between SSMS and DTA fails because of timing issues. The problem lies in IPC communication layer and cannot be fixed by us. The workaround usually is to wait a few minutes and try again.
I have not seen this problem to occur all the time, and I do not think it is related to particular version of SQL Server 2005 (RTM or SP1).
Regards,
Foolios
Hello!
The error comes every time, it doesn't help for example to select "Analyze query in Database Engine Tuning Advisor" several times.
But it did help to launch an instance of DTA between steps 3 and 4. Then I didn't get the "Failed to connect to an IPC Port..." error. But when I pressed the "Start Analysis" button I got another error:
Title of the window: Microsoft Visual C++ Runtime Library
Error message:
Runtime Error!
Program: D:\Progr...
R6031
- Attempt to initialize the CRT more than once.
This indicates a bug in your application
It happens when DTA is trying to perform the first action (Submitting Configuration Information).
Regards,
Alexander
PS. Yesterday I had to install this hotfix to be able to start the Integration Services service: http://support.microsoft.com/kb/918644
Ashish Vyas
Hi..
What you have written in your post is the exact error I ma getting, and the setps you laid are exactly the sequence they ocurred for me.
Is there a solution for this.
I agre with you that I don't think this is a SQL SErver 2005 DB issue, but may be a Studio Managment issue.
Any thoughts.
Sincerly,
Asad
ralanjackson
SP1 is build 2047. I've only seen this error in a pre-release SP1 build (2045). Can you double check your build numbers
-Paul
melberti
I was getting this same error. Following is how I was able to produce this issue:
1. From management Studio, open a query click on toolbar option to open Database Engine Tuning Advisor.
2. Started analysis on my query.
3. While the performing analysis step was running I stopped analysis.
4. Before letting the process completely fail I closed the Tuning Advisor window.
5. The next time I tried to access tuning advisor it was not available. Error message:
Failed to connect to an IPC Port: The system cannot find the file specified.
(mscorlib)
6. I figured maybe it would just take some time for it to become available, but the next day I tried again and it still was not available.
7. I tried restarting services in SQL and it did not fix the issue.
8. By rebooting the box I was able to get back the the analyzer and cleared the error.
Luckily I'm not working in a production environment right now, but hopefully this will help someone figure out another way to fix the issue.
SQL Server 9.00.3200.00 SP2 Developer Edition (64-bit)