Monday, October 26, 2015

Another configuration story

After struggling to get the SSIS working, talking to several people a blog entry came to rescue and saved the day:

https://msdn.microsoft.com/en-us/library/ms137789.aspx

During a SSIS instlalation I never had issues with configurations, I usaually install everything using an Administrator account. I had a local account and run the executable as Administrator, the SSIS was installed and the instance created. The problem was when using the local account to access Management Studio the SSIS instance was unavailable, using the installation account and running as administrator did the trick.
The SSIS instance was registered under the adminstrator priviledges and was unable to be accessed outsider the administrative group. The configuration was required to allow the instance to be accessed from Management Studio

No comments: