Okay, I have it working.

Note: This is for Windows 19 Server (64 bit):

Windows path pointing to the wrong OLE Drivers.

Need to add into the path under:

system properties > Advanced Settings...

Okay. I decided to uninstall and re-install and try again. Now I have a different issue.

I have set up "repldata" shared folder and created the four required entities as follows:

...

Okay, I think I may have found where the issue is, but am unsure of how to solve the issue.....

Firstly, I need to find out who is "logged in" for...

The Snapshot agent (repl_snapshot) is part of the following: (I checked this through "security > logins")

• a db_owner on distribution database
• a db_owner on the publisher database (in this case...

Hi Ant-Green,

Unfortunately I have to test all differing types of failover/replication with mysql and mssql. I have to prove operational value to customers. Mysql is working fine. No issues with...

• This reply was modified 3 years ago by  CliveG.

Hi SSCrazy Eights,

Firstly, love the name... excellent. Sounds like a character from a Tarantino movie   🙂

I think I almost have it configured by following this example:

https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-preparing-the-server-for-replication?view=sql-server-ver15

I have set...

As an add on to this, I am not a Windows Server guy. I got the replication working on Linux without issue but cannot even get snapshot replication working on...