Additional Solution Suggestions for MSSQL Configuration Process

1. Use TLS 1.2: Enable the TLS 1.2 protocol to secure data communication.
2. Port settings: Make sure that TCP port 1433, which SQL Server uses by default, is open on the server and firewall. If you are using a named instance, verify that the SQL Server Browser service is running and that UDP port 1434 is open.
3. Allow external IPs: Ensure that your server is open to connections from external IP addresses.
4. Test the connection string: Test your connection over an external network.
5. SQL Server Configuration Manager settings:
   
   • In the SQL Server Network Configuration > Protocols for [instance name] section, enable the TCP/IP protocol.
   • Restart the SQL Server service for the changes to take effect.

Viewing MSSQL Tables with an External Tool

To check the tables in the database you’re connecting to, you can use SQL Server Management Studio (SSMS) or Visual Studio Code with the MSSQL extension installed.

1. Download and install the tool.
2. Connect to the server: 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.
4. View the tables: Expand the Tables folder and access the tables.
5. Run an SQL query:

SELECT * FROM [TableName];

Press the F5 key or click the Execute/Run button to run the query.

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