SQL Server Agent - Error 1326   

Without having to recreate this processing in SSIS, I have an Access Program 
which I can run by commandline.  The batch file runs Access executing a 
macro.

I created a job in SQL Server 2005 with a step to Exec the MS batch file. 
It hangs reporting the error 1326.  What do I have to do to resolve this?

date: Wed, 16 Jul 2008 13:37:00 -0700   author:   Greg

Re: SQL Server Agent - Error 1326   

Greg,

I believe that this is "System error 1326 has occurred. Logon failure: 
unknown user name or bad password."

If that is your error, some discussion in: 
http://support.microsoft.com/kb/103390

Also, Jasper Smith gave a reponse to a similar problem about 6 years ago. 
http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2002-06/0655.html

In terms of your SQL Agent job, how are you running the job step, under what 
security context, et cetera.  (Maybe a script of the job would be helpful to 
view.)  One possibility is that you have created a credential and proxy, but 
the credential's password is incorrect.

FWIW,
RLF

"Greg"  wrote in message 
news:OJYYcO45IHA.3856@TK2MSFTNGP06.phx.gbl...
> Without having to recreate this processing in SSIS, I have an Access 
> Program which I can run by commandline.  The batch file runs Access 
> executing a macro.
>
> I created a job in SQL Server 2005 with a step to Exec the MS batch file. 
> It hangs reporting the error 1326.  What do I have to do to resolve this?
>

date: Thu, 17 Jul 2008 11:54:16 -0400   author:   Russell Fields