I am trying to set up replication between databases. I followed these tutorials:
I went through first without any problems. Almost completed the second, but I got stuck on step View the status of snapshot generation
When I try to start the Snapshot Agent, I get an error:
Exception Message: An unspecified error had occurred in the native SQL Server connection component.
I tried to search on the internet MSSQL_REPL55012 (that's error code I get), but didn't succeed.
I tried to look in SQL Profiler, Jobs history, Replication Monitor, even ran failing job step from PowerShell, but couldn't get any more info on that.
What might be the issue? Anybody else stumbled upon that?
I am using:
- SSMS version 15.0.18206.0
- SQL Server engine 15.0.2000.5
Also, I run two instances of SQL Server and have two Management Studios installed, if that's relevant.