Configure Microsoft SQL Server

Configure Microsoft SQL Server 2012

 

Microsoft SQL Server 2012 External Access

 

Once the server is installed and running, we will need to configure the server to allow the workstations to connect and retrieve data as needed, in order to do this we need to allow TCP/IP Access via port 1433.

First we need to open the SQL Server Configuration Manager

 

 

 

 

Restarting the Microsoft SQL Server 2012

 

After making the changes to the TCP/IP Ports and Settings, we need to restart the server. To do this follow the list of steps below.

Single left click on “SQL Server Services” (as seen in the image!)

Right click on SQL Server (SQLExpress) — (on the right!) Single left click “Restart”