Live Support
 

Downloads
RepairWriter 4.5 - Beta
Version 4.5.0.10 (02/20/2014)
RepairWriter 4
Version 4.1.1.30 (02/10/2012)

SQL Server Installation
 

Installation

  1. Click the Download link.
  2. .
  3. Click <Run> on the File Download - Security Warning.
    Download Security Warning
     
  4. Click <Yes> on the User Account Control prompt.
    UAC Warning
     
  5. Click New SQL Server stand-alone installation or add features to an existing installation on the SQL Server
    Installation Center
    window.
    SQL Server Menu
     
  6. Accept the License Agreement and Click <Next>.
    License Agreement
     
  7. Click <Next> on the Product Updates window.
    SQL Server Update
     
  8. Click <Next> on the Setup Support Rules window.
    SQL Server Support Rules
     
  9. Click <Next> on the Feature Selection window.
    SQL Server Features
     
  10. Click <Next> on the Installation Rules window.
    SQL Server Install Rules
     
  11. Click <Next> on the Instance Configuration window.
    SQL Server Instance Configuration
     
  12. Click <Next> on the Disk Space Requirements window.
    SQL Server Disk Space Requirements
     
  13. If you are using a multi-user program, change Disabled to Automatic.
  14. Click <Next> on the Server Configuration window.
    SQL Server Server Configuration
     
  15. Change Windows authentication mode to Mixed mode (SQL Server authentication and Windows authentication).
  16. Enter a password.
    This password is used to connect to the SQL Server instance. The password 'rw4!123' is the SDR Software Support standard.
  17. Click <Next> on the Database Engine Configuration window.
    SQL Server Database Engine Configuration
     
  18. Click <Next> on the Error Reporting window.
    SQL Server Error Reporting
     
  19. Click <Close> on the Complete window.
    SQL Server Complete
     
Back to Top

Allowing Access to the SQL Server from a Remote Computer

SQL Server Configuration

  1. Open the Sql Server Configuration Manager and click <Yes> on the User Account Control dialog.
    SQL Server Firewall Menu
     
  2. Select SQL Server Network Configuration and Protocols for Instance Name.
    SQL Server Firewall Menu
     
  3. Double-Click the TCP/IP protocol, change Enabled to Yes and click <OK>.
    SQL Server Firewall Menu
     
  4. Click <OK> on the Restart dialog.
    SQL Server Complete
     
Back to Top

Firewall

Three Firewall rules must be created to allow remote access to SQL Server. If you are using a 3rd-party firewall they must be allowed in the 3rd-part software.

3rd-Party Firewall
  1. Port:
    • Using a Named Instance: UDP Port 1434.
    • Using the Default Instance: TCP Port 1433.
  2. Program: 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.Instance Name\MSSQL\Binn\sqlservr.exe'
  3. Program: 'C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe'
Back to Top
 
Windows Firewall
  1. Open the Windows Firewall with Advanced Security.
    SQL Server Firewall Menu
     
  2. Select Inbound Rules.
    SQL Server Firewall Inbound
     
  3. Select New Rule, Program, and click <Next>.
    SQL Server New Rule - Program
     
  4. Click Browse, navigate to 'C:\Program Files\Microsoft SQL Server\MSSQL11.Instance Name\MSSQL\Binn\sqlservr.exe', click <Open> and <Next>.
    SQL Server Program
     
  5. Click <Next>.
    SQL Server Action
     
  6. Click <Next>.
    SQL Server Profile
     
  7. Enter the name for the rule 'SQL Server' and click <Finish>.
    SQL Server Name
     
  8. Repeat steps #3 thru #7 but choose 'C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe' for the Program (step 4) and 'SQL Browser' for the Name (step #7).
     
  9. Select New Rule, Port, and click <Next>.
    SQL Server New Rule - Port
     
    • Using a Named Instance: Select UDP, Specific local ports, enter '1434' and click <Next>.
    • Using the Default Instance: Select TCP, Specific local ports, enter '1433' and click <Next>.

    SQL Server Port
     
  10. Click <Next>.
    SQL Server Action
     
  11. Click <Next>.
    SQL Server Profile
     
    • Using a Named Instance: Enter the name for the rule 'SQL Browser UDP Port 1434' and click <Finish>.
    • Using the Default Instance: Enter the name for the rule 'SQL Browser TCP Port 1433' and click <Finish>.

    SQL Server Port
     
Back to Top
 

© 2003-2017 SDR Software. All Rights Reserved.