Linked Server 2000 vs Server 2003

• Cary P. Thrasher

  Mr or Mrs. 500

  Points: 559

  More actions

  October 21, 2004 at 8:29 am

  #86787

  I have a situation, need some help with concerning Linked Servers. We setup Linked Servers and extract drive data from each one nightly. One server, our newest, is 2003 version, and in using this one, every time we try the same procedure (which works fine on our 2000 servers) we get a time-out after a long period or end up canceling the query. Is there an unknown issue with this type of server. We are using xp_FixedDrive extended procedure to obtain our drive data.  

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  October 22, 2004 at 5:16 am

  #527621

  I assume you're making an rpc call?  e.g.  exec server.master.dbo.xp_fixeddrives ?

  I don't see any issues between 2003 and 2k based sql servers.

  Using QA can you run an sp_who on your remote server? That's my base test.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• laker_42

  SSCarpal Tunnel

  Points: 4785

  More actions

  October 22, 2004 at 7:07 am

  #527637

  1. If this is a Windows 2003 server, you need to enable Network DTC Access using the following process:

  1.      Click Start, point to Control Panel, and the click Add or Remove programs

  2.      Click Add/Remove Windows Components

  3.      Select Application Server, and then click Details

  4.      Select Enable network DTC access and then click ok

  5.      Restart the server

   

  Make sure that you have done this.  It won't work if you haven't.

   

   

  HTH,

  John