Hello, We have Linked Servers set up on our SQL database and can successfully write to the related View Forms. We've had this working for years. Now, when trying to set up a new Linked Server and process, we are getting the following DTC error:
ARERR [552] The SQL database operation failed. : The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "SSASVR1" was unable to begin a distributed transaction. (SQL Server 7391)OLE DB provider "SQLNCLI10" for linked server "SSASVR1" returned message "No transaction i Of course, we can write to it at the database level but not through Remedy. I have gone through all the usual steps to resolve this but have not been successful. I'm thinking that the problem has to be on the external database because Remedy is successfully writing to the historical databases. DTC is definitely enabled and has permissions. The server can ping Remedy. Component Services is configured...but we cannot seem to resolve this issue. Does anyone have any ideas? We're both running on SQL 2008 R2. Thanks. Carol _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
