Post reply

Login Failed for user "sa"

  • October 24, 2008 at 6:38 am

    #128087

    Hi,

    i have a SSIS package..its giving error for login failed ...actually i made changes in connection manager but sitll it is giving error ..moreover someone told me to add new connection and use it

    I tried that also but problem is remain same.

    Can any bode tell me which area I need to concentrate toi resolve this problem.

    i have checked pwd of sa user so that cannot be the concern.

    Thanks in advance

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 24, 2008 at 7:35 am

    #889211

    is this one of your original packages or did you inherit it? the reason i ask is that if you inherited it, perhaps the original coder made the db connection dynamic using a variable and an expression on the connection.

    if this was the case, you could make your changes using the connection manager editing pane and then the expression would overwrite these changes when it is evaluated at the AquireConnection point.

    Tom

    Life: it twists and turns like a twisty turny thing

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

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