In this article, we would explore in detail on how to set up a new SQL Server database connection as a part of replication.
Setting or creating a new SQL Server database connection majorly involves three steps which are categorized into three below sections:
- Connection Details
- SQL Server Detail
- Advance Setting
Let’s cover each of one of this one by one in detail:
I. Connection Details: This section covers the nomenclature of the connection which will be used in replication
- Connection Name: This property refers to the name of the connection. The name specified here is used for reference elsewhere where the replication is used. The name has to be unique with respect to the existing connections across replication meaning that you cannot have two SQL Server database connections with the same name at any point in time.
II. SQL Server Detail: This section covers the details of the SQL Server and the database instance which need to be used by SQList to establish a secure connection with the SQL Server database.
- Server Name/Instance: You need to specify the name of the SQL server or the name of the instance which hosts the destination database.
- Database Name: You need to specify the name of the database where you would like the lists to be exported. The database needs to already exist on the specified server.
- Database Engine: You need to specify the version of the destination SQL Server whether it is SQL Server 2008, SQL Server 2012 or some other version.
- Authentication Mode: You need to select the authentication mechanism offered by the SQL Server which you will use to authenticate yourself. Basically, you need to specify which authentication mode the SQL Server will be using to authenticate the users whether it is Windows Authentication or SQL authentication or Trusted authentication.
- User Name: You need to specify the username. It is a mandatory field.
- Password: You need to specify the password. It is a mandatory field.
- Domain: You need to specify the domain name of the user if any. It is an optional field.
- Test Connection: You can use the test connection utility to test the correctness of the details specified whether all the details are valid and SQList is able to establish a connection successfully.
Once you have specified the connection details, it is advised that you test your connection before proceeding ahead.
III. Advance Setting: This section covers up details about an advance setting related to the SQL Server connection.·
- Enable database connection: This property lets you control whether you want to enable or disable this database connection. By default, the connection is enabled.