Connect to SQL Server
When prompted by the wizard, enter the appropriate connection details.
Where is the database located? If your source is an Amazon RDS for SQL Server instance or Azure SQL Managed Instance, select that, otherwise leave set to the default.
Hostname: Enter the IP address or fully qualified network name of the instance (for example,
198.51.100.10ormydb.123456789012.us-east-1.rds.amazonaws.com) or, if you are connecting via an SSH tunnel, paste the string copied from Striim Cloud Console > Service details > Secure connection > Tunnel Address (see Configure Striim to use your SSH tunnel).Port: Enter the port for the specified host.
Username: Enter the name of the user you created when you Set up your SQL Server source.
Password: Enter the password associated with the specified user name.
Connect using SSL: Select if connecting to the source database using SSL. See the detailed instructions below.
Connect using SSL: Select if the connection requires SSL, in which case you must also specify the following properties:
Source connection name: Enter a descriptive name, such as
SQLServerConnection1.
Get an SSL certificate in .pem format from your database administrator.
Create the truststore.jks file (replace
<file name>with the name of your certificate file):keytool -importcert -alias MSSQLCACert -file <file name>.pem -keystore truststore.jks \ -storepass mypassword
Set these properties in Striim:
Use trust server certificate: enable
Integrated security: enable to use Windows credentials
Trust store: upload the file you created in step 2
Trust store password: the password you specified for
-storepassin step 2Certificate host name: the
hostNameInCertificateproperty value for the connection (see Learn > SQL > Connect > JDBC > Securing Applications > Using encryption > Understanding encryption support)
Download the appropriate
.pemfile from AWS > Documentation > Amazon Relational Database Service (RDS) > User Guide > Using SSL/TLS to encrypt a connection to a DB instance.Create the truststore.jks file (replace
<file name>with the name of the file you downloaded):keytool -importcert -alias MSSQLCACert -file <file name>.pem -keystore truststore.jks \ -storepass mypassword
Set these properties in Striim:
Use trust server certificate: enable
Integrated security: enable to use Windows credentials
Trust store: upload the file you created in step 2
Trust store password: the password you specified for
-storepassin step 2Certificate host name: the
hostNameInCertificateproperty value for the connection (see Learn > SQL > Connect > JDBC > Securing Applications > Using encryption > Understanding encryption support)
Microsoft has changed its certificate requirements. Documentation update in progress.