MSSQL Source Prerequisites
The IIDR MSSQL Agent should be installed on the source MSSQL server.
Prior to IIDR MSSQL Agent installation, the following requirements have to be completed:
-
1GB disk space.
-
IIDR MSSQL Agent uses port 10501. This port should be accessible from the IIDR Management Console (MC), IIDR AS Server and the IIDR Kafka Agent.
-
IIDR MSSQL Agent requires 1GB of RAM to function properly,
-
Allocate MSSQL login user as follows:
-
Username : GSIIDR
-
For the GSIIDR login user, there are two options for configuring the required database privileges:
-
sysadmin role: This option is the simplest because it enables CDC Replication to execute the necessary statements to set up additional items that are necessary for replication.
-
dbowner role + additional required set privileges. This is the full set of MSSQL of privileges: MSSQL IIDR Schema Privileges
-
-
Enable replication on the database that changes should be captured from. The relevant commands can be found in the MSSQL Enable Replication Commands
-
Create or choose an OS Windows account that will be used to install the IIDR MSSQL Agent. This account must have the following privileges:
-
Standard user privileges
-
Logon as a service
-
Debug security policy settings.
-
Enable TCP/IP network protocol on the MSSQL server.
-
MSSQL recovery model should be configured to a Full recovery model.