How to avoid "Login Failed for User" error while deploying SSIS Package?

Posted on 2011-05-09
Last Modified: 2012-05-11
In my client place, Development team is giving SQL Server 2008 SSIS package to Production team to deploy. Production team is deploying package using DTUtil2008. While running the job it is giving  "Login failed for user" error.  At the same time if Developers deployed the package it is working fine. Can you please tell me what property we need to change in SSIS package to avoid this error?
Question by:PKTG
    LVL 15

    Expert Comment

    Use windows authentication on the data source. They might be using the SQL Server Authentication that is not int he production environment -- or the password in Development and Production environment is not the same if they are using the SQL Server authentication.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Make sure SQL Agent user has proper permissions.

    Author Comment

    SQL Agent user has proper permissions but still it is giving error

    Accepted Solution

    AFter using password encryption option it is working fine

    Author Closing Comment

    My solution is working fine

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Need help with a query 3 35
    SQL Select * from 6 25
    Last 2 orders by customer 2 30
    insert query with value having 's 2 27
    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now