Search This Blog

Wednesday, January 13, 2010

Database Engine Tuning advisor failed to connect to ipc port in Sql server

In Mangagement Studio i highlight my query and then click on 'Analyse query in Database Engine Advisor' but i get the following error message: "Failed to connect to an IPC Port: The system cannot find the file specified".

TO Solve the above problem
Open task manager and end the DTASHELL.EXE process,then it should work.

Popular Posts