Click on the Category button to get more articles regarding that product.
Unable to connect to WSUS WID with SQL Management Studio V20, does not support encryption
We just had a customer where a newer version of SQL Server Management Studio was installed to manage the WID (Windows Internal Database) of the WSUS server on a Server 2022 OS.
With the EOL for WSUS Server (only development and new features; you are still able to use that great tool), we thought this might be how things will go in the future. But you would still
Be able to download an older version of the management Studio.
|
Error you see: |
|
|
|
TITLE: Connect to Server
Cannot connect to \\.\pipe\microsoft##WID\tsql\query.
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Named Pipes Provider, error: 0 – Kein Prozess ist am anderen Ende der Pipe.) (Microsoft SQL Server, Error: 233)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-233-database-engine-error |
\\.\pipe\microsoft##WID\tsql\query
\\.\pipe\MICROSOFT##WID\tsql\query
Connect to WID Windows Internal Database on Server 2016-2022.
Error you see which should explain it all.
Simple solution: Change Connection Security Encryption to Optional. 😉
Works
Plesse see our other Blog entrys related to WSUS and SQL
WSUS problem or unstable when WID SQL is getting to big, how to shrink – www.butsch.ch
https://www.butsch.ch/post/wsus-problem-or-unstable-when-wid-sql-is-getting-to-big-how-to-shrink/
https://www.butsch.ch/post/category/wsus/