THE OFFICIAL BLOG OF THE SBS "DIVA"

So we're down to the home stretch in the migration of SBS 2003 to SBS 2008...

• Enable folder redirection on the Destination Server
• Migrate SQL Server data
• Migrate Terminal Service licensing server

Before we uninstall Exchange, there's three categories left....

First off I don't do folder redirection.  Why?  Because we train folks to store important stuff on the server.  So I don't feel that folder redirection is of value to my firm.

Next SQL server data.  This one can be the fun one.  When you order premium you get the option of installing SQL 2005 or SQL 2008 (at least it's guaranteed to have that media through December 2009 (1)

If you want it on the SBS main box follow a couple of blog posts and remember a few rules:

The Official SBS Blog : Error While Installing SQL 2005 Express on SBS 2008:
http://blogs.technet.com/sbs/archive/2009/06/11/error-while-installing-sql-2005-express-on-sbs-2008.aspx

The Official SBS Blog : Requirements for Installing SQL 2008 Standard Edition for Small Business:
http://blogs.technet.com/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx

Can I install SQL Server 2008 from Windows Small Business Server 2008 Premium Edition on the first server?   Yes, this is a supported scenario. However the SQL Server 2008 management tools will not install on the same server; you must install them on another server  (or use the express tools)

Do not migrate the instance of SQL Server 2005 Express that is installed on the Source Server for monitoring (SBSMONITORING), because this is not supported.

·      Do not migrate the instance of Windows Internal Database (SQL Server 2005 Embedded Edition) that is installed for Windows Server Update Services and for Windows SharePoint Services (MICROSOFT##SSEE), because this is not supported.

Finally on the Migrate Terminal Service licensing server, I think I already have that covered as I stood up a Win2k8 box and enabled the TS licnesing on it already.

By default, RWW in Windows SBS 2008 does not automatically display the terminal server on your network. Because of this, users do not see the terminal server when they connect using RWW. You must configure Windows SBS 2008 to display the terminal server in RWW. For more information, see “To add a Terminal Services server in Application mode to the Select Computer drop-down list in Remote Web Workplace” in the “Advanced Settings” section in Managing Windows Small Business Server 2008 Remote Web Workplace at the Microsoft Web site (http://go.microsoft.com/fwlink/?LinkID=131600). 

[I have no idea what link they mean but the real link is http://technet.microsoft.com/en-us/library/cc527532(WS.10).aspx under Advanced Settings.]

To change the server time-out setting for Remote Web Workplace

1. On the Windows SBS 2008 server, click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.

2. At the User Account Control prompt, click Continue.

3. In the left pane, double-click the name of the server to expand the tree.

4. Double-click Sites to expand it, and then double-click SBS Web Applications to expand it.

5. In SBS Web Applications Home, double-click Session State.

6. In Cookie Settings, change the Time-out (in minutes) to the desired amount of time.

7. Click Apply to save the changes.

8. 

To change the client time-out setting for Remote Web Workplace

1. Open Registry Editor.

2. Open the following registry key:

   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\RemoteUserPortal\PublicTimeOut

3. In the Value data box, type the number of minutes that you want to elapse before the Remote Web Workplace session times out.

   Important
   The value you enter should not be larger than 1440. Otherwise, Connect to a computer and Connect to a server will not function properly.

4. Click OK.

On this one you'll scratch your head.  Because there is no RemoteUserPortal key 

It's in the next section down that they tell you to ADD the key.  Duh.

Add the key

To add a Terminal Services server in Application mode to the Select Computer drop-down list in Remote Web Workplace

1. Open Registry Editor.

2. Open the following registry key:

   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\RemoteUserPortal

   Note
   If the RemoteUserPortal key does not exist, create it.

3. Create the following multi-string (REG_MULTI_SZ) key:

   TsServerNames

4. Type the name of your terminal services server. Type one name per line.

   Verify that the name is exactly the same as the server. If a server key already exists, modify its value. If the type isn’t correct, remove it first, and then recreate it.

5. Click OK.

6. 

Type in the TS server name

To create a new registry key that shows all computers

1. Open Registry Editor. To do this, click Start, in the search field type regedit, and then press ENTER.

2. In the User Account Control window, click Continue.

3. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer.

4. Right-click SmallBusinessServer, click New, and then click Key.

5. Name the key BusinessProductivity.

6. Right-click BusinessProductivity, click New, and then click DWORD (32-bit) Value.

7. Name the new value ShowAllComputers.

8. Double-click ShowAllComputers, and then, in the Value data text box, type 1.

9. Click OK, and then close Registry Editor.

(1) SBS 2008 Premium Edition comes with SQL Server 2008 Standard Edition for Small Business. Can I exercise my downgrade rights and run an earlier version of SQL Server?

A.  
No. Components of the SBS solution cannot be separated. However, Microsoft recognizes that line-of-business applications may experience compatibility issues moving from one version to the next, so till 12/31/2009, we will ship SQL Server 2005 Standard (both 32 and 64-bit platforms) in addition to the SQL Server 2008 Standard for Small Business for the customer’s use in order to address these potential issues.

Note that once we stop shipping both versions of SQL Server, customers are restricted from downgrading just the SQL Server component. Our downgrade rights specify that if you downgrade, you must downgrade all the component parts of the server software. However, the customers who received SQL Server 2005 Standard with their SBS 2008 Premium can continue to use it after the shipping period ends, but they may not use both SQL Server 2005 Standard and SQL Server 2008 Standard for Small Business simultaneously. Customers can, however, move between SQL Server 2005 Standard and SQL Server 2008 Standard for Small Business per their needs