Issue – My BI developer informed me; They are no longer able to connect oracle data sources they have created in their cube. Troubleshooting – As I am aware; In order to connect to Oracle; you should have oracle client installed properly. As it was working earlier hence my first impression was; they definitely have… Read More Issues related to Oracle Client in SQL Server.
SSIS access permissions are managed via Component Service under DCOM Config 1. Run –> dcomcnfg.exe or Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer 2.Right click on MSDTSServer or MSDTSServer100 ( based on SQL version ) 3.Click properties 4.Click on the Security tab 5.Select Customize and add the users/groups to the… Read More How to grant access on SSIS Server