Post reply

Connecting to integration services with SQL Server ID

  • May 8, 2008 at 4:11 pm

    #121980

    Hi, when I go to connect to Integration Services, the option to connect with a SQL Server ID goes away. As I am not on the same network as the SQL Server, windows authentication is not an option.

    Is there a way to enable SQL Server authentication when connecting to Integration Services?

    Thanks

  • May 9, 2008 at 1:29 pm

    #813322

    bump

  • May 12, 2008 at 10:56 am

    #813957

    After a little searching on this issue, I found one reference where someone had to add themselves to the local administrators group on the server so they could log in to SSIS. The following article from Microsoft seems to support that:

    http://msdn.microsoft.com/en-us/library/ms180068.aspx

  • May 12, 2008 at 11:27 am

    #813969

    Only Windows authentication is available for SSIS.

    Greg

  • May 13, 2008 at 10:42 am

    #814666

    Thanks. I have to say though that is unfathomably stupid.

Viewing 5 posts - 1 through 4 (of 4 total)

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