locked
Two Domains, WSUS Downstream Server and Database RRS feed

  • Question

  • Hi,

    we have two domains.

    - We would like deploy on "Domain A" an upstream server (UPSERVER). In "Domain B" will include only a downstream server (DOWNSERVER).

    - Only UPSERVER download all updates from Microsoft Windows Updates Servers.

    - UPSERVER has a dedicated SQL server.

    - DOWNSERVER should only download all updates, etc. from UPSERVER.

    - DOWNSERVER is NO replica server.

    We don't want to use WID database for DOWNSERVER. Can DOWNSERVER use the same dedicated SQL instance and database from UPSERVER?

    If yes, is it enough to have the open SQL TCP/1433 on WSUS database server? Or are another ports for SQL access necessary?

    Best regards

    Birdal

    Thursday, June 27, 2019 3:42 PM

All replies

  • We don't want to use WID database for DOWNSERVER. Can DOWNSERVER use the same dedicated SQL instance and database from UPSERVER?

    I think this is hard to achieve.
    For reference, the official article mentions the following information:
      

    • WSUS requires a database for each WSUS server. 
    • If you install multiple WSUS servers, you must maintain a separate database for each WSUS server, whether it is an autonomous or a replica server.
    • You cannot store multiple WSUS databases on a single instance of SQL Server, except in Network Load Balancing (NLB) clusters that use SQL Server failover.
        

    Hope the above can help you.
      

    Regards,
    Yic

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

    Friday, June 28, 2019 1:56 AM
  • Hi Yic,

    can you please link this documentation, please?

    Best regards

    Birdal

    Monday, July 1, 2019 8:00 AM
  • Hi,

    because of both server in different domain, we get following error during we try to install WSUS downstream server (DOWNSERVER), and try to connect to database server (DBSERVER) in the other domain:

    SQL Server (DBSERVER) is deployed to use authentication in mixed mode.

    Any solution?

    Best regards

    Birdal



    • Edited by _Birdal Wednesday, July 3, 2019 11:14 AM
    Wednesday, July 3, 2019 11:13 AM