Search This Blog

Wednesday, January 13, 2010

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

Q:
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".

A:
TO Solve the above problem
Open task manager and end the DTASHELL.EXE process,then it should work.
Post a Comment

Popular Posts