Setting Up SQL Server - Synergex/SqlReplication GitHub Wiki

When you connect to the SQL Server database you will need to be able to authenticate against the database, using one of two possible methods, depending on the configuration of the database.

  • Using Windows Authentication
  • Using SQL Server Authentication (if enabled in the database

If you are using an instance of SQL Server (or SQL Server Express) on your local system then usually when you install SQL Server your windows login is set as an administrator in the database, and you should be good to go with Windows Authentciation.

The login that you will use needs owner access to whatever database you intend to use, and needs to be specifically granted permission to perform bulk operations.

The typical specific steps you need to go through to configure the environment are:

  1. If you intend to use SQL Server authentication, and don't already have a user account, create a new SQL Server Login and set the password to the account.
  2. Allow the new login to perform bulk operations.
  3. Create a new SQL Server database, if possible naming it SqlReplication, and set the owner of the database to be the account you intend to log in with.
  4. Modify the user account such that the replication database is the default database for the user account (optional).

If you do need to perform these setup steps then one option is to use a SQL script that we have provided in a file named ConfigureDatabase.sql, which you will find in the root folder of the development environment.

You can execute the script via SQL Server Management Studio in order to perform the steps listed above. If you use the script as is it will create a login called SqlReplicationUser with the password set to SqlReplicationPassword, and creates a database named SqlReplication that is owned by the new user account.

Using the script is completely optional, you may decide to use an existig user account, or you may perform the setup manually.