May 19, 2003 at 7:43 am
I have SQL 2K SP3 running on two servers. On server A, I have a link to server B using linked servers. The link has been working fine for a long time.
Over the weekend, server B needed a software upgrade and was rebooted as a consequence. It was up and running this morning when I came into work.
However, server A could not communicate with server B quoting 'General Network error. Check you network documentation'
I solved the problem by recycling the SQL Service on server A and it is now working fine again.
Is this normal behaviour? Is there any way I can prevent these problems or do I have to recycle the server on server A whenever server B reboots?
Jeremy
May 19, 2003 at 8:32 pm
I have not run into this issue previously and use linked servers extensively. By chance, are your servers using DHCP rather than a static IP address? I would check their network configuration closely, in particular their DNS settings.
David R Buckingham, MCDBA,MCSA,MCP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply