October 5, 2015 at 10:25 am
I've been reading about the protocols and i've been trying to connect to my SQL SERVER using each one of the protocols, but i think I'm missing something, i dont have any problems using Shared Memory and TCP protocols, but I'm not pretty sure how to connect to my remote SQL SERVER using NAMED PIPES protocols. The books On Line of Microsoft refer that you can connect using this protocol using the next syntax:
Connecting to a default instance by specifying a named pipe name:
\\APPHOST\pipe\unit\app
Connecting to a named instance by specifying a named pipe name:
\\APPHOST\pipe\MSSQL$SQLEXPRESS\SQL\query
Connecting to default instance by name, forcing a named pipes connection:
np:APPHOST
Connecting to named instance by name, forcing a named pipes connection:
np:APPHOST\SQLEXPRESS
But I can't connect to my remote SQL SERVER, if i try the same with my local SQL SERVER i don't have any problems. I've been reading the articles so many times searching something about Named Pipes is only for local connections, but Microsoft say that it's posible to connect to a remote SQL SERVER, but i don't know how to do that. The firewall is disabled, I changed the APPHOST in the above syntax for the IP address of my SQL SERVER but it didn't work.. Am i missing something ?? or Is it only for local connections?
Thanks ! Regards ! !
--------------------------------------------------------------------------------
SERGIO SANCHEZ ARIAS
October 5, 2015 at 10:56 am
chancrovsky (10/5/2015)
I've been reading about the protocols and i've been trying to connect to my SQL SERVER using each one of the protocols, but i think I'm missing something, i dont have any problems using Shared Memory and TCP protocols, but I'm not pretty sure how to connect to my remote SQL SERVER using NAMED PIPES protocols. The books On Line of Microsoft refer that you can connect using this protocol using the next syntax:Connecting to a default instance by specifying a named pipe name:
\\APPHOST\pipe\unit\app
Connecting to a named instance by specifying a named pipe name:
\\APPHOST\pipe\MSSQL$SQLEXPRESS\SQL\query
Connecting to default instance by name, forcing a named pipes connection:
np:APPHOST
Connecting to named instance by name, forcing a named pipes connection:
np:APPHOST\SQLEXPRESS
But I can't connect to my remote SQL SERVER, if i try the same with my local SQL SERVER i don't have any problems. I've been reading the articles so many times searching something about Named Pipes is only for local connections, but Microsoft say that it's posible to connect to a remote SQL SERVER, but i don't know how to do that. The firewall is disabled, I changed the APPHOST in the above syntax for the IP address of my SQL SERVER but it didn't work.. Am i missing something ?? or Is it only for local connections?
Thanks ! Regards ! !
--------------------------------------------------------------------------------
SERGIO SANCHEZ ARIAS
Quick question, is the remote server on the same LAN? Can you view any network share (in cmd "net view \\server-name")?
😎
October 5, 2015 at 11:16 am
Yes, it is. It's my virtual machine on Hyper-V. Can i see any network share? I don't know it, I only have this VM on Hyper-V, but I think I can see it, let me test it and I'll tell you.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply