Named Pipes - TCP/IP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Named Pipes - TCP/IP

Author

Topic

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 03:29:20

The Server Network Utility has the 2 protocols enable and the order is
first Named Pipes, second TCP/IP.
The Client Network Utility says the contrary, first is TCP/IP, second is Named Pipes.
Is that normal?

All the clients use TCP/IP for the connection.
How can I see if Named Pipes are working?

Please advise.

Franco

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-20 : 03:49:42

The easiest way to see is to connect from a client using the name. If it connects, then it is working.

Oh, and yes it is normal.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 04:05:25

Thank you very much for yaour reply.
What do you mean "connect from a client using the name"?
Do you mean with Query Analyzer?
Please advise.

Franco

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 04:42:29

I have tryied makepipe and readpipe.
The connection works if, when using readpipe, if I use the physical server name.
But our configuration is on MSCS 2 nodes Cluster.
If I use the virtual name the connection fails.
Is that normal?

Franco

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-12-20 : 05:03:12

quote:
Originally posted by RickD

The easiest way to see is to connect from a client using the name. If it connects, then it is working.

Oh, and yes it is normal.

that doesn't make sense and is a completely inaccurate answer. named pipes has nothing to do with connecting by name.

Anyway, the easiest method to test a named pipes connection is to create an alias for your sql server using the client network config utility. You can run this from the command line on your client system by typing 'cliconfg'

You will need to click on the alias tab and then type in the hostname of the sql server you are wanting to test. make sure that named pipes is selected on the left side of the window. Be sure to select a name that is different than the actual hostname you are testing so you can be sure that you are actually testing the alias you have created.

after creating the alias you can go to enterprise manager or query analyzer or management studio and connect to the sql server using the alias name. once you have established a connection you can look at the active connections to see if your connection is using named pipes or not.

-ec

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 05:19:33

OK, I have created
1)new alias : "test_named_pipes"
2)Server name: the name of the virtual server name (not the physical one)

The connection fail!

If I use the physical name the connection fail also.

But with makepipe and readpipe I have different results, see my previous post.
Please advise.

Franco

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-12-20 : 05:23:25

create a new tcp/ip alias to the virtual host. does that work?

-ec

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 05:26:49

yes, this works.

I don't know if this is related to the problem but this is happening after a reboot of the server last week.

Here are the errors we have:

Error: 17882, Severity: 18, State: 1

Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing..

Error: 17059, Severity: 18, State: 0

Operating system error 233: No process is on the other end of the pipe...

Please advise.

Franco

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-12-20 : 05:37:34

ok, more questions:

1. have you tested the named pipes alias on another workstation? maybe your workstation is actually having a problem
2. are you current with service packs for the OS and the SQL Server? Have you installed the latest SQL Server service pack on your workstation to update your client tools?
3. when creating the named pipes alias, does the pipe name in the cliconfg utility match the pipe name you see in the server network utility?
4. are you connecting to a named instance?
5. any firewalls between your client workstation and your sql server?
6. If you look in the current sql error log, is there a line stating that sql is listening on tcp/ip and named pipes?

-ec

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 05:53:30

1. yes, tested on another client, same result.
2. yes
3. yes
4. I am connecting to a virtual server, it is a Cluster with only a default instance (active/passive)
5. no
6. yes

and this is the string on the SQL Server Network Utility

\\.\pipe\$$\VSRVSQL\sql\query

Please advise.

Franco

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 10:49:03

anyone else?
any clue?

Franco

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-20 : 16:15:24

Checked Microsoft kb article 919710?

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-20 : 16:39:25

The MS article refer to SQL Server 2005.
We have SQL Server 2K.

any idea?

Franco

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-20 : 17:43:11

Concept is same.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-21 : 04:54:44

Yes the concept may be the same but I don't find the registry key on the Server.
The reg key referred by the article is:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

I don't have this key, so I don't think this KB applies to our environment.
In any case I am not able to apply the workaround suggested by Microsoft.

The strange thing is that, before the server reboot of december 7, the named pipes works perfect.
After the reboot we find these errors:

Error: 17882, Severity: 18, State: 1
Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing..
Error: 17059, Severity: 18, State: 0
Operating system error 233: No process is on the other end of the pipe...

and after that, no more named pipes

So I am stuck....
Please advise.

Franco

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-12-21 : 10:07:26

you'll most likely need to open a ticket up with microsoft on this then. this doesn't look like a problem common enough for you to get any real assistance here.

-ec

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2007-12-21 : 10:36:56

Ok, I would like to thank you all anyways for your help.
Kind regards.

Franco

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-21 : 14:02:01

Those error messages sound like tcp/ip netlib issue, there are several kb articles regarding error 17882 on sql2k.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources