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

Posted on 2011-05-09
Medium Priority
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
  • 3
LVL 15

Expert Comment

by:Faiga Diegel
ID: 35724934
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
ID: 35728112
Make sure SQL Agent user has proper permissions.

Author Comment

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

Accepted Solution

PKTG earned 0 total points
ID: 37643494
AFter using password encryption option it is working fine

Author Closing Comment

ID: 37659326
My solution is working fine

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

750 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