MSSQL is one of the external data sources you can use on the Kuika platform. You can quickly connect an MSSQL database you own as a data source to an application you develop in Kuika. With this training content, you will learn how to connect a data source to your application using MSSQL.

This training content consists of the following topics:

Adding a data source connection to your application with MSSQL.
Configuring MSSQL settings manually.
Configuring settings via Connection String.
Additional solutions for the MSSQL configuration process.

Add a Data Source Connection to Your Application with MSSQL

After logging into the Kuika platform, open the project you will work on from the "Apps" screen.
Go to the "Datasources" (1) module. In the Datasources module, you can view the data sources, actions and tables in the application you have developed, add a new data source, a new action and a new table.

To add a new data source to your application, click on the "+" (2) icon next to the "Sources" heading on the left side of the Datasources module.

Select "MSSQL DB" (1) as the Datasources type and give it a name (2).
Then click on the "CREATE" (3) button.

Configure MSSQL Settings Manually

After clicking the "CREATE" button, configure the Server, Database, Authorization and Parameters fields of the database you want to connect from the screen that opens.

Related Fields for Configuration

Server (1) :Represents the MSSQL database server address. It should be the address or IP address of the server you want to connect to the database. For example, "Server=myServerAddress".
Database (2): Represents the name of the MSSQL database you want to connect to. Database should be the name of the specific database you want to connect to. For example, "Database=myDataBase".
Authorization (3):

User Id: Represents the user name that will be used to connect to the MSSQL database. For example, "User Id=myUsername".
Password :Represents the password that will be used to connect to the MSSQL database. For example, "Password=myPassword".
Parameters (4): You can fill in the parameters according to the needs of your application.

Configure Settings via Connection String

Turn on the "Use Connection String" switch and enter the "Connection String" information of the database you want to connect to on the screen that appears.
For Connection String information, enter information in the format "Server= ;Database= ;User Id= ;Password= ;".
MSSQL Server must be open to the internet to provide a connection to an MSSQL database that you are working locally.
After entering the information, test whether the MSSQL connection is working or not via the "Test" button above. If the MSSQL connection is working, create the Datasources connection by clicking the "CREATE" button.

Example MSSQL Data Source

‍
"Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"This connection will work smoothly when the user information is entered correctly in the "myServerAddress", "myDataBase", "myUsername", "myPassword" fields.

Additional Solution Suggestions for MSSQL Configuration Process

1. Use TLS 1.2 : You must use version 1.2 of the TLS protocol to secure your data communication.

2. SQL Server Browser Settings : For SQL Server Browser to work, port 1433 on your server must be open.

3. Allow External IPs : Your server must allow external IP addresses. If you only want to allow certain IPs, just allow the platform's IP address.

4. Test Connection String: Test Connection String over an external network first. This test verifies that your connection is accessible from the outside world.

5. SQL Configuration Manager Settings: In SQL Configuration Manager, enable the "TCP/IP" protocol in the "Client Protocols" section. Also, the "Named Pipes" protocol must be enabled. If these two protocols are not enabled and were enabled later, you will need to restart SQL Server for the changes to take effect.