Home | Knowledge Base Articles | How to configure SQL Protocols for IRIS Practice Software

Thank you for your feedback.

Was this useful?

Yes No

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
    E mail 64 | How to configure SQL Protocols for IRIS Practice Software twitter | How to configure SQL Protocols for IRIS Practice Software

    • Thank you for your feedback.

    Was this useful?

    Yes No

    Related Products

    IRIS Keytime

    IRIS Keytime provides a straightforward system integrating tax, accounts, and practice management in one place. This affordable solution for smaller accountancy practices enables users to effectively handle key compliance work.

    See product details

    IRIS Innervision

    IRIS Innervision is an international leader in the provision of IFRS 16 and FASB ASC 842 Lease Accounting Software and Lease Portfolio Management services to global corporate lessees.

    See product details

    IRIS Elements Practice Management

    Intuitive practice management with integrated email and text messaging, customisable workflows and easy to configure CRM, all available through the IRIS Elements platform.

    See product details

    Related Articles

    No Related Articles found

    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.

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

    © IRIS Software Group Ltd 2024