How to Connect the SQL Server Using a Specific Port in Citrix Session Recording Server

How to Connect the SQL Server Using a Specific Port in Citrix Session Recording Server

book

Article ID: CTX340180

calendar_today

Updated On:

Description

This article is designed to describe how to connect the SQL Server using a specific port in Citrix Session Recording Server.


Instructions

Change the SQL Server to using a specific port
  1. Launch SQL Server Configuration Manager in the SQL Server
  2. Native to SQL Server Network configuration--Protocols for MSSQLServer--TCP/IP
  3. Modify the port number, Ex: modify to 1455
image.png

Change the Citrix Session Recording to connect SQL Server by a specific port
  1. In Citrix Session Recording Server, please open Registry by running regedit.
  2. Navigate to the following pathes:
    • HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Citrix\SmartAuditor\Database\SmAudDatabaseInstance
    • HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\SmartAuditor\Server\SmAudDatabaseInstance
    • Modify the vaule to dbservername, portnumber, Ex: sqlserver.a.com,1455
  3. Restart the Citrix Session Recording server.

Environment

Caution! Using Registry Editor incorrectly can cause serious problems that might require you to reinstall your operating system. Citrix cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk. Be sure to back up the registry before you edit it.