Yesterday afternoon I changed the service account to
local system account for sql server agent, after that, one
DTS package job which is used to track user login inf.
failed, the error msg is " login failed for user NT
authority/system", error number is 18456 which said user
has no permission to login to the server. I tried
several ways such as changing the windows authentication
to sql server authentication using sa, and save the dts
package to another user, but still failed.
While my other jobs went ok, I don't know if there are
special requirement for dts ...