Rem, thanks for the response. I'm reading up on the article now. The server and the MS SQL are the same, both Windows 2K and MS SQL 2k
I was told the night before this started happening that there was some change done on the remote server that affected FTP. My connection is using RCP, so I'm not sure if that could/would be related, but it is looking awfully peculiar. Below are some of the errors from my logs. Mon Mar 12 08:07:11 2007 Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (<LocalServer>) ARERR - 94 Mon Mar 12 08:54:20 2007 390635 : Failure during SQL operation to the database (ARERR 552) Mon Mar 12 08:54:20 2007 [DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation. (SQL Server 11) Mon Mar 12 08:54:39 2007 390635 : Failure during SQL operation to the database (ARERR 552) Mon Mar 12 08:54:39 2007 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17) Mon Mar 12 08:54:39 2007 390635 : SQL database is not available -- will retry connection (ARNOTE 590) Mon Mar 12 10:37:48 2007 Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (<LocalServer>) ARERR - 94 The weird thing is that today there are no logs at all being generated, so I'm not sure exactly why. I think the SQL Server 17 above was different. I had deleted my link and rebuilt it, but used the wrong driver at one point. Any help would be greatly appreciated as this is starting to really affect my customers. Thanks! Gary ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rem Valenzuela Sent: Monday, March 12, 2007 8:58 PM To: [email protected] Subject: Re: MS SQL Linked Server error What version is the other server O/S and SQL version? I ask because there seem to be issues with the MS Distributed Transaction Coordinator, SQL and versions of W2K server and W2K3 Server. In our situation, we were able to return results using Query Analyzer, but Remedy wouldn't work or only send partial data. The other symptom we had was that when restarting the Remedy Service, the service would timeout. When we ran SQL logs during service restart, the logs paused when the server tried to connect to remote db, I think to the sysobjects table. In any case, many of the issues were resolved once we found this MS KB article. http://support.microsoft.com/kb/306212 Hope it is as helpful to you as it was to us. ________________________________ Date: Mon, 12 Mar 2007 15:10:50 -0500 From: [EMAIL PROTECTED] Subject: Re: MS SQL Linked Server error To: [email protected] ** **Bump** Additional Information: My MS SQL DBA says he can see my connection, but is not seeing any query being passed. In addition to this, if I log into SQL Query Analyzer (as the same user that remedy uses) to run the query , he can see the query being sent, and of course, it does work. ________________________________ From: Opela, Gary L Contr OC-ALC/ITMA Sent: Monday, March 12, 2007 10:25 AM To: '[email protected]' Subject: MS SQL Linked Server error MS SQL 2k Windows Server 2k Remedy 6.3 unpatched Microsoft XP Workstation Here is the scenario. I've set up a link between my database and another database using. In remedy, whenever I hit <enter> on a field, then remedy sends a query to that linked database based on the values in that field. This morning remedy began just hanging for several minutes after hitting <enter> and then it returns a server busy error. I have rebooted the server and this does not seem to help. I've re-entered the userid and password values from the Security -> Linked Servers -> <servername> -> Properties -> Security tab and still no luck. I can use that same userid, however, to log directly into the linked server and execute a query. I can also log directly into my primary database and execute a query that is referencing the linked server. I've checked with my DBA and he can see my database connection coming in successfully. It's just like for some reason the data cannot be returned. Any ideas why everything BUT remedy works? Thanks, Gary __20060125_______________________This posting was submitted with HTML in it___ ________________________________ Explore the seven wonders of the world Learn more! <http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBR E> __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
