MSSQL Data Source Add User Guide

1. After logging into the Kuika platform, open the project you will work on from the "Apps" screen.
2. 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.

3. 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.

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

1. 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. An example parameter usage:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Encrypt=true;Connection Timeout=30;

1. 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.
2. 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.

1. 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.

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.

The inability to see tables in an MSSQL database is usually caused by server migration. With Azure Data Studio, you can connect to the server to check the existing tables and perform the necessary operations.

You can follow the steps below to see the tables in the MSSQL database with Azure Data Studio:

Download and Install Azure Data Studio:

• If it is not already installed, download and install Azure Data Studio.

Connect to the Server:

• Open Azure Data Studio.
• Click the Connect button in the top left corner.
• Enter your server name, database name and credentials.
• Click the Connect button to establish the connection.

Select the database:

• Click on the Databases section on the left side.
• Find your migrated database and click on it.

View Tables:

• Under the database you selected, expand the Tables folder.
• Here, the list of available tables will be displayed. Double-click on the table you are interested in to view its contents.

View Table Data with Queries:

• If you want to query the data in a particular table, open a new query window.
• You can write a SQL query like the one below:

SELECT * FROM [TableName];

• Press F5 to run the query.

By following these steps, you can view your MSSQL tables with Azure Data Studio.