Troubleshooting

When deploying WSUS There are a lot of things that could go wrong. One of the common things is that the post install tasks failed when running a SQL Setup.

one of the error you could see in your logs are:
System.Net.Sockets.SocketException (0x80004005): No such host is known
   at System.Net.Dns.GetAddrInfo(String name)
   at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
   at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
   at Microsoft.UpdateServices.Internal.SetupInfo.IsServerRemote(String serverName)
   at Microsoft.UpdateServices.Administration.ConfigureDB..ctor(String instanceName, Action`1 logWriter, Nullable`1 contentLocal)
   at Microsoft.UpdateServices.Administration.ConfigureDB.Run(String instanceName, Action`1 logWriter, Boolean contentLocal)
   at Microsoft.UpdateServices.Administration.PostInstall.Run()
   at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)



Steps to check if there are blocking issues

The issue can be resolved by checking some values or permissions and if that doesn't work by running the task by hand.

  • first check out if your computer account has enough rights on the SQL Server. I changed mine while installing to Sysadmin so it could create a database. after the install is set the user as DB owner role on the SUSDB and then unchecked the sysadmin role
  • is there already a database with the name SUSDB? The installer creates always a database with the name SUSDB so if a other database exists this will go wrong. After the installation you can change the name.
  • check if the connection string is correct.

Actions Required Resolve the issue

The issue can be resolved by checking some values or permissions and if that doesn't work by running the task by hand.

  • if all above settings are correct and the installation fails run it by hand:

    %programfiles%\update services\tools\wsusutil.exe postinstall CONTENT_DIR=<WSUSDATAPATH> SQL_INSTANCE_NAME=<SQLSERVERNAME>
    my connecting string %programfiles%\update services\tools\wsusutil.exe postinstall CONTENT_DIR=\\fileserver\WSUS\ WSUS SQL_INSTANCE_NAME=sql01.vincentboots.nl
  • This should solve your issue


References

  • https://docs.microsoft.com/en-us/windows-server/administration/windows-server-update-services/deploy/1-install-the-wsus-server-role 
  • https://social.technet.microsoft.com/Forums/ie/en-US/e1003863-e331-46da-8803-e8625bb6324b/server-2012-wsus-postdeployment-configuration-fails-comprehending-the-log-file?forum=winserverwsus

Don't forget to tag the article with appropriate keywords so other users can find and learn from your experiences!