Link Server Connection failure

I have a linked server defined in my SQL 2000 server that connects to an Ora
cle databse that stops working for no apparent reason. Restarting SQL Serve
r fixes the problem. The linked server works fine for months at a time and
then stops working and give
s a login failure message. Nothing gets written to the server event log or
the SQL Server error log.Where do you see the login failed message? What is the exact text of the
login failed message? Once you start getting this message can you use the
Oracle client tools on the SQL Server box to connect to the Oracle instance
using the same login SQL Server is configured to use?
280106 HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
Server
http://support.microsoft.com/?id=280106
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.