Post reply

Multiple Instances

  • November 21, 2007 at 9:59 am

    #119629

    Hi All,

    I have two instances in one of my sql server 2005. I can connect to integration services from my default instance but not able to connect through named instance.

    Is there any way to use the integration services in both instances.

    Need urgent help...

    Regards,

    Austin

  • November 21, 2007 at 11:04 am

    #753184

    Hi there,

    Are you trying to connect to one instance of SSIS?

    you may want to read on how to configure SSIS.

    http://msdn2.microsoft.com/en-us/library/ms137789.aspx.

    Hope this helps.

  • November 21, 2007 at 12:19 pm

    #753199

    Austin,

    Only one instance of Integration Services per server. I have my server setup with a dev(default instance) and qa(named instance) sql servers. I have configured IS as in the article to have a QA package store in the QA msdb via the configuration file.

    Norman

    DTS Package Search

    http://www.dtspackagesearch.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply