Sunday, September 9, 2018

Connecting to the Integration Services on the computer failed with following error : Access Denied

Installed SQL Server Integration Services. While tried to login Integration Services getting Access Denied Error. 

It will work fine when tried to login with Management Studio as "Run as a Administrator".

Here are the steps to access:

1. Run ->  dcomcnfg.exe
2. Navigate to Component Services ->Computers -> My Computer -> DCom Config
3. Search Application Name "Microsoft SQL Server Integration Services 11.0"
4. Open Properties:

5. Open Each edit option and add current user.

6. Save your changes.
7. Restart Your Service if required.

Watch the video for the details:

No comments:

Post a Comment