Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Link Server Connection Issue

Author  Topic 

anuj.swaransoft
Starting Member

4 Posts

Posted - 2009-02-18 : 02:26:00
Hello,

I am new in this forum.
I have faced problem in sql server 2000

actually i have configured a Link Sever for Oracle in sql server 2000 and its working fine. but issue i have faced that some times link server connection has broken, and when i restart the sql server services then after it working fine. but after few days it shows same link break error. and need to again restart the sql server services.

Please Provide me solution that why link server connection break and how we will keep it connected forever.

I am using latest sql server & Patch (SP4)

its urgent.

Thanks in advance

regards

Anuj Srivastava
   

- Advertisement -