Change ODBC login credentials to "dbvrep" after initial setup with SA user

Problem Description

This article explains how you can change the login information to "dbvrep" user. Follow below steps

Solution

1. Create a new user dbvrep in Sql Server under Logins - it will inherit sa user server roles public and sysadmin.

2. Stop all services

3. create new or edit existing DSN ODBC with dbvrep login information.

4. test the connection

5. start the services

6. start the console/replication

7. execute transactions and verify replicated to TARGET.

If you want to restrict the dbvrep user within SQL server, meaning exclude it from using the sysadmin server role, explicit permissions will be required.