SQL Server Configuration in QPR UI

From Mea Wiki
Revision as of 13:58, 24 March 2017 by Ollvihe (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This page contains all SQL Server configuration related instructions.

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

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

  1. Open Sql Server 20XX Configuration Manager.
  2. Click SQL Server Network Configuration and Protocols for SQLSERVER2016.
  3. Doubleclick TCP/IP
  4. In Protocol tab, select Enabled is Yes
  5. In IP Addresses tab, in section IP All 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

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