Deployment question Dave 5/16/2007 3:51:00 PM I am planning on setting up two WSUS 3.0 servers up both in the same domain. One will be an upstream and retrieve updates from the internet, while the other will be a downstream and recieve its updates from the upstream server. I will operate them in autonomous mode. Will it make a difference if one of or both of these servers use an SQL 2005 database as oposed to a local MSDE? Also I'm having trouble finding the documentation that explains how I need to set up the SQL connection and database. Can you guys give me a simple step by step or at least point me in the right direction? Thanks, Dave

Re: Deployment question "kj" <kj[ at ]nowhere.com> 5/17/2007 4:09:09 AM Dave wrote: [Quoted Text] > I am planning on setting up two WSUS 3.0 servers up both in the same > domain. One will be an upstream and retrieve updates from the > internet, while the other will be a downstream and recieve its > updates from the upstream server. I will operate them in autonomous > mode. Will it make a difference if one of or both of these servers > use an SQL 2005 database as oposed to a local MSDE? It will make many differences, but the context of this question isn't very clear to me. Do you mean will it make a difference to the operations of downstream / upstream WSUS servers or something else? >Also I'm having > trouble finding the documentation that explains how I need to set up > the SQL connection and database. Can you guys give me a simple step > by step or at least point me in the right direction? Start here for the DB setups; http://technet2.microsoft.com/windowsserver/en/library/6f51cae4-4b1e-4a4b-81ef-cc92dd3644fd1033.mspx?mfr=true > > Thanks, > Dave -- /kj

Re: Deployment question Dave 5/17/2007 12:45:01 PM Perhaps "difference" was not the right word. My question is will it matter if say the upstream server connects with a local MSDE database and the downstream server connects to a remote DB on an SQL 2005 server? Thanks, Dave "kj" wrote: [Quoted Text] > Dave wrote: > > I am planning on setting up two WSUS 3.0 servers up both in the same > > domain. One will be an upstream and retrieve updates from the > > internet, while the other will be a downstream and recieve its > > updates from the upstream server. I will operate them in autonomous > > mode. Will it make a difference if one of or both of these servers > > use an SQL 2005 database as oposed to a local MSDE? > > It will make many differences, but the context of this question isn't very > clear to me. Do you mean will it make a difference to the operations of > downstream / upstream WSUS servers or something else? > > >Also I'm having > > trouble finding the documentation that explains how I need to set up > > the SQL connection and database. Can you guys give me a simple step > > by step or at least point me in the right direction? > > Start here for the DB setups; > > http://technet2.microsoft.com/windowsserver/en/library/6f51cae4-4b1e-4a4b-81ef-cc92dd3644fd1033.mspx?mfr=true > > > > > Thanks, > > Dave > > -- > /kj > > >

Re: Deployment question "Cecils\(MSFT\)" <cecils[ at ]online.microsoft.com> 5/17/2007 4:41:22 PM No difference at all, as long as the WSUS servers can communicate with each other, and the correct permissions are set on the db's, then this should be transparent to the Administrator. Keep in mind that both the Upstream and the Downstream server cannot use the same remote SQL database. -- Cecil [MSFT] Deployment, WSUS Microsoft This posting is provided "As Is" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "Dave" <Dave[ at ]discussions.microsoft.com> wrote in message news:FC23C2FC-1DB4-48B5-922F-CB9E7864F207[ at ]microsoft.com... [Quoted Text] > Perhaps "difference" was not the right word. My question is will it > matter > if say the upstream server connects with a local MSDE database and the > downstream server connects to a remote DB on an SQL 2005 server? > > Thanks, > Dave > > "kj" wrote: > >> Dave wrote: >> > I am planning on setting up two WSUS 3.0 servers up both in the same >> > domain. One will be an upstream and retrieve updates from the >> > internet, while the other will be a downstream and recieve its >> > updates from the upstream server. I will operate them in autonomous >> > mode. Will it make a difference if one of or both of these servers >> > use an SQL 2005 database as oposed to a local MSDE? >> >> It will make many differences, but the context of this question isn't >> very >> clear to me. Do you mean will it make a difference to the operations of >> downstream / upstream WSUS servers or something else? >> >> >Also I'm having >> > trouble finding the documentation that explains how I need to set up >> > the SQL connection and database. Can you guys give me a simple step >> > by step or at least point me in the right direction? >> >> Start here for the DB setups; >> >> http://technet2.microsoft.com/windowsserver/en/library/6f51cae4-4b1e-4a4b-81ef-cc92dd3644fd1033.mspx?mfr=true >> >> > >> > Thanks, >> > Dave >> >> -- >> /kj >> >> >>

Re: Deployment question Dave 5/17/2007 5:01:00 PM Thanks Cecils. I found the rest of my answers for setting up the SQL 2005 DB in Apendix B of the deployment guide. "Cecils(MSFT)" wrote: [Quoted Text] > No difference at all, as long as the WSUS servers can communicate with each > other, and the correct permissions are set on the db's, then this should be > transparent to the Administrator. Keep in mind that both the Upstream and > the Downstream server cannot use the same remote SQL database. > > -- > Cecil [MSFT] > Deployment, WSUS > Microsoft > > This posting is provided "As Is" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm > > "Dave" <Dave[ at ]discussions.microsoft.com> wrote in message > news:FC23C2FC-1DB4-48B5-922F-CB9E7864F207[ at ]microsoft.com... > > Perhaps "difference" was not the right word. My question is will it > > matter > > if say the upstream server connects with a local MSDE database and the > > downstream server connects to a remote DB on an SQL 2005 server? > > > > Thanks, > > Dave > > > > "kj" wrote: > > > >> Dave wrote: > >> > I am planning on setting up two WSUS 3.0 servers up both in the same > >> > domain. One will be an upstream and retrieve updates from the > >> > internet, while the other will be a downstream and recieve its > >> > updates from the upstream server. I will operate them in autonomous > >> > mode. Will it make a difference if one of or both of these servers > >> > use an SQL 2005 database as oposed to a local MSDE? > >> > >> It will make many differences, but the context of this question isn't > >> very > >> clear to me. Do you mean will it make a difference to the operations of > >> downstream / upstream WSUS servers or something else? > >> > >> >Also I'm having > >> > trouble finding the documentation that explains how I need to set up > >> > the SQL connection and database. Can you guys give me a simple step > >> > by step or at least point me in the right direction? > >> > >> Start here for the DB setups; > >> > >> http://technet2.microsoft.com/windowsserver/en/library/6f51cae4-4b1e-4a4b-81ef-cc92dd3644fd1033.mspx?mfr=true > >> > >> > > >> > Thanks, > >> > Dave > >> > >> -- > >> /kj > >> > >> > >> > >

Re: Deployment question "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 5/21/2007 12:52:01 AM "Dave" <Dave[ at ]discussions.microsoft.com> wrote in message news:FC23C2FC-1DB4-48B5-922F-CB9E7864F207[ at ]microsoft.com... [Quoted Text] > Perhaps "difference" was not the right word. My question is will it > matter > if say the upstream server connects with a local MSDE database and the > downstream server connects to a remote DB on an SQL 2005 server? Dave, my critical question to this statement would be *WHY* do you wish to do this. What is the *business* reason for setting up an upstream server on a local database, and a downstream server as a FE/BE configuration? Why not simply set up ONE server farm with a single FE/BE configuration. Better yet, let's be sure your deployment scenario even requires a FE/BE configuration! It may be feasible that you can serve your needs with one (or two) servers using only the WMSDE native to WSUS. Also, keep in mind that using a FE/BE configuration *requires* that every client using that FE server has a SQL CAL. Unless you already have those, that's a signficant deployment expense, and rarely necessary. -- 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 .....