Hello there folks – I am the publisher of the above title and I like to hold virtual book readings! So here goes – installing the SBS 2003 Premium components to pass the 70-282 exam.
Small Business Server Component Installation (Premium Edition)
ISA Server 2000 and SQL Server 2000 and Microsoft FrontPage are included in the Premium Edition of Windows Small Business Server 2003, but do not get installed as part of the core SBS setup. In effect, you install the premium components after completing the SBS 2003 Standard Edition deployment steps. First, follow the install steps for the SBS 2003 Standard Edition. After having a successful SBS install, you can then insert the Windows Small Business Server Disc 5 CD-ROM (Premium Disc) and a new install splash screen will launch, prompting you to install the premium components.
IMPORTANT: The exam is based on Small Business Server 2003 prior to Service Pack 1 (SP1). Service Pack 1 included:
· SP1 for Windows Server 2003.
· SP1 for Exchange Server 2003.
· SP1 for Windows SharePoint Services 2.0.
· SP 4 for WMSDE.
· SP 4 for MSDE.
· SP4 for SQL 2000.
· ISA Server 2004 with SP1.
· Stop! You don’t need to know any of this stuff!
This is the part that lends itself to much confusion about which parts
are covered on the exam and which are not. Having said that, you
will NOT be tested on service pack levels or version details and if
SQL server or ISA server are mentioned on the exam, it will be part of a generic narrative story, and you are not being tested on reporting services or proxy clients!
Installing SQL Server 2005 WorkGroup Edition/ SQL 2000 with SP3a
Now, having said that you will not be tested on SQL components directly – when the exam team re-crafted the exam in late 2006, (they did go through the trouble of updating certain items and you may encounter a question on SQL 2005) – be aware; when you see such a question I can tell you that the solution will be indifferent to the version of the application mentioned. Microsoft exam questions in this case are built to be version-neutral. You can worry about version next time when you are taking an exam on SQL, CRM or Exchange straightforwardly.
This has led to several discussions among the authors on how this subject should be approached. After reviewing the installation steps of SQL 2000 with SP3a and SQL 2005 WorkGroup Edition, we find that the installation part is initiated the same in both instances, using the setup bootstrapper presented on the Small Business Server Premium Technologies Setup screen. From there you continue through the default screens, adding company information and license code (if requested). On the Setup screen, select your preference if you want to install the:
· Default Instance (created a new instance of a database).
· Named Instance (updates named instance to SQL 2005).
You would choose Default Instance, because you are installing a new instance of a database. By selecting a Named Instance you would end up upgrading, for example, an existing MSDE database, like MSSQL$SBSMONITORING, which is not supported. The setup screens do differ in both versions but basically you still get to make choices on whether to use the:
· Built-in system account:
Chapter 5 Installing Windows Small Business Server 2003
· Domain user account:
This will determine the account to be used as the log in for the Service account, which launches the SQL Server service. A rule of thumb here is to have a previously created Service account that doesn’t belong to a domain user at all, but is set up just for the purpose of launching different services; this way a service doesn’t stop working unexpectedly if a domain user changes his or her password.
The Authentication Mode specifies the security used when connecting to SQL Server, you can select:
· Windows Authentication Mode.
· Mixed Mode (SQL Server Authentication and Windows Authentication).
A rule of thumb here is that using a separate SQL administrator account is more secure. After a couple more screens, SQL will start to copy files. Then click Finish. For SQL 2000 you would go back to the Premium Technologies CD install screen and install Service Pack 3a for SQL.
After the installation (regardless of the version#) there are certain points to consider:
· Do not upgrade the instance of MSDE that is installed for Monitoring (MSSQL$SBSMONITORING), because it is not supported.
In the case of SQL 2005 you would also have the MSDE instance for Windows Server Update Services (WSUS). (Attention: this would occur in SBS R2 only.)
· Do not upgrade the instance of MSDE that is installed for Update Services (MSSQL$WSUS), because it is not supported.
Now, hear me out. The oddity is that the exam does not feature the latest version of WSUS, hence the confusion, because if you see SQL 2005 on an “SBS” exam you would automatically assume this exam is based on the SBS R2 version. (You know what the word “assume” really makes of you and me if you break it apart, don’t you?)
So having bewildered and befuddled you at this point (at least I have done my job!), let me reiterate that the solution will be indifferent to the version of the application of the exam question. You will be tested on your general knowledge and your wits, because if you don’t pay attention to detail and let a word like SQL 2005, CRM 3.0 or ISA 2008 throw you off, the exam writers got the best of you!
IMPORTANT: I’m not proud of having to break it to you in this way. At least you will now be familiar with the “bewildered and befuddled” feeling you may encounter during the exam. If this is the case and you encounter an oddity such as this (where you mistakenly peg real world against exam question), remember what was said here. This is not new. Thinking back to the very first NT exam, which had replication questions (remember those PDCs and BDCs?) on it, there was an odd “reality check” moment, because replication didn’t work in real life until Service Pack 1 was released!
Harry Brelsford, CEO at SMB Nation (www.smbnation.com)
MBA, MCSE, CNE, CLSE, CNP, MCP, MCT, SBSC (Microsoft Small Business Specialist)
PS – did you know my Windows Small Business Server 2008 (SBS 2008) book is almost here? Yes!