Connection HResult 0xE9, Level 16, State 1 Shared Memory Provider:

[Joe K.]

I have SQL Server 2005 Express Edition that I have created SQL file script
that creates database backups files. The batch file calls the SQL file
script.
When I run the SQL file script in the query windows it completes output an
error. When I run the batch file which calls the SQL file script it outputs
the error message listed below.

Please help me resolve the error listed below.

Thanks,

batch file
sqlcmd -S NMFREE\SQLEP -U sa -P HkdsYHRE312 -i D:\NMFREE\BackupE.sql -o
D:\NMFREE\backup.log

Output Error Message
HResult 0xE9, Level 16, State 1
Shared Memory Provider: No process is on the other end of the pipe.

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

[Rick Byham, MSFT]

I assume this script is running on the same computer that SQL Server is
running on (NMFREE). Otherwise it shouldn't be using shared memory.
On that computer, use SQL Server Configuration Manager to confirm that the
shared memory protocol is enabled as a server protocol.
--
Rick Byham, MSFT
(Implies no warranty or rights)

Post by Joe K.
I have SQL Server 2005 Express Edition that I have created SQL file script
that creates database backups files. The batch file calls the SQL file
script.
When I run the SQL file script in the query windows it completes output an
error. When I run the batch file which calls the SQL file script it outputs
the error message listed below.
Please help me resolve the error listed below.
Thanks,
batch file
sqlcmd -S NMFREE\SQLEP -U sa -P HkdsYHRE312 -i D:\NMFREE\BackupE.sql -o
D:\NMFREE\backup.log
Output Error Message
HResult 0xE9, Level 16, State 1
Shared Memory Provider: No process is on the other end of the pipe.
Sqlcmd: Error: Microsoft SQL Native Client : Communication link failure.

[Erland Sommarskog]

Post by Joe K.
I have SQL Server 2005 Express Edition that I have created SQL file script
that creates database backups files. The batch file calls the SQL file
script.
When I run the SQL file script in the query windows it completes output
an error. When I run the batch file which calls the SQL file script it
outputs the error message listed below.
Please help me resolve the error listed below.
Thanks,
batch file
sqlcmd -S NMFREE\SQLEP -U sa -P HkdsYHRE312 -i D:\NMFREE\BackupE.sql -o
D:\NMFREE\backup.log
Output Error Message
HResult 0xE9, Level 16, State 1
Shared Memory Provider: No process is on the other end of the pipe.
Sqlcmd: Error: Microsoft SQL Native Client : Communication link failure.

Check the SQL Server error log for output that coincides with this message-
Also try running the same script from OSQL, and see how that works out.

To me this seems like something goes wrong somewhere, like SQL Server
killing process because of an internal error. There could also be an
error in the client API (OLE DB), which would explain why it works
in Mgmt Studio which uses ADO .Net. That is also why you should try
OSQL, as OSQL uses a third API, ODBC.