Linked Server problem

• Okafor

  Mr or Mrs. 500

  Points: 596

  More actions

  March 9, 2004 at 1:56 pm

  #161233

  I have a SQL 7.0 server that has a linked server to a recently upgraded SQL 2000 server. Before the upgrade, the stored procedures referencing the linked server worked great. Recently we have been experiencing sporatic problems. When trying to execute these stored procedures, we get 'access denied'. The problem is that this does not happen all the time.

  I am thinking that it may be a problem with the versions of MDAC installed on each of the machines.

  We are going to upgrade the 7.0 server in the very near future but I would like to know why this is happening.

  Anyone have any ideas?

  Thanks,

  John

• Okafor

  Mr or Mrs. 500

  Points: 596

  More actions

  March 11, 2004 at 5:56 am

  #498252

  Any takers or have I stumped everyone?

• Roust_m

  SSCoach

  Points: 17410

  More actions

  March 11, 2004 at 6:40 am

  #498262

  Just the same problem...  The only difference is that I upgraded from 32bit MS SQL2000 to 64bit version...