**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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
