Thank you for your feedback.

Was this useful?

How to configure SQL Protocols for IRIS Practice Software

Article ID
ias-10476
Article Name
How to configure SQL Protocols for IRIS Practice Software
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?