WSUS 3.0 on SQL 2005 and SBS 2003 R2
|
Prev: Import-Mailbox cmdlet
Next: Exchange Activesync
From: Daniel Jewel on 1 Mar 2010 08:15 Thank you Leonid, That did the trick and I was able to install WSUS 3.0 on its own instance of SQL 2005. I now need to get it to recognize the computers on the network and effectively download and distribute the updates. Thank you, Dan "Leonid S. Knyshov // SBS Expert" <LeonidSKnyshovSBSExpert(a)discussions.microsoft.com> wrote in message news:4AF621B6-FEDA-4A9C-A87E-564999F32311(a)microsoft.com... > Generally, a new SQL instance is created by running the setup tool for SQL > Server. Each time you complete the process, a new instance is born. > > You may find this article to be of interest as it also addresses what to > do > with existing instances: > http://download.microsoft.com/download/4/0/8/40860507-c351-4308-a876-e1b83ee4e77a/sqlinstallsteps.htm > > I normally use SQL Server Express for my instances. You can manage them > with > SQL Management Studio Express, which is a downloadable product. > > From disaster preparedness perspective, please keep SQL transaction logs > on > a separate array. This can be adjusted after the system is setup. > -- > Leonid S. Knyshov > Crashproof Solutions > 510-282-1008 > Twitter: @wiseleo > http://crashproofsolutions.com > Microsoft Small Business Specialist > Please vote "helpful" if I helped you :) > > > "Daniel Jewel" wrote: > >> Thank you for your time in replying... but this isn't quite what I need. >> >> I want to install WSUS 3.0 on its own WSUS instance using SQL 2005. And I >> just cannot get clear info on how to create/prepare an INSTANCE called >> WSUS >> so I can connect to it during installation. >> >> Dan >> >> "Milhouse Van Houten" <btvs(a)myrealbox.com> wrote in message >> news:uzXoZxasKHA.5940(a)TK2MSFTNGP02.phx.gbl... >> > "Daniel Jewel" <cyberdudeiq(a)yahoo.com.br> wrote in message >> > news:eLeT#pYsKHA.4360(a)TK2MSFTNGP05.phx.gbl... >> >> Hello all, >> >> >> >> did some searching on a new situation but did not find specific >> >> info... >> >> >> >> SBS 2003 R2 Premium, ISA installed 2 NICs all patched up... Original >> >> installation did not include WSUS 2.0 , we now want to install WSUS >> >> 3.0 >> >> on the SBS Server but want it to be on SQL Server 2005. >> >> >> >> How do I create an instance in SQL to prepare it for WSUS 3.0 >> >> installation? I also need the DB to be placed on another >> >> Drive/Partition >> >> if possible. >> > >> > You can opt for SQL during installation. You can also specify a >> > different >> > drive for updates storage. >> > http://technet.microsoft.com/en-us/library/cc720469(WS.10).aspx >> > >> > There are some particular things you need to know when installing on >> > SBS: >> > http://technet.microsoft.com/en-us/library/cc708091(WS.10).aspx >> > >> > Reading through the latest WSUS (3.0 SP2) release notes is a good idea, >> > too. >> > >> > There are various ways to move SQL dbs. Using your SQL Server >> > Management >> > Studio and Windows Explorer has worked well here. >> > http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/5c0e5ba5-1e1a-4c38-ac92-3e5c50ac6c7b >> >> . >> |