November 26, 2008 at 8:11 am
Need some help with a linked server issue. We have a linked server setup and it will work fine for a while and then all of a sudden the RPC and RPC out setting will be changed from True to False. Only a few of us have access to change these settings and everyone swears not to have touched them. This has happened 4 or 5 times in the last year or so. Anyone know of a server setting I can set that would make these True as default? Any other idea how\why these setting get changed? I'm at a loss.
November 26, 2008 at 8:27 am
Can you give more information on your problem like what versions of SQL server are being used, are the servers located on the same network and same location, what service packs/patches on each etc.
In the mean time I would ensure that all the servers in question have the latest service pack/patches. Reboot the servers and see how it goes from there.
Good luck,
Rudy 🙂
Rudy
November 26, 2008 at 8:31 am
Both servers are SQL 2005 sp2 with SQL update 8. Same network, diff locations. Servers are rebooted every Sunday.
November 26, 2008 at 8:40 am
Very strange. I might write a routine to capture the sp_configure settings every hour or so and report if it's changed. That will help you narrow things down to see if this occurs regularly and when.
November 26, 2008 at 9:27 am
Check for any SSIS pkg or agent job running in background which drop/create linked servers and it has these RPC settings set to FALSE?
MJ
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply