Post reply

Communicating To SQL Server 2000 Via TCP/IP

  • August 4, 2008 at 2:14 pm

    #130436

    From my SQL 2005 box, I have added a linked server to SQL 2000. When I run a select statement against the linked server, it is defaulting to named pipes. How can I specify the remote connect be made via TCP/IP?

    In 2000, I simply configured the Client Network Utility. I'm not sure what the equivalent is in 2005.

    Thank you!!

  • August 4, 2008 at 3:54 pm

    #852935

    Are you asking the SQL Server Configuration Manager? We can set up network utility there.

  • August 5, 2008 at 5:03 pm

    #853549

    Thank you, I did end up getting this to work and thought I removed my post. Thanks for the post!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply