Difference between revisions of "SQL Server Configuration in QPR UI"

From Mea Wiki
Jump to navigation Jump to search
Line 14: Line 14:
 
If SQL Server named instances are used, the SQL Server Browser service needs to be running.
 
If SQL Server named instances are used, the SQL Server Browser service needs to be running.
 
# Open '''Services''' in Windows Control Panel.
 
# Open '''Services''' in Windows Control Panel.
# Find service '''SQL Server Browser''' has status '''Running'''.
+
# Find service '''SQL Server Browser''' and check that it has status '''Running'''.
  
 
==Enabling SQL Server Authentication==
 
==Enabling SQL Server Authentication==

Revision as of 14:13, 24 March 2017

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 and check that it 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.