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 -0500From: [EMAIL PROTECTED]: Re: MS SQL Linked Server errorTo: [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 AMTo: 'arslist@ARSLIST.ORG'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 http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"