101 reputation
bio website
location
age
visits member for 3 years, 11 months
seen Oct 10 '11 at 13:52

Sep
21
comment SQL 2008 R2 Active/Active/Passive Cluster Does Not Allow Linked Servers Both Ways
Turns out it was the windows firewall that was the culprit. It was only active on one node, and everyone else was freaking out about it. Disabled it and voila! No more linked server timeouts.
Sep
20
comment Windows 2008 SQL cluster won't come online after db failure
Yep, that fixed it! We bounced the whole thing and removed that resource and now I can at least get into the instance. Sheesh.
Sep
20
asked Windows 2008 SQL cluster won't come online after db failure
Sep
9
comment SQL 2008 R2 Active/Active/Passive Cluster Does Not Allow Linked Servers Both Ways
There's nothing in either the SQL error logs or the Windows event logs on either node that's even close to this issue. :( I even tried recreating the linked server so I could trigger an event but nothing was logged.
Sep
9
asked SQL 2008 R2 Active/Active/Passive Cluster Does Not Allow Linked Servers Both Ways