Hi,

Encounter some error on the DB connection to SQL 2012 server

Fatal Error: No such host is know.

Below is the error message capture

====================================================================

2015-09-07 18:37:52  Postinstall started
2015-09-07 18:37:52  Detected role services: Api, Database, UI, Services
2015-09-07 18:37:52  Start: LoadSettingsFromParameters
2015-09-07 18:37:52  Content local is: True
2015-09-07 18:37:52  Content directory is: D:\WSUSDB
2015-09-07 18:37:52  SQL instname is: MSSQLSERV, 3000
2015-09-07 18:37:52  End: LoadSettingsFromParameters
2015-09-07 18:37:52  Start: Run
2015-09-07 18:37:52  Fetching WsusAdministratorsSid from registry store
2015-09-07 18:37:52  Value is S-1-5-21-510732343-3707520392-1156896604-1001
2015-09-07 18:37:52  Fetching WsusReportersSid from registry store
2015-09-07 18:37:52  Value is S-1-5-21-510732343-3707520392-1156896604-1002
2015-09-07 18:38:52  Configuring content directory...
2015-09-07 18:38:52  Configuring groups...
2015-09-07 18:38:52  Starting group configuration for WSUS Administrators...
2015-09-07 18:38:52  Found group in regsitry, attempting to use it...
2015-09-07 18:38:59  Writing group to registry...
2015-09-07 18:38:59  Finished group creation
2015-09-07 18:38:59  Starting group configuration for WSUS Reporters...
2015-09-07 18:38:59  Found group in regsitry, attempting to use it...
2015-09-07 18:38:59  Writing group to registry...
2015-09-07 18:38:59  Finished group creation
2015-09-07 18:38:59  Configuring permissions...
2015-09-07 18:38:59  Fetching content directory...
2015-09-07 18:38:59  Fetching ContentDir from registry store
2015-09-07 18:38:59  Value is D:\WSUSDB
2015-09-07 18:38:59  Fetching group SIDs...
2015-09-07 18:38:59  Fetching WsusAdministratorsSid from registry store
2015-09-07 18:38:59  Value is S-1-5-21-510732343-3707520392-1156896604-1001
2015-09-07 18:38:59  Fetching WsusReportersSid from registry store
2015-09-07 18:38:59  Value is S-1-5-21-510732343-3707520392-1156896604-1002
2015-09-07 18:38:59  Creating group principals...
2015-09-07 18:38:59  Granting directory permissions...
2015-09-07 18:38:59  Granting permissions on content directory...
2015-09-07 18:38:59  Granting registry permissions...
2015-09-07 18:38:59  Granting registry permissions...
2015-09-07 18:38:59  Granting registry permissions...
2015-09-07 18:38:59  Configuring shares...
2015-09-07 18:38:59  Configuring network shares...
2015-09-07 18:38:59  Fetching content directory...
2015-09-07 18:38:59  Fetching ContentDir from registry store
2015-09-07 18:38:59  Value is D:\WSUSDB
2015-09-07 18:38:59  Fetching WSUS admin SID...
2015-09-07 18:38:59  Fetching WsusAdministratorsSid from registry store
2015-09-07 18:38:59  Value is S-1-5-21-510732343-3707520392-1156896604-1001
2015-09-07 18:38:59  Content directory is local, creating content shares...
2015-09-07 18:39:00  Creating share "UpdateServicesPackages" with path "D:\WSUSDB\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
2015-09-07 18:39:00  Deleting existing share...
2015-09-07 18:39:00  Creating share...
2015-09-07 18:39:00  Share successfully created
2015-09-07 18:39:00  Creating share "WsusContent" with path "D:\WSUSDB\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
2015-09-07 18:39:00  Deleting existing share...
2015-09-07 18:39:00  Creating share...
2015-09-07 18:39:00  Share successfully created
2015-09-07 18:39:00  Creating share "WSUSTemp" with path "C:\Program Files\Update Services\LogFiles\WSUSTemp" and description "A network share used by Local Publishing from a Remote WSUS Console Instance."
2015-09-07 18:39:00  Deleting existing share...
2015-09-07 18:39:00  Creating share...
2015-09-07 18:39:00  Share successfully created
2015-09-07 18:39:00  Finished creating content shares
2015-09-07 18:39:00  Stopping service WSUSService
2015-09-07 18:39:00  Stopping service W3SVC
2015-09-07 18:39:00  Configuring database...
2015-09-07 18:39:00  System.Net.Sockets.SocketException (0x80004005): No such host is known
   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.PostInstall.Run()
   at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)

============================================================

I remember when setting up the DB should be created automactically in the SQL DB (SUSDB) there not a need to manually create it. Appreciate that anyone can give me some pointers to resolving this issue

Thank & regards

Hi,

>>System.Net.Sockets.SocketException (0x80004005): No such host is known

According to the log, this error is caused by WSUS server can't find the database server.

Please try to use the following command to configure the WSUS database:

%programfiles%\update services\tools\wsusutil.exe postinstall CONTENT_DIR=C:\Wsus SQL_INSTANCE_NAME=<database server name>

For detailed information, please refer to the link below:

http://blogs.technet.com/b/reshard_sharps_blog/archive/2013/08/18/wsus-post-deployment-configuration-fails.aspx

Best Regards.