SQL Server Connection Configuration

The SQL Reporting solutions require that all SQL Server instances be configured to enable 'TCP/IP' and 'Named Pipes' connection protocols.

These settings can be found in the SQL Server Network Configuration tab of SQL Server Configuration Manager.

On the MS SQL Server, open SQL Server Configuration Manager from the MS Windows Start menu.

In the left-hand navigation pane, expand the SQL Server Network Configuration item and then left click on the 'Protocols for XXX' item, where XXX is the SQL Server instance name of the database instance.

In the main pane, verify that both 'TCP/IP' and 'Named Pipes' are enabled, right click on the line and select 'Enable'.

If either option was updated:

a)   In the left hand navigation pane, click on the 'SQL Server Services' item.

b)   Find the 'SQL Server (XXX)' item, where XXX is the SQL Server instance name of the database instance. Right click on that line and select Restart.

If the settings do not update successfully, you may need to exit SQL Server Configuration Manager and reattempt running SQL Server Configuration Manager as an Administrator.
Provide feedback on this article