Re: Login failed for user 'sa'

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 13:55:24 -0000

No reason for this to fail. Check the names when using global variables,
names are case sensitive. 

-- 
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"x-rays" <xrays@discussions.microsoft.com> wrote in message
news:F3BE07EE-D71F-44A0-9CD6-9EEBCB6B03BE@microsoft.com...
> 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: 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)
  • Re: The number of failing rows exceeds the maximum specified. Unspecified error
    ... I found the following error in the package log: ... Microsoft OLE DB Provider for SQL Server ... Provider for SQL Server: Subquery returned more than 1 value. ...
    (microsoft.public.sqlserver.dts)
  • Login failed for user sa
    ... 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 ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Failing a step/package
    ... What about setting the package level property "Fail on First Error" to true ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I have an ActiveX step that validates a global variable, ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS task fails no ERROR
    ... >> I am calling a DTS from a stored proc. ... >> when I FORCE a task to fail the following code ... The package executed just fine, from a COM perspective, so no error is ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
Loading