Failed to connect to SQL server WSUS Role

Question

Hello, we have a new Server 2019 Standard. Installed SQL server 2019 and need this server configured as a WSUS server. Joined to domain. All SQL services running. Can connect withing Studio also. Installed WSUS role and when getting to the Database Instance Screen I enter servername\instance, the check connection button. I get the error "Failed to connect to the SQL server"
Exception Detail.......
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

Does anyone have any advice.
Thank you

Answer 1

I'm having this issue with my Server 2022 and SQL 2022 install.

• MCM/WSUS Server: LABMCM01
• SQL Server: LABSQL01
  • LABSQL01\WSUS - Running on port 1433
    • LABSQL01\MCM - Running on port 1435

LABSQL01 has dynamic port off on both instances, ipv4 and ipv6 NICs Enabled and Active on their respective ports, and 1433-1435 allowed through the firewall. Both servers are a fresh install of Server 2022, joined to a lab domain (also a fresh install of 2022, only GPO is to enable remote desktop). SQL services are running as a domain user (svc_mcmsql).

Test-NetConnection from the MCM/WSUS server to the SQL server on both ports works. I've run SQLCHECK from the MS SQL diagnostics github and attached the results. I cannot use SSMS on the MCM/WSUS server to connect to either instance on the SQL server using <ComputerName><InstanceName> (LABSQL01\WSUS). What am I doing wrong here?

SQLCheck.LABSQL01.20230919154124.txt