How To
      Back to home
      1. Learning Center
      2. OptionPower
      3. How To

      How do you configure connections for OptionPower Remote Database Module?

      Instructions for settings to enable remote database connections allowing data review and reporting from a remote control computer.

      Configure MSSQL 2012 for Remote Connections

      Open SQL Server Configuration Manager

      Windows 8

      Go to Start, type SQL Server in the Search Field, double-click SQL Server

      Windows 10

      Go to c:\Windows\SYSWOW64 and double-click SQLServerManager11

      Change Configuration Settings

      1. Select “SQL Server Services”
      2. Right click “SQL Server Browser” and select “Properties”
      1. Click the “Service” tab and set Start Mode to “Automatic”
      2. Click “OK”
      3. Right click “SQL Server Browser” and select “Start”
      4. Select “SQL Server Network Configuration” à “Protocols for OTI_SQL2k5”
      5. Right click “Named Pipes” à “Enable” (click OK on message)
      6. Right click “TCP/IP” à “Enable” (click OK on message)
      7. Select “SQL Server Services”
      8. Right click “SQL Server (OTI_SQL2K5)” and select Restart

      *** You should also turn off your Windows Firewall when trying to connect to a remoted database.