SQL Server Configuration Manager settings

[G.W.Green]

Once SQL Server has been initially installed, there are a few settings to check or edit if necessary.

1. Open MS SQL Server Configuration Manager:
   “Start | All Programs | Microsoft SQL Server | Configuration Tools”
   
2. Click on ‘SQL Server Services’ from the tree on the left
   
3. From the list on the right, Check that the SQL Server service is running
   
4. Expand ‘SQL Server Network Configuration’ from the tree on the left
   
5. Click on ‘Protocols for [SQL SERVER INSTANCE NAME]
   
6. Double click ‘TCP/IP’ (or right click and choose properties)
   
7. In the ‘Protocol’ tab, ensure ‘Enabled’ is set to yes
   
8. Switch to the ‘IP Addresses’ tab
   
9. Change the TCP Port to the port you are using for SQL Server. The default port is 1433