Upgraded from Tridion 5.3 SP1 to Tridion 2011 SP1.
Want to change Httpupload page URL mentioned in Publication Targets, but while saving it Tridion is throwing error
8004D025) Error: Exception of type 'System.EnterpriseServices.TransactionProxyException' was thrown.Unable to save Target type (tcm:0-2-65538).SQLUtilities.GetDatabaseConnectionDataStoreDAL.InitDataStoreBroker.InitDataStoreUtilitiesBL.InitDataStoreTargetTypeBL.UpdateTridion.ContentManager.IdentifiableObject.SaveThroughLegacyBL(String)Tridion.ContentManager.IdentifiableObject.Save(SaveEventArgs)Tridion.ContentManager.IdentifiableObject.Save()Tridion.ContentManager.BLFacade.IdentifiableObjectFacade.Update(UserContext,String)XMLState.SaveTargetType.Save
Note: We are able to update Component and Pages but unable to update/create new Publication Targets as well as Target Types
This is most likely an MSDTC problem. Check if you can reach the database server from the Tridion server using DTCPing.
Update: other people that had similar problems reported that it was caused by their SQL Server cluster and they fact that they needed to open port 135 on their firewall for messages in one direction and ports 1024-5000 for the response messages. Apparently the Windows ODBC Data Source Administrator is even better for troubleshooting than DTCPing as it verifies access to a particular database via SA credentials, server and port.