October 16, 2006 at 3:25 pm
I'm trying to set up linked servers on my 2005 box back to my 2000 box. I don't quite "get" all the variables for the different connection options. Is there a "basic" setup of options I should choose ??
TIA
October 17, 2006 at 4:40 am
The only things that I set differently than default are the RPC & RPC out server options. By default these are set to False. We do quite a bit of cross server communication so we need the ability to do remote procedure calls (RPC). One other thing I set is the security. We connect to all servers based on a data reader login & then if an admin needs more rights, we setup a local server login & map it to another sql server login. 99% of our cross server communication can be handled by the data reader login.
Just incase you haven't come across this, for a SQL 2005 box to communicate with a SQL 2000 box, you need to run instcat.sql on the 2000 box. Run the InstCat.sql found in the folder of the latest service pack you have installed. If you don't do this, you won't be able to query the 2000 box from the 2005 box.
HTH,
John
October 17, 2006 at 6:15 am
I came across a reference to InstCat elsewhere, but wasn't sure about it. I'm looking at it now, and it runs about a million commands !! A little scary looking
October 17, 2006 at 6:23 am
Yeah, it does do quite a bit of stuff. I didn't have any issues on the 12 servers I had to run it on. It has to be done if you want to communicate with the sql 2005 box.
John
August 6, 2007 at 12:23 pm
Would there be any impact running instcat.sql on a 2000 active passive cluster?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply