Post reply

Integration Authentication

  • October 5, 2007 at 7:53 am

    #118465

    Hi everyone,

    I want to connect to integration services using a non Windows Authentication, ie a SQL Server Authentication. However this option

    is not available (grayed out) in the integration services login box.

    Is there a way to make SQL Server Authentication available in the

    integration box?

    Thanks to everyone for being there to help.

    SQL 05 Standard SP1

  • October 11, 2007 at 6:46 pm

    #741417

    I don't think you can do that. Think the various tasks available in SSIS - especially things like file tasks, ftp tasks, etc. Because the default package protection level is encrypt with user key, IS needs that domain account to authenticate with.

  • October 12, 2007 at 9:39 am

    #741651

    Mike, thanks for taking the time to answer. This is helpful.

    R.,

    Ed

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

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