We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Passive Cluster Drops Linked Server Connection

Medium Priority
492 Views
Last Modified: 2012-05-07
I have a passive cluster with SQL 2005, running on 2003 Enterprise Server, I am attempting to connect a linked server which is also running SQL 2005, on 2003 Enterprise Server. I can successfully connect using the SA username and password, but within an hour I permanently lose connection to the linked server from the clusterd environment. I have verified that both servers in the cluster have the link server set up.

In recap - Server A is a single instance server running SQL 2005 on 2003 Ent, I am attempting to connect to it from a passive clustered SQL 2005 on 2003 Ent environment. I lose connection within an hour, and have to completely rebuild the linked server connection.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Hi concretesailors,
This does not sound right at all, is there some kind of server level trigger or task that has been configured to remove things like this for maintenance purposes or the like?  I can think of nothing that would do this automatically.
The code below queries the servers view in the master database, when you are setup you should see it appearing in here.  Does anyone else have access who might want to remove these?  Have you tried adding the linked server details to another server to confirm the same does not happen there?

SELECT * FROM master.sys.servers order by name

Open in new window

Senior Database Administrator
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT

Commented:
If the connection remains stable try increasing the time period of your job doing the query - I would be interested to know when/if it disappears...
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.