How to configure SQL Protocols for IRIS Practice Software

Article ID

ias-10476

Article Name

Created Date

6th June 2012

Product

Problem

How to configure SQL Protocols for IRIS Practice Software.

Resolution

For IRIS to work with SQL you need to make sure the target SQL Server is running and is using the appropriate protocols. You can use SQL Server Configuration Manager (SCM) to enable protocols on the PC.
SQL Server supports Shared Memory, Named Pipes, and TCP protocols (and VIA which needs special hardware and is rarely used).
Once an SQL Instance is installed you will need to configure your SQL Server Client Protocols correctly.
The IRIS installation requires that they are as follows – Shared Memory, Named Pipes and TCP/IP are enabled and VIA is disabled. For Standalone Machines only, TCP/IP can also be disabled.

To enable or disable a client protocol

Click Start | All Programs | Microsoft SQL Server 2017 or your equivalent.

Select SQL Server 2017 Configuration Manager (or your equivalent)

Select SQL Server Configuration Manager, expand SQL Server Network Configuration, Select Protocols for your instance (SQLEXPRESS or IRISPRACTICE for example)

Right-click a protocol in the window to the right box, and then click Enable, to enable a protocol.

Ricght-Click a protocol in the Enabled Protocols box, and then click Disable, to disable a protocol.

If you enable or disable a protocol you will need to restart the SQL server service before the change will take effect.

This can be done by selecting SQL Server Services, then right clicking on your SQL instance and selecting “restart”.

Share This Page

Thank you for your feedback.

Was this useful?

Yes No

We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.

Escalate to Support?

First Name *

Last Name *

Company Name *

Email Address *

Phone Number *

IRIS Feedback *

For information on how we manage your data please view our privacy policy