Post reply

Connection Problem...!!!

  • June 21, 2007 at 8:55 am

    #117446

    Can any one help me out..??

    i have a SSIS package which basically has source and destination servers and tryin to transfer a table... when i execute the package in my local machine usin sql authentication it is running fine... And when i deploy the same package in the target server it is showin connection error as below...

    [Source - CoBrand_lkp [1]] Error: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.

    Also when i deploy the same in my local machine it is showin the same error...

    Thanks in Advance

    - Kerobin

  • June 26, 2007 at 4:07 am

    #715156

    What type of connection are you using? Does the account Agent is running under have rights to SQL?

    There should also be more to the error which is slightly more descriptive.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 26, 2007 at 4:27 am

    #715161

    i'm using SA sql authentication for both servers..

    Thanks

    - Kerobin

  • June 26, 2007 at 4:42 am

    #715169

    is your package saving the password? By Default it does not. You need to check the ProtectionLevel property of the package. Sensitive data, such as passwords, do not get saved.

    Can you change it to use NT Auth? Easier to manage / safer

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 26, 2007 at 5:24 am

    #715181

    i dont know about that.. can u help me which level to keep..

    thanks

    - Kerobin

  • June 26, 2007 at 6:09 am

    #715204

    I would strongly recommend on using NY Auth and not SQL as it is far easier to manage and use.

    However, _if_ you insist, or cannot change, on using SQL logins, see http://technet.microsoft.com/en-us/library/ms141747.aspx

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 26, 2007 at 6:40 am

    #715220

    Hey thanks for that...

    it really helped me...

Viewing 7 posts - 1 through 6 (of 6 total)

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