Login Failure for NT Authority\System user

• mdn_2k5

  SSC Eights!

  Points: 814

  More actions

  February 10, 2010 at 12:19 am

  #96957

  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

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  February 10, 2010 at 1:20 am

  #1116610

  Duplicate Post - refer to http://www.sqlservercentral.com/Forums/Topic862962-146-1.aspx

  Steve Hall
  Linkedin
  Blog Site