Configure your SQL Server Instance

This guide will assist you in setting up your SQL Server instance so that Smartr can connect and work properly. You may configure your SQL Server for application development by following this document

Configurations to Ensure

---

1

Opening SQL Server Configuration Manager:

• Start by searching for SQL Server 2022 Configuration Manager from the Start Menu, as shown in the image below.

2

Enable TCP/IP Protocol:

• Under SQL Server Network Configuration, click on Protocols for MSSQLSERVER.

• Ensure that TCP/IP is Enabled. If it’s disabled, right-click on it and select Enable.

3

Configuring TCP/IP Properties:

• To specify the port for SQL Server connections, right-click TCP/IP and select Properties.

• Navigate to the IP Addresses tab and scroll down to IPAll.

• Ensure TCP Port is set to 1433 (the default SQL Server port).

4

Restarting SQL Server Services:

• After making changes, return to the Services window.

• Right-click on SQL Server (MSSQLSERVER) and select Restart to apply the new configurations.

Next Steps

---

With the SQL Server instance configured and running, you can now proceed with setting up your database connection in Smartr. If you encounter any issues with connecting to the database, double-check the configuration settings mentioned above.

For more detailed instructions on the setup process, refer to the official SQL Server documentation.