When setting up replication you might get an error saying login failed.
This will show up in the SQL Error Logs as:
Login failed for domain\username
Followed by
Error: 18456, Severity: 14, State: 6
The error code means that a windows log-in was entered in the place of a SQL log-in. In the case I had it was in the Log Agent Reader security.
In the section connect to publisher I had entered a windows service account (although it says quite clearly here: using the following SQL Server Login). I didn’t see this though as I added replication through a script which I had adapted.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment