Tutorials

Specify Alternate Text

Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server

In a default SBS 2008 Premium setup you have two servers. One with SBS 2008 and another one with Windows 2008 Server installed. That additional server can be used for several purposes.

In this article we will install SQL 2008 on the member server and create an instance that will hold the Sharepoint content database.


Install SQL Server 2008 on the member server

SQL 2008 can be found on the 5th DVD. Start setup from the DVD.

  1. Setup will install several updates.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  2. Set is working...
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  3. Setup will install .Net Framework 3.5 SP1 first.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  4. Setup is working...
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  5. Setup has finished installing .Net Framework SP1.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  6. A hotfix needs to be installed before SQL 2008 can be installed.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  7. Setup is installing the hotfix.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  8. The server needs to be restarted. Click Restart Now to reboot your server.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  9. Choose to install a new SQL server standalone installation...
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  10. Set checks if there are problems that might occur during the installation. Click OK to continue.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  11. Enter your product key and click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  12. Accept the licensing terms and click next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  13. Click Install...
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  14. Setup is working...be patient!
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  15. There is one warning about the Windows Firewall. Click on the warning.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  16. We will look into this later if we make the final checks. Click OK
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  17. We are back in the previous Window and click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  18. Make sure you check the choices as in the screenshot below. Click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  19. We choose to create a new named instance called Sharepoint. Click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  20. A summary....click Next
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  21. I use the System account to start SQL Server Agent and Database Engine. Click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  22. You need to add at least one user who should have unrestricted access to the Database engine.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  23. Click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  24. No problems were found. Click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  25. Setup is ready install and presents you a list with features that will be installed.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  26. The installation runs...
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  27. Setup is complete. Click Next.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  28. We have successfully installed a new SQL server 2008 instance on our member server. Click Close.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  • Enable remote connections on the SQL Server that you want to connect to from a remote computer.
  • Change the listening port of the named instance.
  • Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser Service.
     

Additional configurations tasks on the member server

Before we can use the new SQL Server 2008 instance we need to:

Enable remote connections on the SQL Server that you want to connect to from a remote computer.
  1. You do this by using the SQL Server Configuration Manager. From the start Menu open SQL Server Configuration Manager.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  2. Highlight the Instance you want to use and set TCP/IP to enabled if is not already enabled. Restart the SQL Browser Service.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
Change the listening port of the named instance.

Named instances of the Database Engine and SQL Server Compact 3.5 are configured for dynamic ports. This means they select an available port when the SQL Server service is started. When you are connecting to a named instance through a firewall, configure the Database Engine to listen on a specific port, so that the appropriate port can be opened in the firewall.

  1. From within the SQL Server Configuration Manager right click the TCP/IP protocol name and choose Properties.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  2. Delete the value from TCP Dynamic ports and add '1433' to TCP Port. Remember that if you already have a Default SQL instance on your server that you cannot use port 1433. Click Apply.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  3. Click OK.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  4. Restart SQL Server and Server Browser.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser Service.

We can configure the Firewall in 3 different ways

  • Use the GUI from the standard Firewall
  • Use the MMC for the Advanced Firewall
  • Or use the command prompt with 'netsh'.

I will show you the way I have done this with 'netsh'.

  1. Open a command prompt and make sure you run it as administrator.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  2. In the text box below you see that I run 3 times a netsh advfirewall command that adds 3 rules to our firewall. You can copy and paste the commands from this text box and use it on your own server.
C:\Windows\system32>netsh advfirewall firewall add rule name = "SQL Server" dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

Ok. 

C:\Windows\system32>netsh advfirewall firewall add rule name = "SQL Admin" dir = in protocol = tcp action = allow localport = 1434 remoteip = localsubnet profile = DOMAIN

Ok. 

C:\Windows\system32>netsh advfirewall firewall add rule name = "SQL Browser" dir = in protocol = udp action = allow localport = 1434 remoteip = localsubnet profile = DOMAIN 

Ok.

The result of these commands can be found in the Avancanced Firewall MMC.

  1. From the start menu open the Windows Firewall with Advanced Security.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  2. Eureka! There are our rules
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server

SharePoint Services content database move process

Before we continue there are some things you need to know. If the destination SQL Server is not on the Windows SBS 2008 server, you might encounter issues when you use the SharePoint 3.0 Central Administrator to add the new content database. There for we need to use 'stsadm' to move the reference to the database. After you move the content database to SQL Server, you are no longer able to use the Move Windows SharePoint Services Data task from the Windows SBS Console (Server Storage, which is located on the Backup and Server Storage tab). This is because the task can only move data for the Windows internal database.

Prepare your internal Web site
  1. Make sure you disable the Internal Website so that other users cannot use it during the migration. Open the Windows SBS Console and highlight the Internal Web site and click 'Disable this site'.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  2. Start the SharePoint 3.0 Central Administration from administrative tools.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  3. In the Central Administration page, click the Application Management tab
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  4. In the SharePoint Web Application Management section, click Content databases.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  5. On the Manage Content Databases page, click the content database that you want to move (ShareWebDB).
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  6. On the Manage Content Database Settings page, in the Remove Content Database section, select Remove content database, and then click OK.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  7. Click OK.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  8. There are no content databases listed anymore.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
Now we have to detach the databases from the Windows internal database.

Because I upgraded my SQL client tools on my SBS 2008 to SQL 2008 the screenshots may look a little different to the SQL Server Management Studio Express that are by default installed on a SBS 2008 but the idea is the same.

  1. Right click SQL Server Management Studio from the Start menu and choose 'Run as administrator'. If you don't do this you will not be able to login the Windows Internal database.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  2. In the Connect to Server dialog box, under Server type, select Database Engine, and then in the Name field, type \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  3. Click Databases to expand the list, and then click ShareWebDb. Right-click the database name, click Tasks, and then click Detach.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  4. Detach the database by clicking OK
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  5. Our database has been detached.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  6. Copy or move the ShareWebDb.mdf and ShareWebDb_log.ldf files from C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data to a destination folder on the member server.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  7. I have copied them to my SQL Sharepoint instance data folder on the member server
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  8. On the destination server, attach the content database to the SharePoint instance. Click Microsoft SQL Server 2005 or Microsoft SQL Server 2008, right-click SQL Server Management Studio, and then click Run as administrator.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  9. Connect to the Sharepoint instance. Click Connect.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  10. Right click the node Database and choose Attach.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  11. Click Add.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  12. Browse to the location where you moved the database to and highlight it. Choose OK.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  13. Click OK. For now we ignore the note about the Full text catalog.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  14. Yes, there is our database listed.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server
  15. Our last step is to tell Sharepoint that our databases are located on the member server. This is done by stsadm. Open a command prompt and browse to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN. Remember that you need to change -databaseserver [memberserver\sharepoint] to your own specific situation.
    Note: In many manuals found on the internet including Microsoft Technet they tell you to use -url https://sites.987. That does not work. You must use http://companyweb as show in the box below.
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsadm -o addcontentdb -url http://companyweb -databaseserver memberserver\sharepoint -databasename ShareWebDb Operation completed successfully.
  1. We need to enable the companyweb before we can use it.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server

  2. Now that everything is ready browse to http://companyweb to see if it works... Remember your data is now on the member server is because of this it is no longer included in the backup you run on the SBS.
    Move the SBS 2008 SharePoint Services content database to a Windows 2008 member server

About www.server-essentials.com 

www.server-essentials.com is founded by Mariette Knap, a Dutch Microsoft MVP. www.server-essentials.com is a community for IT Consultants and Business Owners who, themselves, take care of the IT infrastructure and Employees who do that little extra in the company to keep things running. Our forum is for discussing all things ‘IT’ and more.  Our documentation is top notch and written by and for the community.

Change your cookie settings


 
Contact Us
(030) 2250455

International: +31302250455

 

Concentrix BV

C. de Rijcklaan 1

3723 PM Bilthoven

The Netherlands

KvK 30202318

VAT Id 814036739B01

This page is intended to be viewed online and may not be printed. You are not allowed to save or print any documentation on www.server-essentials.com. If you save documentation locally or distribute it you are violating the Terms of Service of this website you agreed on when registering an account. You have access to the documentation as long as you have a valid subscription. If you try to download our documentation we will drop Javascript which makes it possible for us to track you.