Thank you for that. Some joker (not me) pre-configured WSUS with WID on a server that slated to become the SUP and another joker (me) did not check before the site install.
Awesome tutorial. Clean and to the point. I did run into some problems though. I was getting connection refused errors in WCM.log. If anyone uses an unc path as their content folder you should check in iis physical path under the content folder in basic or advanced settings. Also, I had to edit authentication for the iis content folder under anonymous to use the app pool account instead of IIS_IURS.
Definitely need to make those changes in IIS for UNC WSUS Content good catch. I do specifically cover that in this guide as well setupconfigmgr.com/using-a-shared-wsus-database-for-multiple-sups-in-sccm
Very impressed - clear and precise instructions, nice one. I had to move my DB to another server so i had to research permissions etc - apart from that spot on :D
I enjoyed every single explanation I did on your video. Congratulations! Just only one question: My SQL Server is a remote server other than yours because you use a local server. Because that you didn't provide user name and password to conect to SUSDB in your server. What can I do to inform username and password instead of using my own logged on username?
I don't have the Server listed in SQL services (mssqlserver) so I cannot connect to it using SQL studio. There are plenty of other SQL services like Sophos,Net2 etc, but not the MSSQLServer service. What do I need to enable/install to make the server itself connectable in SQL studio?
Thank you for this great video But sorry to ask you something outside this video I have noticed that third party update like 7zip and chrome are shown in WSUS But this is not my case in my environment I am using patchmypc with publish software
In this lab, we had the option to make third-party updates visible in WSUS in the advanced tab of our service. This doesn't need to be configured if you are using SCCM to deploy updates though. - Justin
Hello after all those steps wsus downloads updates but client pcs are not downloading the updates stays in 0% , take in mind it was working ok before movin to sql, long story sort there was an error in wid database that the only solutions was to migrate to sql.
Hey Justin, I am getting the following error when trying to attach my SUSDB.mdf and SUSDB_Log.ldf An Error has occurred when attaching the database. Click on the hyperlink in the messages column for details. Any ideas?
I found out my answer. The database SUSDB cannot be opened because it is version 782. This server only supports version 706 and earlier. A downgrade path is not supported.
Thank you for all explanation. This content is gold and helped me to troubleshoot th WSUS Server on my job!
video more precious, clearer and more objective than this one doesn't exist. Excellent, congratulations!
Thanks for watching!
Went thru your video and performed this task with zero issues. Thank you so much for the video's, learning a lot.
Thanks for watching
Thank you for that. Some joker (not me) pre-configured WSUS with WID on a server that slated to become the SUP and another joker (me) did not check before the site install.
Thanks for watching.
Crystal clear. Wonderful work as always. I wait for your videos like a bonus :)
Thanks for watching!
Awesome tutorial. Clean and to the point. I did run into some problems though. I was getting connection refused errors in WCM.log. If anyone uses an unc path as their content folder you should check in iis physical path under the content folder in basic or advanced settings. Also, I had to edit authentication for the iis content folder under anonymous to use the app pool account instead of IIS_IURS.
Definitely need to make those changes in IIS for UNC WSUS Content good catch. I do specifically cover that in this guide as well setupconfigmgr.com/using-a-shared-wsus-database-for-multiple-sups-in-sccm
Very impressed - clear and precise instructions, nice one. I had to move my DB to another server so i had to research permissions etc - apart from that spot on :D
Thanks for watching
I enjoyed every single explanation I did on your video. Congratulations! Just only one question: My SQL Server is a remote server other than yours because you use a local server. Because that you didn't provide user name and password to conect to SUSDB in your server. What can I do to inform username and password instead of using my own logged on username?
EPIC!!!! thanks!!!
Glad you liked it!
Hi Justin, great tutorial as always ! Thank you.
Is the WSUS database supported on a SQL Always ON migration scenario as well ?
Not sure about that one, I suspect it would probably work fine, but I haven't checked the docs to see if it's supported.
Awesome Demo..thanks a lot
You're welcome! Thanks for watching.
I don't have the Server listed in SQL services (mssqlserver) so I cannot connect to it using SQL studio. There are plenty of other SQL services like Sophos,Net2 etc, but not the MSSQLServer service. What do I need to enable/install to make the server itself connectable in SQL studio?
You need to install SQL server, covered in the first how to install sccm video I did
Thank you for this great video
But sorry to ask you something outside this video
I have noticed that third party update like 7zip and chrome are shown in WSUS
But this is not my case in my environment
I am using patchmypc with publish software
In this lab, we had the option to make third-party updates visible in WSUS in the advanced tab of our service. This doesn't need to be configured if you are using SCCM to deploy updates though. - Justin
@@PatchMyPC Thank you for your clarification
No need for "SQL Server Connectivity" feature? I did the migration, all works, just wondering...
SQL connectivity should be enabled for WSUS if you use SQL
Hello after all those steps wsus downloads updates but client pcs are not downloading the updates stays in 0% , take in mind it was working ok before movin to sql, long story sort there was an error in wid database that the only solutions was to migrate to sql.
WSUS with SCCM?
@@PatchMyPC only wsus wServer 2012 , if the downloading doesnt succeeds it throws Downlaod error 0% 0x80070020
@@PatchMyPC hello
How do you have things such as 7-zip, Chrome, and Java in WSUS?
patchmypc.com
Hey Justin, I am getting the following error when trying to attach my SUSDB.mdf and SUSDB_Log.ldf An Error has occurred when attaching the database. Click on the hyperlink in the messages column for details. Any ideas?
I found out my answer. The database SUSDB cannot be opened because it is version 782. This server only supports version 706 and earlier. A downgrade path is not supported.
Thanks for the followup
This didnt work for me \\. \pipe\MICROSOFT##WID\tsql\query
www.ajtek.ca/wsus/how-do-i-connect-to-the-windows-internal-database-wid/
Microsoft should just link to you lol
:)