MS SQL Server - No process is on the other end of the pipe SQL 2k5

Author

No process is on the other end of the pipe SQL 2k5

Joe

2006-01-26, 4:53 pm

SQL Server 2005 Developer Edition, running on Server 2k3/SP1 (not a domain
controller). Setup with pretty much all defaults. When accessing the
server using sqlcmd (both client and server running locally), I get the
following error on a regular basis . Seems to require me to restart SQL
Server to "reset" the problem. Is this a known problem? Is there a fix?

Thanks,

Joe

C:\>sqlcmd -U User1
Password:
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.

John Bell

2006-01-26, 4:53 pm

Hi

You may want to check out this post http://tinyurl.com/dvo9e

John

"Joe" wrote:

> SQL Server 2005 Developer Edition, running on Server 2k3/SP1 (not a domain
> controller). Setup with pretty much all defaults. When accessing the
> server using sqlcmd (both client and server running locally), I get the
> following error on a regular basis . Seems to require me to restart SQL
> Server to "reset" the problem. Is this a known problem? Is there a fix?
>
> Thanks,
>
> Joe
>
>
> C:\>sqlcmd -U User1
> Password:
> 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.
>
>
>
>

Joe

2006-01-27, 3:23 am

Hi John -Thanks for the link. Unfortunately, I have reviewed it, and I dont
think it applies to my situation.

- My problem is not in the installation step, it occurs "sporadically" (but
I can usually get it to happen) while using sqlcmd.
- I have looked through all my SQL logs, and there is nothing mentioned
similar to what that post was about. I do get a message that a self
generated certificate was correctly created and installed.
- The problem seems to disappear when I disabled shared memory and only use
named pipes (which is my workaround for now).

Thanks again for your reply, it is appreciated.

Joe

"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:0C92C51E-8406-4357-B43D- 122E9F46A644@microso
ft.com...[color=darkred]
> Hi
>
> You may want to check out this post http://tinyurl.com/dvo9e
>
> John
>
> "Joe" wrote:
>

Michael Cheng [MSFT]

2006-01-27, 3:23 am

Hi Joe,

Welcome to use Microsoft MSDN Managed Newsgroup!

From your descriptions, I understood you connection to SQL Server 2005 Dev
Edition will failed with error message "Shared Memory Provider: No process
is on the other end of the pipe." via SQLCMD. If I have misunderstood your
concern, please feel free to point it out.

Would you please help me narrow down this issue with the answers to the
questions below?

1. You are connecting to the instance remotely or locally?
2. Have you tried using SQL Server Management Studio to connect the
instance?
3. If you use Windows Authentication to connect the instance via SQLCMD,
will it also report the same error message?
4. Is it possible for you to find any other logs related in Error Logs and
Event Logs?

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Joe

2006-01-27, 3:23 am

Hi Michael -

Thanks. Yes, you understand my question correctly.

1) I am connecting to the instance locally (ie, sqlcmd is running on the
same machine that the server is)
2) No, I havent. Is that part of SQL2005? I dont seem to see it in my
programs group. Sorry, I am VERY new to SQL2k5.
3) Windows Authentication : I am not sure. I will try it and see if once
the server gets into this state (giving error messages to SQLCMD -U
username), if it will work with SQLCMD -E).
4) I have looked through all of the SQL logs, and there are no error
messages (aside from the error messages that say something about the server
shutting down, and this error can be safely ignored).

I will find an answer to #4 as soon as I get back to the office.

Thanks for your help.

Joe

"Michael Cheng [MSFT]" <v-mingqc@online.microsoft.com> wrote in message
news:KkSgshwIGHA.1236@TK2MSFTNGXA02.phx.gbl...
> Hi Joe,
>
> Welcome to use Microsoft MSDN Managed Newsgroup!
>
> From your descriptions, I understood you connection to SQL Server 2005 Dev
> Edition will failed with error message "Shared Memory Provider: No process
> is on the other end of the pipe." via SQLCMD. If I have misunderstood your
> concern, please feel free to point it out.
>
> Would you please help me narrow down this issue with the answers to the
> questions below?
>
> 1. You are connecting to the instance remotely or locally?
> 2. Have you tried using SQL Server Management Studio to connect the
> instance?
> 3. If you use Windows Authentication to connect the instance via SQLCMD,
> will it also report the same error message?
> 4. Is it possible for you to find any other logs related in Error Logs and
> Event Logs?
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ====================
====================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

John Bell

2006-01-27, 3:23 am

Hi

If you are using SQLExpress you may want to download Microsoft SQL Server
Management Studio Express

http://www.microsoft.com/downloads/...&displaylang=en

John

"Joe" wrote:

> Hi Michael -
>
> Thanks. Yes, you understand my question correctly.
>
> 1) I am connecting to the instance locally (ie, sqlcmd is running on the
> same machine that the server is)
> 2) No, I havent. Is that part of SQL2005? I dont seem to see it in my
> programs group. Sorry, I am VERY new to SQL2k5.
> 3) Windows Authentication : I am not sure. I will try it and see if once
> the server gets into this state (giving error messages to SQLCMD -U
> username), if it will work with SQLCMD -E).
> 4) I have looked through all of the SQL logs, and there are no error
> messages (aside from the error messages that say something about the server
> shutting down, and this error can be safely ignored).
>
> I will find an answer to #4 as soon as I get back to the office.
>
> Thanks for your help.
>
> Joe
>
>
> "Michael Cheng [MSFT]" <v-mingqc@online.microsoft.com> wrote in message
> news:KkSgshwIGHA.1236@TK2MSFTNGXA02.phx.gbl...
>
>
>

Michael Cheng [MSFT]

2006-01-30, 3:23 am

Hi Joe,

Thanks for the update.

1. When connecting to the SQL Server 2005, you should make sure
- You have started SQL Server 2005 (using SQL Server Management
Configuration)
- You could connect to the instance with Windows Authentication

2. All default installation of SQL Server 2005 Dev Edition will install SQL
Server Management Studio. Would you please double confirm that you have
installed Dev Edition or Express Edition?

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Sponsored Links