Configure MSSQL Settings Manually

In the Endpoint section, select the Enter fields tab and fill in the following fields.

01 Endpoint

Contains the server information Kuika will use to connect.

• Server (required): Enter the MSSQL database server address. Example: myServerAddress
• Database (required): Enter the name of the database you want to connect to. Example: myDataBase

02 Credentials

These are the credentials that are part of the connection string.

• User ID: Enter the username. Example: myUsername
• Password: Enter your password. Example: myPassword. You can show or hide the password using the eye icon.

03 Parameters

You can enter additional parameters to be added to the connection string into the table consisting of the Key and Value columns. When you fill in a row, a new blank row appears below it; you can delete an added row using the trash can icon.

Example parameters:

Key Value
Encrypt: true

Connection Timeout: 30

When you enter a parameter, you can see a preview of the connection string generated from the information you entered in the Resolves To field on the right.

The connection string generated using the example information above would look like this:

data source=myServerAddress;initial catalog=myDataBase;user id=myUsername;password=myPassword;Encrypt=true;Connection Timeout=30;