Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Configure SQL Express 2016 for remote connection to NPM 12.x

Configure SQL Express 2016 for remote connection to NPM 12.x

Table of contents

Updated December 19, 2016

Overview

For situations where SQL Express is installed on a separate machine from SolarWinds Orion Platforms, these configuration changes need to be made on the SQL Server Express machine. 

Environment

  • SQL Server Express
  • NPM 12.x

Steps

  1. From the SQL Server Express machine, launch SQL Center Configuration Manager.
  2. Expand SQL Server Network Configuration.
  3. Select the instance for your Orion NPM installation. By default, this will be Protocols for SQLEXPRESS.
  4. Change the Named Pipes protocol option to Enabled. The default Pipe Name setting is fine. 
  5. Click OK.
  6. Change the TCP/IP protocol option to Enabled. 
  7. Under TCP/IP Properties, select the IP Addresses tab and scroll down to IPAll.
  8. Change the TCP Port to 1433, delete the TCP Dynamic Ports if listed, and then click OK.
  9. Open Services.msc, and set the SQL Server Browser service to start automatically.
  10. Click start to start the service, and then click OK.
  11. Back in SQL Server Configuration Manager, select the SQL Server Services entry from the left pane.
  12. In the right pane, double-click the SQL Server Browser service.
  13. Click the Service tab, and change the Start Mode to Automatic. 
  14. Right-click the SQL Server service at the top of the right pane, and select Restart.

 

Once the service is restarted, you should now be able to configure NPM to connect to your SQL Express instance. When you run the Configuration Wizard, it will prompt you to input your SQL Server name. If you have not changed this from default, it will be <SQLSERVERNAME>\SQLEXPRESS.

 

 

 

 

Last modified

Tags

Classifications

Public
/*]]>*/