Comments on: Quickly Reindex WSUS Database using T-SQL Script https://www.prajwaldesai.com/reindex-wsus-database-using-t-sql-script/ SCCM | ConfigMgr | Intune | Windows 11 | Azure Fri, 02 Sep 2022 13:16:50 +0000 hourly 1 https://wordpress.org/?v=6.4.1 By: Nasir Naeem https://www.prajwaldesai.com/reindex-wsus-database-using-t-sql-script/#comment-39486 https://www.prajwaldesai.com/?p=307993#comment-39486 Hi Guys,
For people visiting this blog in future. Here are the steps to connect SSMS to WID.

1) Install SSMS. Download latest version from Micorosoft.
2) Laucnh SSMS with admin priviliges (as Administrator).
3) The connection string is np:\\.\pipe\MICROSOFT##WID\tsql\query
4) Follow the guide provided by Prajwaldesai.

]]> By: Maarten van Dijk https://www.prajwaldesai.com/reindex-wsus-database-using-t-sql-script/#comment-37420 https://www.prajwaldesai.com/?p=307993#comment-37420 Additionally, I would like to mention that on a standalone WSUS server SQL studio is still useful but you need to know how to connect to the Windows Internal Database (WID).

]]> By: Maarten van Dijk https://www.prajwaldesai.com/reindex-wsus-database-using-t-sql-script/#comment-37417 https://www.prajwaldesai.com/?p=307993#comment-37417 Dear Prajwal,
Thank you for the beautiful detailed expenation about how to maintain the WSUS DB using a script throuh SQL Studio. I’m running is on a standalone server and therefore I cannot use this. I need to make use of the sqlcmd utility. The installation needs the odbc drivers but after installing these it will install. What I miss is some more expleantion about how to apply this T-SQL script to the Windows Internal Database.

]]>