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

From Mea Wiki
Jump to navigation Jump to search
Line 1: Line 1:
−
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.
+
This page contains instructions for SQL Server configuration. Note that these instructions assume that there is an SQL Server 2016 instance with name '''SQLSERVER2016'''. Your SQL Server may be other version or have other instance name.
  
 
== SQL Server TCP/IP port configuration ==
 
== 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:
+
If named instance are used in the SQL Server, a TCP port needs to be assigned to the instance as follows:
  
 
# Open '''Sql Server 2016 Configuration Manager''' in Windows start menu.
 
# Open '''Sql Server 2016 Configuration Manager''' in Windows start menu.
Line 8: Line 8:
 
# Double click '''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 '''IPAll''' select '''TCP Port''' is '''1433'''.
+
# In '''IP Addresses''' tab, in section '''IPAll''' select '''TCP Port''' is '''1433'''. (To be confirmed: Is this actually enough?)
 
# Open '''SQL Server services''' and click '''Restart''' for '''SQL Server (SQLSERVER2016)'''.
 
# Open '''SQL Server services''' and click '''Restart''' for '''SQL Server (SQLSERVER2016)'''.
  
 
== Checking SQL Server Browser is running ==
 
== Checking SQL Server Browser is running ==
−
If SQL Server named instances are used, the SQL Server Browser service needs to be running.
+
If named instance are used in the SQL Server, the SQL Server Browser service needs to be running. Check it as follows:
 
# Open '''Services''' in Windows Control Panel.
 
# Open '''Services''' in Windows Control Panel.
 
# Find service '''SQL Server Browser''' and check that it has status '''Running'''. If the service is missing, SQL Server Browser is not installed.
 
# Find service '''SQL Server Browser''' and check that it has status '''Running'''. If the service is missing, SQL Server Browser is not installed.
Line 19: Line 19:
 
If you are planning to use '''SQL Server Authentication''' in QPR MobileDashboard, check that SQL Server Authentication has been enabled as follows:
 
If you are planning to use '''SQL Server Authentication''' in QPR MobileDashboard, check that SQL Server Authentication has been enabled as follows:
  
−
# Open '''Microsoft SQL Server Management Studio''' and login to the proper instance.
+
# Open '''Microsoft SQL Server Management Studio''' and login to a proper instance.
 
# In '''Object Explorer''' right click the topmost item and select '''Properties'''.
 
# In '''Object Explorer''' right click the topmost item and select '''Properties'''.
 
# Click '''Security''' page and select '''SQL Server and Windows Authentication mode'''. Click '''OK'''.
 
# Click '''Security''' page and select '''SQL Server and Windows Authentication mode'''. Click '''OK'''.
Line 25: Line 25:
 
# Find '''SQL Server (SQLSERVER2016)''' and for it click '''Restart''' from the right click popup menu.
 
# Find '''SQL Server (SQLSERVER2016)''' and for it click '''Restart''' from the right click popup menu.
  
 +
==Creating new database for QPR MobileDashboard==
 +
When making a new installation for QPR MobileDashboard, a new SQL Server database needs to be created as follows:
  
 +
# Open '''Microsoft SQL Server Management Studio''' and login to a proper instance.
 +
# In '''Object Explorer''' right click '''Databases''' ans from the popup menu select '''New database...'''.
 +
# Define a name for the database and change other settings for the database if needed (default settings will work for QPR MobileDashboard).
 +
# In '''Object Explorer''' open click '''Security''' and then open '''Logins'''. You can create a new login by right clicking Logins and from the popup menu selecting '''New Login...''' or you may want to use an existing login.
 +
# Open '''Login Properties''' window by double clicking the login. In the '''General''' tab, check that authentication related settings are as desired.
 +
# Open the '''User Mapping''' tab and select the '''Map''' checkbox for the QPR MobileDashboard database. Click also '''db_owner''' in the bottom side of the tab. Click '''OK'''.
 
[[Category: QPR MobileDashboard]]
 
[[Category: QPR MobileDashboard]]

Revision as of 08:40, 26 March 2017

This page contains instructions for SQL Server configuration. Note that these instructions assume that there is an SQL Server 2016 instance with name SQLSERVER2016. Your SQL Server may be other version or have other instance name.

SQL Server TCP/IP port configuration

If named instance are used in the SQL Server, 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. (To be confirmed: Is this actually enough?)
  6. Open SQL Server services and click Restart for SQL Server (SQLSERVER2016).

Checking SQL Server Browser is running

If named instance are used in the SQL Server, the SQL Server Browser service needs to be running. Check it as follows:

  1. Open Services in Windows Control Panel.
  2. Find service SQL Server Browser and check that it has status Running. If the service is missing, SQL Server Browser is not installed.

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 a 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.

Creating new database for QPR MobileDashboard

When making a new installation for QPR MobileDashboard, a new SQL Server database needs to be created as follows:

  1. Open Microsoft SQL Server Management Studio and login to a proper instance.
  2. In Object Explorer right click Databases ans from the popup menu select New database....
  3. Define a name for the database and change other settings for the database if needed (default settings will work for QPR MobileDashboard).
  4. In Object Explorer open click Security and then open Logins. You can create a new login by right clicking Logins and from the popup menu selecting New Login... or you may want to use an existing login.
  5. Open Login Properties window by double clicking the login. In the General tab, check that authentication related settings are as desired.
  6. Open the User Mapping tab and select the Map checkbox for the QPR MobileDashboard database. Click also db_owner in the bottom side of the tab. Click OK.
Retrieved from "https://wiki.onqpr.com/mea/index.php?title=SQL_Server_Configuration_in_QPR_UI&oldid=4135"