SQL Server Configuration in QPR UI

From Mea Wiki
Jump to navigation Jump to search

This page contains all SQL Server configuration related instructions. Note that these instructions assume that there is an SQL Server 2016 instance with name SQLSERVER2016. Your SQL Server may have some other instance name.

SQL Server TCP/IP port configuration

If SQL Server named instances are used, a TCP port needs to be assigned to the instance as follows:

  1. Open Sql Server 2016 Configuration Manager in Windows start menu.
  2. Click SQL Server Network Configuration and Protocols for SQLSERVER2016.
  3. Double click TCP/IP.
  4. In Protocol tab, select Enabled is Yes.
  5. In IP Addresses tab, in section IPAll select TCP Port is 1433.
  6. Open SQL Server services and click Restart for SQL Server (SQLSERVER2016).

Checking SQL Server Browser is running

If SQL Server named instances are used, the SQL Server Browser service needs to be running.

  1. Open Services in Windows Control Panel.
  2. Find service SQL Server Browser has status Running.

Enabling SQL Server Authentication

If you are planning to use SQL Server Authentication in QPR MobileDashboard, check that SQL Server Authentication has been enabled as follows:

  1. Open Microsoft SQL Server Management Studio and login to the proper instance.
  2. In Object Explorer right click the topmost item and select Properties.
  3. Click Security page and select SQL Server and Windows Authentication mode. Click OK.
  4. Open Services in Windows Control Panel.
  5. Find SQL Server (SQLSERVER2016) and for it click Restart from the right click popup menu.
Retrieved from "https://wiki.onqpr.com/mea/index.php?title=SQL_Server_Configuration_in_QPR_UI&oldid=4132"