Named Pipes and TCP-IP

Hi All

We have a web server (using IIS 5.0 and SQL Server 2000) that uses only TCP-IP as its network protocol and we are filtering out all but 4 ports. We are using Named Pipes as our NetLib. When we try to connect to the server from another machine using Named Pipes, we run into a "SQL Server Not Found" type of error. Is this because of the filtering or is there something else going on behind the scenes?

Thanks in advance.

Clayton
GatsbyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Droby10Connect With a Mentor Commented:
named pipes rely on access to the IPC$ share so you would have to open up tcp 139...if you're attempting to connect via the nbtname, then you will also need name resolution in the form of a lmhosts entry, wins and/or nbtname port udp 137.

if you already have these enabled, then:

after getting the error message, try the following on the client machine

net use \\[servername]

if you get a message asking for username and password then
reissue the command with the appropriate parameters
net use \\[servername] [password] /user:[username]

if it succeeds then retry to connect...it _should_ work as you now have a session token with which to use to connect to a named pipe...

0
 
geoffrynCommented:
Why are you using named pipes instead of TCP/IP?  Is 1433 one of the open ports?
0
 
SysExpertCommented:
listening....
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
GatsbyAuthor Commented:
Hi Again

1433 is closed but there is no reason why we couldn't use the TCP-IP netlib. This is more an academic question. I'm not quite sure of the differences between TCP-IP (Network protocol) TCP-IP (Net-Lib) and Named Pipes. I am just looking for clarification on exactly why I can't get to the server using Named Pipes. I suspect it is the TCP-IP filters but I'm not sure. I guess the real queestion is....do the TCP-IP filters in place block Named Pipes?

Thanks!
0
 
geoffrynCommented:
They will. SQL still requires the port to be open unless you are using IPX.
0
 
GatsbyAuthor Commented:
Thanks Droby...that was exactly what I needed to know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.