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

From Mea Wiki
Jump to navigation Jump to search
(Created page with "This page contains all SQL Server configuration related instructions. Note. These instructions assume that there is an SQL Server instance with name '''SQLSERVER2016'''. Your...")
 
m
Line 1: Line 1:
This page contains all SQL Server configuration related instructions.
+
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.
 
 
Note. These instructions assume that there is an SQL Server instance with name '''SQLSERVER2016'''. Your SQL Server may have some other instance name.
 
  
 
== SQL Server TCP/IP port configuration ==
 
== SQL Server TCP/IP port configuration ==
If named instances are used, a TCP port needs to be assigned to the instance as follows:
+
If SQL Server named instances are used, a TCP port needs to be assigned to the instance as follows:
  
# Open '''Sql Server 20XX Configuration Manager'''.
+
# Open '''Sql Server 2016 Configuration Manager''' in Windows start menu.
 
# Click '''SQL Server Network Configuration''' and '''Protocols for SQLSERVER2016'''.
 
# Click '''SQL Server Network Configuration''' and '''Protocols for SQLSERVER2016'''.
# Doubleclick '''TCP/IP'''
+
# Double click '''TCP/IP'''.
# In '''Protocol''' tab, select '''Enabled''' is '''Yes'''
+
# In '''Protocol''' tab, select '''Enabled''' is '''Yes'''.
# In '''IP Addresses''' tab, in section '''IP All''' select '''TCP Port''' is '''1433'''.
+
# In '''IP Addresses''' tab, in section '''IPAll''' select '''TCP Port''' is '''1433'''.
 
# Open '''SQL Server services''' and click '''Restart''' for '''SQL Server (SQLSERVER2016)'''.
 
# Open '''SQL Server services''' and click '''Restart''' for '''SQL Server (SQLSERVER2016)'''.
  
Line 19: Line 17:
  
 
==Enabling SQL Server Authentication==
 
==Enabling SQL Server Authentication==
# Open '''Microsoft SQL Server Management Studio''' and login to the right instance.
+
If you are planning to use '''SQL Server Authentication''' in QPR MobileDashboard, check that SQL Server Authentication has been enabled as follows:
# In '''Object Explorer''' right click the top item and select '''Properties'''.
+
 
# Click '''Security''' and '''SQL Server and Windows Authentication mode'''. Click '''OK'''
+
# Open '''Microsoft SQL Server Management Studio''' and login to the proper instance.
 +
# In '''Object Explorer''' right click the topmost item and select '''Properties'''.
 +
# Click '''Security''' and select '''SQL Server and Windows Authentication mode'''. Click '''OK'''.
 
# Open '''Services''' in Windows Control Panel.
 
# Open '''Services''' in Windows Control Panel.
# Select '''SQL Server (SQLSERVER2016)'''
+
# Find '''SQL Server (SQLSERVER2016)''' and for it click '''Restart''' from the right click popup menu.
 +
 
 +
[[Category: QPR MobileDashboard]]

Revision as of 14:08, 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).

SQL Server Browser

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

  1. Open Services in Windows Control Panel.
  2. Check that 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 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.