Thanks for the response, Joe. There should be sufficient number of connections available because I can query via SQL Analyzer without issue.
I am almost thinking that some change has blocked part of my RPC packet or something. They can see my connection coming in, but they cannot see the data I'm trying to send to the server. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, March 13, 2007 8:38 AM To: [email protected] Subject: Re: MS SQL Linked Server error 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. 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 ________________________________ TV dinner still cooling? Check out "Tonight's Picks" <http://us.rd.yahoo.com/evt=49979/*http:/tv.yahoo.com/> on Yahoo! TV. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
