About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Saturday, May 25, 2013

MSDB Access Denied

The following Error appears when try to expand the MSDB Database.


To workaround this

1. Ensure Database Engine Services ETL Server is running.

2.Locate the path as shown as below for 2008

C:\Program Files\Microsoft SQL Server\100\DTS\Binn

3. Edit the MsDtsSrvr.ini XML file , Ensure the ETL Servername is configured properly

4.If Access is denied , Go the component services and search for MsDtsServer as
shown as below



5.Right click and go to properties and view the security tab

6.Give Appropriate permission to the Configuration and click apply

7.Ensure  restart the SSIS Services to take effect of the Configuration changes in the MsDtsSrvr.ini XML file.

Ref: http://msdn.microsoft.com/en-us/library/ms137789(v=sql.100).aspx


No comments:

Post a Comment