question

ComputerGladiator2 avatar image
1 Vote"
ComputerGladiator2 asked RitaHu-MSFT answered

Failed to connect to SQL server WSUS Role

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

windows-server-update-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RitaHu-MSFT avatar image
0 Votes"
RitaHu-MSFT answered RitaHu-MSFT edited

@ComputerGladiator2
Thanks for your posting on Q&A.

Please help to confirm the following services of SQL Server are running normally first:
194911-8.png

In addition, the default SQL Server instance is mssqlserver. Please help to make sure you have print the right instance name. Please refer to the below screenshot to review the name of the instance:
194829-9.png

Best regards,
Rita


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


8.png (22.9 KiB)
9.png (25.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ComputerGladiator2 avatar image
1 Vote"
ComputerGladiator2 answered

Hi, thank you for your response. I was entering the correct default instance which in my case was MSSQLSERVER. The format that was required as per the instructions I was following and researching was to enter the <servername>\MSSQLSERVER. As mentioned I kept getting the error as indicated previously. I found an article on the internet that suggested not to enter MSSQLSERVER since it was already recognized by the process as the default if used.
I removed the MSSQLSERVER and only left the <servername> and I was successful in getting to the next steps without errors to complete the installing of the WSUS Role.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RitaHu-MSFT avatar image
3 Votes"
RitaHu-MSFT answered

@ComputerGladiator2
Thanks very much for your feedback. We're glad that the question is solved now. Here's a short summary for the problem , this will help other users to search for useful information more quickly.

Problem/Symptom:
Failed to connect to SQL server WSUS Role

Solution/Workaround:
Enter the Server name without instance

Best regards,
Rita


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.