Preparing SQL Server Instance
Prev | Chapter 32. Prepare the MS SQL Server Database for the Tigase Server | Next

## Preparing SQL Server Instance

After installation of SQL Server an instance needs to be configure to handle incoming JDBC connections. For that purpose it’s required to open SQL Server Configuration Manager. In the left-hand side panel navigate to SQL Server Configuration Manager, then SQL Server Network Configuration → Protocols for ${INSTANCE_NAME}. After selecting instance in the right-hand side panel select TCP/IP and open Properties, in the Protocol tab in General section select Yes for Enabled property. In the IP Addresses tab select Yes for Active and Enabled properties of all IP Addresses that you want SQL Server to handle. Subsequently set TCP Port property (if missing) to the default value - 1433.A restart of the instance may be required afterwards.

Prev | Up | Next
Chapter 32. Prepare the MS SQL Server Database for the Tigase Server | Home | Configuring using SQL Server Management Studio