In an effort to do some testing prior to upgrading our environment to 2008 R2, I made a test instance on our Dev box. 2005 instance, copied as many things as I could think of from various other instances. Made a basic linked server to our main
cluster, had a repeating job to email me results of a query across that link every few hours.
Everything was working fine until the upgrade finished. It completed at ~7pm. The email at 6PM came through fine (while the upgrade was in progress), the email at 8pm didn't come through. Checked various things (DB mail was still working,
tested fine). It couldn't access the data across the linked server. I tried deleting that link and remaking it. Errors out. Tried running the same scripts we use to create our standard linked servers, error out. The only ones
that I can set up and function are links to other instances on the same box.
I've looked around at other fixes for this error message and none seem to make any difference. Log in with Domain cred's, log in with the sa account, no difference. I can connect from other instances & servers back to this one, just not outbound
from this one. And it worked prior to the upgrade I applied to it. All other instances on the box are 2005 as well.
Here is the message I ge
View Complete Post