Login failed for user 'sa'

From: x-rays (xrays_at_discussions.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 05:45:02 -0800

Hello all,

I' ve created a dts package to import some data from another data source.
I've created an SQL connection and specify the provider 'Microsoft OLE DB
Provider for SQL Server'. I parameterize the ServerName, User, Pwd and DBName
and set their values using an activex script. When I run the dts on SQL
Server (in Design Mode) completes successfully, but when I run the package as
a structure storage file, on the first task that executes a stored procedure,
the package fails with an error:
Error: -2147217843 (80040E4D)
Error string: Login failed for user 'sa'
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0

My password is simple (for now): 123
command line: dtsrun /FD:\AccessDBPath\MyPckgName.dts /NMyPckgName /Mpgkpwd
/LD:\AccessDBPath\DTSErrorLog.txt
/AParMDBFilename:8=D:\AccessDBPath\AccessDB.mdb
/AParServer:8=MYSERVER\MYINSTANCE /AParUserID:8=sa /AParPwd:8=123

Do you have an idea what might cause this? Maybe I have to specify the
provider again (in my activex scipt)?????

Thanks in advance.

Relevant Pages

  • Re: SSIS as part of scheduled job fails
    ... Can't even open the package. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... I noticed that you are currently working with Matt and I'd like to know how ... Can't even open the package. ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... Can't even open the package. ... Deloyed to SQL store. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: DMX cmd cant see Access db
    ... into a SQL database - primarily to work around the issues you are running ... SQL Server Data Mining ... provider I'm trying to use in order to read data from an Access ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: Password is not saved for Oracle connections
    ... table in SQL Server 2005. ... The package runs just fine from the BID. ... It gives a "ORA-01017: invalid username/password; logon denied" error when I use the Microsoft OLE DB Provider for Oracle, and a "ORA-10005: null password; logon denied" error when I use the Oracle provider for OLE. ...
    (microsoft.public.sqlserver.dts)