Home Forums SQL Server 2005 T-SQL (SS2K5) Running SSIS package with other domain account RE: Running SSIS package with other domain account

  • March 24, 2014 at 5:32 am

    #1699475

    mahesh.yerragonda (3/24/2014)

    Finally got it.I changed connection manager from sql authentication to windows authentication and gave the user admin roles.Did use any configurations now.Thanks all for the help.

    Thanks,

    Mahesh

    Good that it works, but giving users admin roles to resolve an issue is usually not a good idea.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP