April 15, 2008 at 11:22 am
I am trying to connect to server from my local machine. But it shows me a message saying named pipes error. The ports are opened alredy for connection. I checked Surface area configuration and found remote connection is set for TCP only.
Can some one help me.
April 15, 2008 at 2:55 pm
Did you register the server first ?
April 16, 2008 at 9:23 am
the server "listens" on one/many network protocols/ports, so clearly your client-side must pick [at least one of] those [via network/aliasses part of sql config tool]
some SQL installs (especially SQLEXPRESS) deliberately default to not listening on network ports
- ie just listen for local memory-based (ie lightweight procedure call)
so if your SSMS client-side is using NP and IP but server-side is only using local, you will fail
note that if you open up IP or other protocols you will need to cycle the SQLservice to take effect
- it does tell you that on the dialog box but you'd be suirprised how many people don't read it !
HTH
Dick
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply