Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-29 : 12:13:15
|
| ann writes "On a particular server, all the DTS jobs used to work OK since they were created until we hit with Nimda virus and applied a Nimda patch on this server. whenever DTS package is run as a part of the schedule task, it comes up with the following error:Error: -2147217843 (80040E4D); Provider Error: 18456 (4818) Errorstring: Login failed for user 'NCBA\sqlagent'. Error source:Microsoft OLE DB Provider for SQL Server Help file: Help context: 0Following is a detail about configuration:--Versions: NT server with NT service pack 5SQL server 7.0 with service pack 2--SQL server security: Use NT and SQL server authentication--Domain: NCBA--SQL services and SQL agent services startup account : NCBA\SQLagent(This account is a part of Domain Admin group for the NT box as well as System admin for SQL server)--DTS task owner: NCBA\sa--AntiVirus software: McAFee version 5I believe this particular box is no longer identifying the NT authentication anymore even though it's configured for mixed mode security. I checked all the logins and possible permissions. They seem to be OK. According to the NT admin nothing has changed on the box.NCBA\aqlagent is System admin for sql server as well as Domain admin for the server machine. Any DTS package does not have any password and works OK when executed alone (i.e. by right clicking on package name and clicking 'execute package)I have tried to run package as a job using sql authentication as well as trusted connection with command type operating system command as well as using xp_cmdshell from within a procedure. (dtsrun /Sserver_name /package name /E)(dtsrun /Sserver_name /package name /Usa /P******)Still I am getting the same error..Can any one suggest where the login might be failing? what needs to be done in order to make DTS package run as a scheduled task?Thanks for at least reading it through." |
|
|
|
|
|
DTS error