SQL Server Agent - Error 1326

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 16 Jul 2008 21:37 GMT

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?

Reply to this Message

Russell Fields - 17 Jul 2008 16:54 GMT

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

> 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?

Reply to this Message