Configuring SQL Server for Network Access

When configuring a SQL server to host the ProCal database there are a number of options that must be checked to ensure that the SQL Server is visible from other computers on the network.

In this support article the most common incorrect configurations are listed and should be checked.

Please note - Transmille offer advice on configuring SQL Servers, but we do not replace the need for an IT professional in complicated configurations. Each network is different and depending on your security settings you may need to consult with your IT company to configure for your particular installation. Transmille advise that if your IT systems are managed that your first point of contact is your IT company.

1) Ensuring that the SQL Server is allowing remote connections.

Using Microsoft SQL Server Management Studio, connect to the Instance that hosts the ProCal database and then right click on the Server. In properties ensure that under the 'Connections' option that 'Allow remote connections to this server' is ticked.

2) Ensure that SQL Server and Windows Authentication Mode is enabled.

Using Microsoft SQL Server Management Studio, connect to the Instance that hosts the ProCal database and then right click on the Server. In properties ensure that under the 'Security' options that 'SQL Server and Windows Authentication mode' is selected.

3) Ensuring that the SQL Server Browser service is started on the computer that hosts the SQL Server Instance. Navigate to Services (Type 'Services' into the Windows Start Menu in Windows 10) and then scroll to 'SQL Server Browser' and ensure that in properties that the startup type is set to 'Automatic'.

4) Ensuring that TCP/IP connections are enabled in SQL Server Configuration Manager. Open SQL Server Configuration Manager and navigate to 'SQL Server Network Configuration'. Select the instance that hosts the ProCal Database (normally TRANSMILLE) and ensure that all protocols are enabled.