Here is the SQL Errors - from arsql.log WARNING * The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. (SQL Server 7391)OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].[OLE/DB provi ROLLBACK TRANSACTION ERROR *** The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) It appears that it is a MSDTC issue for Windows 2003 server. I had to change the Security Configuration on the MSDTC on the new server. Eric W Dunn Programmer Analyst III - Remedy/Collaboration (281)465-1265
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, December 05, 2006 1:07 PM To: [email protected] Subject: Re: SQL Menus Issue ** What SQL error do the arsql logs show? Axton Grams On 12/5/06, Dunn, Eric <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: ** I am a little perplexed... I am in the process of migrating from one server to another for an hardware & application upgrade - newer, better, faster hardware. Windows server 2003 SQL 2000 ARSystem 5.01.03 I have built the new server. Loaded SQL server. Loaded AR System. Taken a copy of the database backup from the original server and restored from back up. After restoring, I ran the sp_changedbowner ARAdmin , true command to reassign ARAdmin as the owner. Here is my issue - I have a particle menu - it is a sql query to another server pulling employee information. I have linked the servers together in the same manner as the original. The query does not pull anything back in the client, but if I run the sql query in query analyzer it works.. What am I missing? Eric W. Dunn Programmer Analyst III - Remedy/Collaboration McLeod USA, Inc. - Network Engineering 8665 New Trails Dr. The Woodlands, TX 77381 (281)465-1265 (281)465-1951 fax NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
