Ok....I am now running ARS 6.3 Patch 19 SQL Server 2000 SP4 Windows 2003 (Latest Patches) I am still getting this error but I was able to track it down today. It appears that there is an escalation firing on a remedy form that does a setfield from a view form. That view form is a view pointing to a linked server. That linked server is using an Oracle OLE connection that doesn't exist on this box (dev gets dumped from prod periodically)...thus...Remedy can't use it's view form...and is causing this error every 30 seconds until the remedy server is restarted.
_____ From: L. J. Head [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 10:22 AM To: '[email protected]' Subject: RE: Strange SQL Error Looks like we were still strangely unpatched...I took it up to SP4 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mahesh Patil Sent: Tuesday, January 09, 2007 9:39 AM To: [email protected] Subject: Re: Strange SQL Error ** Hi, You can go through the following URL http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx If I am not wrong then this has been fixed with SQL service pack 3. Best Regards, Mahesh ----- Original Message ---- From: L. J. Head <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, January 9, 2007 8:32:42 PM Subject: Strange SQL Error ** ARS 6.3 Windows 2003 SQL Server 2000 For awhile we have been receiving this error on our dev system...when it occurs it happens every 30 seconds...a bounce of the arsystem service brings dev back to functionality...remedy resides on separate box from db...any suggestions? Tue Jan 09 07:54:14 2007 390603 : Failure during SQL operation to the database (ARERR 552) Tue Jan 09 07:54:14 2007 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17) Tue Jan 09 07:54:36 2007 390603 : Failure during SQL operation to the database (ARERR 552) Tue Jan 09 07:54:36 2007 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17) __20060125_______________________This posting was submitted with HTML in it___ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
