Fix:
1. Determine the service account name that SQL Server Services is running in. Run the SQL Server Configuration Manager.
2. Create a Login for that account and grant it connection access (minimum privileges). Run on primary and all replication servers: GRANT CONNECT SQL TO [\]
No comments