Login Failure for NT Authority\System user
Hi Friends,
We have a production server(SQL 2005) which has configured Snapshot Replication to run once in a week.There is an open transaction which is initiated by "NT Authority\System user" after very few seconds the server started, which is trying to execute a SP called "sp_MSget_last_transaction" against the Distribution database.
I have tried giving the "db_owner" permissions to the NT Authority\System user,but it did not work.
Last eve,we have restarted the server,luckily the open transaction closed.
But to my surprise,the same transaction is started with a different SPID exactly as above mentioned.
The transaction is still open,and repeatedly(once in a minute) trying to execute the SP and a login failure occurs and the error written to the Error log.
Due to this the error log unnecessarily growing.
Any ideas../ Suggestions..?
Thanks in advance.
~Dhayanithy
Re : Login Failure for NT Authority\System user
Hi..
Thanks for the reply.
The SPID of that open transaction is 86
Re : Login Failure for NT Authority\System user
Owner of the Replication jobs is "SA".
Replication setting seems to be normal.How may I know if there is anything abnormal in the settings?
I will post the service accounts details soon here.
Thanks again.
~Dhayanithy
NT Authority\System Login Failure
NT Authority\System
Def DB : Master
Roles : Public & Sys Admin
Re : Login Failure for NT Authority\System user
There is no errors in the SQL Agent log.
The replication is already configured in our server,by the employees who worked prior to me..
I wil post the sql agent service details soon.
Thanks for the reply
~Dhayanithy
Re : Login Failure for NT Authority\System user
1)The SQL Server service and SQL Agent service both are running in "Local System" account.
2)In replication : Agent set to run under SQL Agent service account. and to connect the publisher will use the ''SA'' account.
Re : Login Failure for NT Authority\System user
Let me check about this with my manager...
Thanks
~Dhayanithy