Gary, On your remote database, are there sufficient number of user connections available to connect to? If not this 'might' be the reason it is timing out? Joe
----- Original Message ---- From: "Opela, Gary L Contr OC-ALC/ITMA" <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, March 12, 2007 4:10:50 PM Subject: Re: MS SQL Linked Server error ** **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. Ive 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. Ive 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. Ive checked with my DBA and he can see my database connection coming in successfully. Its just like for some reason the data cannot be returned. Any ideas why everything BUT remedy works? Thanks, Gary ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
