I was trying to make a linked server connection between the SQL server 64 bit & oracle 32 bit, an error message appears. The SSIS package documentation is for how to rectify issues running the SSIS package. The Oracle OLEDB under 64bit SQL Server 2005 that was used by the Linked Server and SQL Agent. On the Oracle 11g version, the following error appears. How can I overcome this problem?
Error while creating service. The service OracleMTSRecoveryService already exists. Click 'Help' for more information. Click 'Retry' to try again. Click 'Ignore' to ignore this error and go on. Click 'Cancel' to stop this installation.