none
WindowsServer2016 部署WSUS连接不上内部数据库 RRS feed

  • 问题

  • 尝试:1、按照官网卸载干净,然后重装WSUS不行

             2、重启服务器也不行

             3、打过补丁也未解决

             4、使用SQL Server 2019 Installation Center 连接WID数据库也连接不上

    下面安装完WSUS后,随后打不开WSUS服务的日志!!!

    2020-11-20 17:36:14  Postinstall started
    2020-11-20 17:36:14  Detected role services: Api, UI, WidDatabase, Services
    2020-11-20 17:36:14  Start: LoadSettingsFromParameters
    2020-11-20 17:36:14  Content local is: False
    2020-11-20 17:36:14  SQL instname is: 
    2020-11-20 17:36:14  End: LoadSettingsFromParameters
    2020-11-20 17:36:14  Start: Run
    2020-11-20 17:36:14  Fetching WsusAdministratorsSid from registry store
    2020-11-20 17:36:14  Value is S-1-5-21-628197725-2450586543-2496963177-1000
    2020-11-20 17:36:14  Fetching WsusReportersSid from registry store
    2020-11-20 17:36:14  Value is S-1-5-21-628197725-2450586543-2496963177-1001
    2020-11-20 17:36:14  Configuring content directory...
    2020-11-20 17:36:14  Configuring groups...
    2020-11-20 17:36:14  Starting group configuration for WSUS Administrators...
    2020-11-20 17:36:14  Found group in regsitry, attempting to use it...
    2020-11-20 17:36:14  Writing group to registry...
    2020-11-20 17:36:14  Finished group creation
    2020-11-20 17:36:14  Starting group configuration for WSUS Reporters...
    2020-11-20 17:36:14  Found group in regsitry, attempting to use it...
    2020-11-20 17:36:14  Writing group to registry...
    2020-11-20 17:36:14  Finished group creation
    2020-11-20 17:36:14  Configuring permissions...
    2020-11-20 17:36:14  Fetching content directory...
    2020-11-20 17:36:14  Fetching ContentDir from registry store
    2020-11-20 17:36:14  Value is D:\WSUS\UpdateServicesPackages
    2020-11-20 17:36:14  Fetching group SIDs...
    2020-11-20 17:36:14  Fetching WsusAdministratorsSid from registry store
    2020-11-20 17:36:14  Value is S-1-5-21-628197725-2450586543-2496963177-1000
    2020-11-20 17:36:14  Fetching WsusReportersSid from registry store
    2020-11-20 17:36:14  Value is S-1-5-21-628197725-2450586543-2496963177-1001
    2020-11-20 17:36:14  Creating group principals...
    2020-11-20 17:36:15  Granting directory permissions...
    2020-11-20 17:36:15  Granting permissions on content directory...
    2020-11-20 17:36:15  Granting registry permissions...
    2020-11-20 17:36:15  Granting registry permissions...
    2020-11-20 17:36:15  Granting registry permissions...
    2020-11-20 17:36:15  Configuring shares...
    2020-11-20 17:36:15  Configuring network shares...
    2020-11-20 17:36:15  Fetching content directory...
    2020-11-20 17:36:15  Fetching ContentDir from registry store
    2020-11-20 17:36:15  Value is D:\WSUS\UpdateServicesPackages
    2020-11-20 17:36:15  Fetching WSUS admin SID...
    2020-11-20 17:36:15  Fetching WsusAdministratorsSid from registry store
    2020-11-20 17:36:15  Value is S-1-5-21-628197725-2450586543-2496963177-1000
    2020-11-20 17:36:15  Content directory is local, creating content shares...
    2020-11-20 17:36:15  Creating share "UpdateServicesPackages" with path "D:\WSUS\UpdateServicesPackages\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2020-11-20 17:36:15  Deleting existing share...
    2020-11-20 17:36:15  Creating share...
    2020-11-20 17:36:15  Share successfully created
    2020-11-20 17:36:15  Creating share "WsusContent" with path "D:\WSUS\UpdateServicesPackages\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2020-11-20 17:36:15  Deleting existing share...
    2020-11-20 17:36:15  Creating share...
    2020-11-20 17:36:15  Share successfully created
    2020-11-20 17:36:15  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."
    2020-11-20 17:36:15  Deleting existing share...
    2020-11-20 17:36:15  Creating share...
    2020-11-20 17:36:15  Share successfully created
    2020-11-20 17:36:15  Finished creating content shares
    2020-11-20 17:36:15  Stopping service WSUSService
    2020-11-20 17:36:15  Stopping service W3SVC
    2020-11-20 17:36:15  Configuring WID database...
    2020-11-20 17:36:15  Configuring the database...
    2020-11-20 17:36:15  Establishing DB connection...
    2020-11-20 17:36:15  Clearing Connection Pools
    2020-11-20 17:36:15  System.Data.SqlClient.SqlException (0x80131904):  
       在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
       在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       在 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       在 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       在 System.Data.SqlClient.SqlConnection.Open()
       在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect(String connectionString)
       在 Microsoft.UpdateServices.Administration.ConfigureDB.CreateDBConnection()
       在 Microsoft.UpdateServices.Administration.ConfigureDB.ConnectToDB()
       在 Microsoft.UpdateServices.Administration.ConfigureDB.Configure()
       在 Microsoft.UpdateServices.Administration.ConfigureDB.Run(String instanceName, Action`1 logWriter, Boolean contentLocal)
       在 Microsoft.UpdateServices.Administration.PostInstall.Run()
       在 Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)
    ClientConnectionId:a2d796b6-ce7f-45c2-bb51-4cc7b00a01a9
    Error Number:18452,State:1,Class:14

    4、使用SQL Server 2019 Installation Center 连接WID数据库也连接不上的日志如下:

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

      (.Net SqlClient Data Provider)

    ------------------------------
    有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476

    ------------------------------
    服务器名称: \\.\pipe\MICROSOFT##WID\tsql\query
    错误号: 18452
    严重性: 14
    状态: 1
    行号: 65536


    ------------------------------
    程序位置:

       在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
       在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       在 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       在 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       在 System.Data.SqlClient.SqlConnection.Open()
       在 Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
       在 Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

    2020年11月27日 8:48

全部回复

  • 你好,
     
    感谢你到此论坛上贴。
     
    根据你提供的信息,我检查到此报错:
    System.Data.SqlClient.SqlException (0x80131904) 我检查到相似的case,似乎是你的环境中WID数据库没有清理完全导致的。这边建议你考虑参考以下链接中的步骤来进行完全清除WSUS。

    https://community.spiceworks.com/topic/2281976-reinstall-wsus-role
     
    清除 WSUS之后,请考虑重新安装WSUS role。如果关于此问题有任何跟进,请及时与我联系。
     
    诚挚问候,
    Rita


    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    2020年11月30日 8:10
  • 你好,

    请问当前的case进展如何?还有什么我可以帮助您的吗?如果关于此问题有任何跟进,请及时与我联系。

    如果此问题已解决,请标记回复以帮助有相同问题的人。

    感谢你的时间。祝您生活愉快。

    诚挚问候,

    Rita



    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    2020年12月2日 7:53
  • 您好,按照您发的重新卸载了WID 安装后还是不行,安装完启动任务失败

    之前有输出的日志,现在输出的日志为空

    唯一的日志:事件查看器-windowsserver更新服务器-事件ID 507

    安装完后WID数据库目录下只剩一个文件:C:\windows\Binn\SUSDBVerify.dll 其他任何文件都没有

    原谅我不能发截图和链接(我的账户没有认证)

    请问这种情况我该怎么办?

    2020年12月8日 6:47
  • 你好,

     感谢你的回复。

     想跟你确认一下,你已经参考我提供的链接进行完全清除WSUS以后再重新安装还是失败,对吧?

    请问此问题还是出现在安装后任务吗?你是否检查WSUS服务器以下服务是否正常运行:



    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    2020年12月10日 1:47
  • 您好!

    对,此问题是出现在安装后任务

    检查

    1、Windows internal Database                       这个服务没有

    2、WSUS Service                                          这个服务是“禁用”状态

    3、Background Intelligent Transfer Service      这个服务是“自动”“启动”状态

    请问这种我该如何操作?谢谢您

    2020年12月15日 11:22