Unable to Open MSDB in Integration Services when using Named Instance(s)
Posted at Tuesday, May 27, 2008
Follow the accepted answer from the following post: Re: Unable to open MSDB node if you are using a named SQL Server instance and you can't access the SSIS packages within the MSDB database.
You will experience a 'Login Timeout' exception until you edit the XML file mentioned in the post. By default, Microsoft is configured to connect to the DEFAULT instance only; short of modifying this file, there is no way of specifying a different Database Service for Integration Services to use.
You will experience a 'Login Timeout' exception until you edit the XML file mentioned in the post. By default, Microsoft is configured to connect to the DEFAULT instance only; short of modifying this file, there is no way of specifying a different Database Service for Integration Services to use.
Labels: Bugs, SQL Server
_507.png)
Subscribe
