MSSQL Data Source Add User Guide

1. Log in to the Kuika platform and open the project you will work with from the Apps screen.
2. Open the Datasources module. In this module, you can view the data sources, actions and tables in your application and add a new data source.
3. Add a new data source by clicking the + icon next to the Sources heading.

4. Select the MSSQL DB option and set a name for your data source.
5. Complete the process by clicking the CREATE button.

After clicking the CREATE button, fill in the following fields on the screen that opens:

• Server: Enter the MSSQL database server address. Example: Server=myServerAddress.
• Database: Type the name of the database you want to connect to. Example: Database=myDataBase.
• Authorization:
  
  • User Id: Enter the user name. Example: User Id=myUsername.
  • Password: Enter your password. Example: Password=myPassword.
• Parameters: Specify additional parameters according to the needs of your application. Example:

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

1. Activate the Use Connection String option.

MSSQL Server must be open to the Internet in order to connect to an MSSQL database you are working with locally.

2. Enter the Connection String for the MSSQL database.
   
   • Example format:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

3. Check if the connection works with the Test button.
4. If the connection is successful, click the CREATE button to complete the process.

1. Use TLS 1.2: Enable the TLS 1.2 protocol to secure data communication.
2. SQL Server Browser Settings: Leave port 1433 open on your server.
3. Allow external IPs: Make sure your server is accessible to external IP addresses.
4. Test Connection String: Test your connection over an external network.
5. SQL Configuration Manager settings:
   
   • Enable “TCP/IP” and “Named Pipes” protocols in the ’Client Protocols” section.‍
   • Restart SQL Server to apply the changes.

1. Download and install Azure Data Studio.
2. Connect to the server:
   
   • Click the Connect button.
   • Complete the connection by entering the server name, database name and your credentials.
3. Select the database:
   
   • Open the desired database from the “Databases” section on the left side.
4. View the tables:
   
   • Expand the “Tables” folder and access the tables.
5. Run a SQL query:

SELECT * FROM [TableName];

• Run the query by pressing the F5 key.

By following these steps you can connect the MSSQL data source to your Kuika applications.