dbTalk Databases Forums  

tcp/ip vs named pipes

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss tcp/ip vs named pipes in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Fabio Martins
 
Posts: n/a

Default tcp/ip vs named pipes - 07-08-2008 , 09:58 AM






Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM



Reply With Quote
  #2  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM






What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #3  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #4  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #5  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #6  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #7  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #8  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #9  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
  #10  
Old   
Linchi Shea
 
Posts: n/a

Default RE: tcp/ip vs named pipes - 07-08-2008 , 12:06 PM



What's error message and how did you connect via tcp/ip? I'd start by trying
to connect to a different server instance using tcp/ip from teh machine that
runs App2 just to make sure there is no problem with the SQL client tcp/ip
connectivity setup/conifguration. Then, try to connect to the SQL Server
instance using just its IP address (plus port number). If that works, you
have a name resolution problem. If that doesn't work, you need to start
troubleshoot the network layer.

Linchi

"Fabio Martins" wrote:

Quote:
Hi Guys... I have 2 aplications App1 and App2.

App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!

App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip
App2 access Server2 (Sqlserver std 2000 SP3) through named pipes OK!

Access Config on Server1 and Server2 are identical.
I'd like app2 access server 2 through tcp/ip.
How can I solve that?

FM




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.