Login Failure for NT Authority\System user

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Author

Topic

dhayanithy.m
Starting Member

3 Posts

Posted - 2010-02-11 : 06:58:21

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

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-11 : 10:38:29

first: exec sp_grant_publication_access @publication = N'PublicationNameHere', @login = N'NT AUTHORITY\SYSTEM'

2nd, how did you configure the distributor security and publication access?

dhayanithy.m
Starting Member

3 Posts

Posted - 2010-02-12 : 01:28:12

Can you pls tell me, What the SP "sp_grant_publication_access" will do?

Publication type is Push Subscription.

Subscriber connection : SA account

Agent process account : SQL Server Agent account

Distribution agent profile : Default profile.

and until the last replication schedule everything succeeded without errors.

~Dhayanithy

dhayanithy.m
Starting Member

3 Posts

Posted - 2010-02-12 : 01:55:20

The user NT AUTHORITY\SYSTEM already have access to all the publications in the server.

Thanks for the reply.

~Dhayanithy

~Dhayanithy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources