Problem running scripts against SQL Server

Question

We have some scripts that we run as part of our unit tests.

This worked fine until today.

We have tried running scripts with both windows and sql authentication.
We have no problems logging in using sql manager

Anybody have any ideas why we get the following error:

Shared Memory Provider: No process is on the other end of the pipe.

Sqlcmd: Error: Microsoft SQL Native Client : Communication link failure.

Thanks

Shiraz

EDIT

Thanks for the replys. The actual appears to be a password problem, which used up all the connections. The process was not listening because there were no available connections.

Ricardo Sanchez · Accepted Answer · 2009-10-23 14:03:01Z

1

Look in SQL Server Configuration Manager and make sure the protocols you are using to connect to it are setup correctly. I suggest you enable "Shared Memory" and "TCP/IP".

answered Oct 23, 2009 at 14:03

Ricardo Sanchez

6,3193 gold badges27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Philip Kelley · Accepted Answer · 2009-10-23 14:10:29Z

1

Ask around, try and determine what was changed on your environment--by who, and how--that caused a working process to stop working. If succesful, you will (a) have a strong lead on discovering the details of what's going wrong, and (b) be in a position to ensure it doesn't recur. (Just solving the tech side might not prevent it from happening again...)

answered Oct 23, 2009 at 14:10

Philip Kelley

40.5k11 gold badges62 silver badges93 bronze badges

Collectives™ on Stack Overflow

Problem running scripts against SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related