WSUS 3 Remote SQL Installation James Doyle 5/30/2007 3:20:02 PM Hi there, anyone have advice on the following? So far we've done: Clean Install of WSUS 3 run with remote 2005 SQL database command line WSUSSetup.exe SQLINSTANCE_NAME=servername\instancename All fine, works a treat. If I now want to add in a second WSUS replica server at another site, when I run the install do I a - install as per standalone server (but then it'll presumably create an SQL Express 2005 database locally) b - install as above remote install pointing at the same SQL database. NB The SQL server is not part of a cluster.

Re: WSUS 3 Remote SQL Installation "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 5/30/2007 4:45:32 PM "James Doyle" <James Doyle[ at ]discussions.microsoft.com> wrote in message news:E9B4C53E-F410-41BC-9DAC-93907F454426[ at ]microsoft.com... [Quoted Text] > b - install as above remote install pointing at the same SQL database. > NB The SQL server is not part of a cluster. That's your core challenge, James. Every WSUS front-end server must have its own dedicated back-end database. For a replica server, unless it's a particularly large site (> 1,000 clients), I'd recommend installing the replica with the Windows Internal Database. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....