WSUS 3.0 on SQL 2005 and SBS 2003 R2
|
Prev: Import-Mailbox cmdlet
Next: Exchange Activesync
From: Daniel Jewel on 19 Feb 2010 12:37 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. Thanks, Dan
From: Milhouse Van Houten on 19 Feb 2010 16:42 "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
From: Daniel Jewel on 21 Feb 2010 18:28 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
From: Milhouse Van Houten on 21 Feb 2010 22:40 I see. I thought you just meant in the default SQL instance, as opposed to MSDE or WID. I'm curious: why would you want to do that? Is there some advantage to it? In our case, it and several other things are all in the default instance. "Daniel Jewel" <cyberdudeiq(a)yahoo.com.br> wrote in message news:e3I6W20sKHA.3904(a)TK2MSFTNGP02.phx.gbl... > 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 >
From: Leonid S. Knyshov // SBS Expert on 22 Feb 2010 03:58
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 > > . > |