This article explains how you can change the login information to "dbvrep" user. Follow below steps
- Create a new user dbvrep in Sql Server under Logins - it will inherit sa user server roles public and sysadmin.
- Stop all services
- create new or edit existing DSN ODBC with
- test the connection
- start the services
- start the console/replication
- 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.