Help with live replication

Question

Hello,

Replication was working normally till yesterday when all of a sudden it stopped.

I checked the replication monitor and it gave me the following:

Error messages:
The job failed.  The Job was invoked by Start Sequence 0.  The last step to run was step 3 (Detect nonlogged agent shutdown.).
-------------

Error messages:
Message: Cannot open database "HR" requested by the login. The login failed.
Login failed for user 'ZFP\sqlaccount'.
Stack:    at Microsoft.SqlServer.Replication.ServerConnectionEmulator.Connect()
   at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.EstablishPublisherConnection()
   at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
   at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
   at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 4060)
Get help: http://help/4060
Server CS048, Level 14, State 1, Procedure , Line 65536
Login failed for user 'ZFP\sqlaccount'. (Source: MSSQLServer, Error number: 18456)
Get help: http://help/18456
Server CS048, Level 14, State 1, Procedure , Line 65536
Login failed for user 'ZFP\sqlaccount'. (Source: MSSQLServer, Error number: 18456)
Get help: http://help/18456



I need help ASAP.
I want to know what are the triggers for this problem.
Is it the windows user, or can it be the SQL user.
I don't have control on the window users, and the people responsible for that said that nothing has been changed.
Please help..

Answer 1

Try deactivating the firewall to solve your connection problem. If this works you can narrow the problem down to determine if ports need to be added to firewall exceptions.

LaurentiuM

Answer 2

I don't have the access or right to do all these changes..

Replication was working before...and no changes were done..
how can this error come ?

Answer 3

It could be a windows account or a sql account.

You might want to enable logging to see exactly where the error is occuring. The final message might be masking a previous message which is more meaningful.

Ensure the account ZFP\sqlaccount has read, write and list files and folders permissions on the snapshot location as well as the files and folders underlying it.

It also looks like the password for this account might have changed.

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 4

please check if your account is locked/disabled.