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:
Watch the video for the details:
No comments:
Post a Comment