Today when I was working on a Performance Tuning Project, I tried to open the Database Engine Tuning advisor, I got an error,” Failed to connect to an IPC Port: The System cannot find the specified path”. This is a common error if we have previously stopped the DTA(when it is executing) or disconnected from the network while DTA was running.
We can resolve this issue by,
Open windows task manager -> under that kill DTASHELL.EXE.
After doing this Fix, we can simply connect the Database Engine Tuning Advisor without any error .
James Hunter Ross
13 years agoThanks for that! It happens from time to time, and has been very annoying.
James
Guilherme Alves Rodrigues
13 years agoThank you man! It solved my problem and made it slide!!
hmd
13 years agothnks it work’s for me…………:)
Chaminda
13 years agoThank you so much. This solved so much of headache.
developer
13 years agoThank you so much!! It resolved my problem too. Appreciate the help!!
Krunal Patni
13 years agoThank you very much sir !!!!!!!!!!
Jojo
13 years agoThank you, this solved it for me!
Zainab
13 years agoThanks it worked !
Metho
13 years agoThank you!! It worked for me.
Tankard Essou
13 years agoThank You very much.
Simple advice but solved the unpleasant problem.