RepairWriter
Live Support
Download Demo
Product Information
Downloads
Support
Contact
Partners
Product Information
Version Comparison
System Requirements
Download Demo
Setup Instructions
Screenshots
New Features
RepairWriter Help
SQL Server Installation
SQL Server 2016 Installation
SQL Server 2017 Installation
SQL Server Management Studio
(SQL Server 2016 or higher only.)
Allowing Access to the SQL Server from a Remote Computer
SQL Server Configuration
Firewall
3rd-Party Firewall
Windows Firewall
SQL Server 2016 Installation
Download SQL Server Express.
Downloads
Click
<Run>
on the
File Download - Security Warning
.
Click
<Yes>
on the
User Account Control
prompt.
Click
<Ok>
on the
Choose Directory for Extracted Files
prompt.
Wait for the files to extract.
Click
New SQL Server stand-alone installation or add features to an existing installation
on the
SQL Server Installation Center
window.
Accept the
License Agreement
and Click
<Next>
.
Select
Use Microsoft Update
and click
<Next>
.
Click
<Next>
on the
Product Updates
window.
Wait for the updates to complete.
Click
<Next>
on the
Setup Rules
window.
Click
<Next>
on the
Feature Selection
window.
Click
<Next>
on the
Instance Configuration
window.
If you are using a multi-user program, change
Disabled
to
Automatic
. Click
<Next>
.
Change
Windows authentication mode
to
Mixed mode (SQL Server authentication and Windows authentication)
, enter a password and click
<Next>
.
This password is used to connect to the SQL Server instance. The password 'rw4!123' is the SDR Software Support standard.
Wait for the program to install.
Click
<Close>
on the
Complete
window.
Back to Top
SQL Server 2017 Installation
Download SQL Server Express.
Downloads
Click
<Run>
on the
File Download - Security Warning
.
Click
<Yes>
on the
User Account Control
prompt.
Select
Custom
installation type.
Click
<Install>
.
Wait while the program is downloaded and installed.
Click
New SQL Server stand-alone installation or add features to an existing installation
on the
SQL Server Installation Center
window.
Accept the
License Agreement
and Click
<Next>
.
Click
<Next>
on the
Setup Rules
window.
Click
<Next>
on the
Feature Selection
window.
Click
<Next>
on the
Instance Configuration
window.
If you are using a multi-user program, change
Disabled
to
Automatic
. Click
<Next>
.
Change
Windows authentication mode
to
Mixed mode (SQL Server authentication and Windows authentication)
, enter a password and click
<Next>
.
This password is used to connect to the SQL Server instance. The password 'rw4!123' is the SDR Software Support standard.
Click
<Accept>
and
<Next>
to install
Microsoft R Open
.
Click
<Accept>
and
<Next>
to install
Python
.
Wait for the program to install.
Click
<Close>
on the
Complete
window.
Back to Top
SQL Server Management Studio (SSMS)
Download
SQL Server Management Studio
.
Click
<Run>
on the
File Download - Security Warning
.
Click
<Yes>
on the
User Account Control
prompt.
Click
<Install>
on the
User Account Control
prompt.
Wait for the program to install.
Click
<Restart>
if prompted to restart the computer or click
<Close>
.
Back to Top
Allowing Access to the SQL Server from a Remote Computer
SQL Server Configuration
Open the
SQL Server Configuration Manager
and click
<Yes>
on the
User Account Control
dialog.
Select
SQL Server Network Configuration
and
Protocols for
Instance Name
.
Double-Click the
TCP/IP protocol
, change
Enabled
to
Yes
and click
<OK>
.
Click
<OK>
on the
Restart
dialog.
Back to Top
3rd-Party Firewall
Port
:
Using a Named Instance
:
UDP
Port 1434.
Using the Default Instance
:
TCP
Port 1433.
Program
: 'C:\Program Files\Microsoft SQL Server\MSSQL14.
Instance Name
\MSSQL\Binn\sqlservr.exe'
Program
: 'C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe'
Back to Top
Windows Firewall
Open the
Windows
Firewall with Advanced Security
.
Select
Inbound Rules
.
Select
New Rule
,
Program
, and click
<Next>
.
Click
Browse
, navigate to 'C:\Program Files\Microsoft SQL Server\MSSQL11.
Instance Name
\MSSQL\Binn\sqlservr.exe', click
<Open>
and
<Next>
.
Click
<Next>
.
Click
<Next>
.
Enter the name for the rule 'SQL Server' and click
<Finish>
.
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).
Select
New Rule
,
Port
, and click
<Next>
.
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>
.
Click
<Next>
.
Click
<Next>
.
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>
.
Back to Top