Setup is unable to access the SQL UDP port 1434 on the specified SQL Server
Technical Articles ID:
KB88000
Last Modified: 2023-07-20 08:48:28 Etc/GMT
Environment
ePolicy Orchestrator (ePO) 5.x
Problem
During the ePO installation, an error similar to the following is displayed:
Setup is unable to access the SQL UDP port 1434 on the specified SQL server. Setup requires such access to retrieve the TCP port assignment information from the SQL server.
If you must leave this port blocked, enter the TCP port assignment manually in the "SQL server TCP port" field in Setup.
Cause
The remote TCP/IP connection is disabled.
Solution
1
Verify that the remote connection to the SQL service works. Also, verify that the SQL Server process is up and running on the specified port:
- Verify that the SQL Server IP is set correctly:
- Go to the ePO SQL DB system.
- Press Windows+R, type cmd.exe, and then press Enter or click OK.
- Type ipconfig and press Enter.
- Note the IP of the ePO DB system.
- Take one of the following actions:
- Verify that the IP found is same as the IP of the system entered during ePO setup.
- Verify that the DNS entered in the DB configuration details during ePO setup resolves to the same IP found in the ePO DB System.
NOTE: Make sure that there's no IP address conflict. Confirm that the IP address isn't conflicting with any other system. The IP can be assigned via your network DHCP server or manually to the ePO DB system.
- Verify that the SQL Server is set with mixed authentication mode:
- Open Microsoft SQL Server Management Studio and connect to the SQL Server.
- Right-click the SQL Server Instance and select Properties.
- On Server Properties, select Security from the left window.
- Select SQL Server and Windows Authentication mode.
- Click OK on the pop-up window.
- Right-click the SQL Server Instance and select Restart.
- Verify that the SQL Browser Service is running and set to Automatic start mode:
- Click Start, Programs, Microsoft SQL Server, Configuration Tools, and select SQL Server Configuration Manager.
- Select SQL Server Services.
- Double-click SQL Server Browser. Opens the Properties window.
- Open the Service tab and change Start Mode to Automatic.
- Return to the SQL Server Configuration Manager, right-click SQL Server Browser, and click Start.
- Verify that SQL Server TCP/IP is set to Enabled:
- Click Start, Programs, Microsoft SQL Server, Configuration Tools, and select SQL Server Configuration Manager.
- Expand SQL Server Network Configuration, Protocols for SQLEXPRESS.
- Right-click TCP/IP and click Enable.
- Click OK on the pop-up window.
- Select SQL Server Services, select SQL Server on the right window, and then click Restart.
- Start the ePO install again. The installation completes without any issue.
Solution
2
If Solution 1 fails, perform the steps below:
- To determine the port being used by SQL:
- Start SQL Server Configuration Manager.
- Expand SQL Server Network Configuration, and select the Protocols item for your SQL instance.
- Double-click TCP/IP. The TCP/IP Properties window opens.
- Click the IP addresses tab, and make sure Enabled is set to Yes for each active IP address.
- Under IPAII, make note of the value for TCP Dynamic Ports.
If there's a value specified, for example 57482, your SQL Server is using dynamic ports. Make a note of the value because this information might be needed later in the installation.
NOTE: When you use dynamic ports, the SQL Browser service must be running on the SQL Server. If the value for TCP Dynamic Ports is blank, your SQL Server is using a static port, and the value for this port is shown in the TCP Port field.
- When you're using dynamic ports, make a note of the SQL instance name that hosts the ePO database. When using the default instance for SQL, the instance name is MSSQLSERVER.
NOTE: If the solutions above don't resolve your issue, contact Technical Support for help.
- If you are a registered user, type your User ID and Password, and then click Log In.
- If you are not a registered user, click Register and complete the fields to have your password and instructions emailed to you.
|
