SQL SERVER –FIX- Error- Failed to connect to an IPC Port: The System cannot find the specified path.- Database Engine Tuning Advisor (DTA).

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 .

print

10 thoughts on “SQL SERVER –FIX- Error- Failed to connect to an IPC Port: The System cannot find the specified path.- Database Engine Tuning Advisor (DTA).

  1. Author’s gravatar

    Thanks for that! It happens from time to time, and has been very annoying.

    James

  2. Author’s gravatar

    Thank you man! It solved my problem and made it slide!!

  3. Author’s gravatar

    thnks it work’s for me…………:)

  4. Author’s gravatar

    Thank you so much. This solved so much of headache.

  5. Author’s gravatar

    Thank you so much!! It resolved my problem too. Appreciate the help!!

  6. Author’s gravatar

    Thank you very much sir !!!!!!!!!!

  7. Author’s gravatar

    Thank you, this solved it for me!

  8. Author’s gravatar

    Thanks it worked !

  9. Author’s gravatar

    Thank you!! It worked for me.

  10. Author’s gravatar

    Thank You very much.
    Simple advice but solved the unpleasant problem.

Leave a Reply

Your email address will not be published. Required fields are marked *


× seven = 21