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
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