• Digital Workspaces
          • Digital Workspaces

            Enable desktop & application virtualization, identity management, and secure remote access for work from home (WFH) employees

          • zPortal
          • Controller for desktop and application virtualization via shared hosted desktops and VDI

          • zGateway
          • Secure remote users working from any network on any device to protect corporate data

          • SnapVDI Thin Client (zTC)
          • Thin client endPoint devices for Citrix, Microsoft Hyper-V & WVD and VMware

          • zBrows
          • Provide secure browser-based access to virtualized corporate workspace users

          • zMFA
          • Integrated multi-factor authentication (MFA) for secure user verification on any device

          • zClient
          • Software client for installing on your endpoint devices for connection to zPortal and zGateway

    • Healthcare Solutions
          • Healthcare Solutions

            Remote patient monitoring platform and devices for clinicians and caregivers to remotely monitor the vital signs of their patients

          • ZettaRPM
          • Universal cloud-based remote patient monitoring platform for healthcare organizations

          • B.O.L.T Devices
          • Monitor, track, and improve patients’ health with remote patient monitoring (RPM) devices

    • Data Storage Appliances
          • Data Storage Appliances

            Reliable, high-performance SAN appliances with inclusive snapshots, replication, and  automated data tiering software

          • StorTrends 3500i
          • Extreme-performance SAN with Hybrid and All-Flash configurations to handle even the most demanding workloads

          • StorTrends 3400i
          • Highly reliable HDD-based SAN suited for data retention, backups and low-performance environments

          • StorTrends 3202j
          • Expansion shelf configurable as all-HDD, hybrid, or all-flash to seamlessly add capacity to the StorTrends 3500i or StorTrends 3400i

  • Knowledge Base
  • Company
  • Events
  • Support
  • Contact

How Can We Help?

SQL Configuration

You are here:
< All Topics

The SnapVDI zPortal Controller requires a SQL database for storing data. If you do not have an instance of a SQL server running, you can install an instance of SQL Express.

Microsoft SQL Compact Installation

Ensure that Microsoft SQL Compact is installed on the server that will host the zPortal Controller. If this is not installed, or you are not sure if it is installed, you can download the installer from here.

Configure SQL Server to Listen on Static Port

Static ports are being encouraged and are a must in zPortal Configurations for security and ease of manageability reasons.
Follow the below steps to configure SQL Server to use static TCP port:

  1. Open SQL Server Configuration Manager
  2. Click on SQL Server Services in the left pane
    <sql1.png>
  3. In right pane, note down the Process ID of the SQL Server instance, such as 116 in the screenshot above
  4. Open Command Prompt and run the following command:
    netstat -ano | findstr /i <PID of SQL server instance>
    example: netstat -ano | findstr /i
    116
    <sql2.png>
  5. If the command does not show any result (as shown in the screenshot above), that means the SQL server instance is not using any static TCP port and should be configured to use one
  6. To enable SQL Server to use static port, in SQL Server Configuration Manager
    1. Click on SQL Server Network Configuration in the left pane
      <sql3.png>
      <sql4.png>
    2. Right-click on TCP/IP protocol
    3. Click on Properties
      <sql5.png>
    4. Go to IP Addresses tab
    5. Scroll down to IPAll section
      <sql6.png>
    6. Remove the value for TCP Dynamic Ports (do not enter zero (0)!!)
    7. Enter 1433 for TCP Port
      <sql7.png>
  7. Restart SQL Server service, identify new process ID assigned to SQL service and in the command prompt execute command to verify that SQL Service is now listening on configured TCP Port 1433
    netstat -ano | findstr /i <PID of SQL server instance>
    <sql8.png>
  8. At this stage, SQL Express is configured to listen on standard port 1433
NOTE: If you are using firewall you need to add an exception for the 1433 port to allow TCP/IP traffic on port 1433.

Configure a Windows Firewall for Database Engine Access

  1. To add a windows firewall exception for the port 1433, open Administrative Tools and select Windows Firewall with Advanced Security option.
  2. In the Windows Firewall with Advanced Security dialog box click on the Inbound Rules options and select the New Rule command.
    <sql9.png>
  3. In the New Inbound Rule wizard select the Port option and click Next
    <sql10.png>
  4. In the Protocols and Ports window specify the protocols and ports to which a rule applies. Select the TCP option, in the Specific local ports text box enter the 1433 port, and click Next
    <sql11.png>
  5. In the Action window select the Allow the connection to specify the action to be taken when a connection matches the conditions specified in the rule
    <sql12.png>
  6. Specify the profiles for which the rule applies in the Profile window, and click Next
    <sql13.png>
  7. In the last window specify the name of the created rule and click the Finish button
    <sql14.png>
  8. You can now see the created rule in the list of inbound rules
    <sql15.png>

Turn On SQL Server Browser Service

Follow the below steps to enable the SQL Server browser service

  1. Open SQL Server Configuration Manager and click on SQL Server Services in the left pane, right-click SQL Server Browser service and select Properties
    <sql16.png>
  2. Go to Service tab and for Start Mode option change start type to Automatic and click Apply
    <sql17.png>
  3. Click Start button to start SQL Browser service
    <sql18.png>
  4. Confirm that SQL Server Browser service is up and running
    <sql19.png>

Enable Remote Connection on SQL Server Instance

  1. Open SQL Management Studio – Connect to SQL server to be configured as database server for zPortal Controller
  2. Right-click server name in the left pane and select Properties
    <sql20.png>
  3. Select Connections in the left pane
  4. Make sure the checkbox Allow remote connections to this server  is selected as it is shown in the screenshot below
    <sql21.png>
  5. To make sure that changes comes in effect, open SQL Server Manager. In the left pane of SQL Server Configuration Manager click SQL Server Services, right-click SQL Server<instance_name>, and click Restart
    <sql22.png>
Was this article helpful?
4.5 out of 5 stars
5 Stars 0%
4 Stars 100%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents
Top