The official blog for Windows Server Essentials and Small Business Server support and product group communications.
[Today's post comes to us courtesy of Shawn Sullivan from Commercial Technical Support]
In Part One of this series we discussed how to upgrade the preinstalled instance of Sharepoint on the SBS 2011 server to SQL 2008 R2 Standard in order to migrate a larger content database. This particular post is targeted to those who are instead planning to use the second Windows 2008 R2 server they are licensed for in SBS 2011 Premium to hold their Sharepoint content database. It will deal with installing the instance and configuring network settings. For the sake of keeping these posts as short as possible, Part 3 will be an extension of this post and will give the final steps for migrating the content database to the second server. This method is a bit more involved than the one described in the first post. The important points here are:
Since this is a named instance, it will be configured by default to listen on a dynamic port for network connections. You will have to change this use the static port 1433 in order for the Sharepoint web application running on the SBS 2011 server to access it. To do this, follow the steps in http://msdn.microsoft.com/en-us/library/ms177440.aspx
If you are running Windows Firewall you will have to make an exception for SQL traffic. The simplest way to do this is to add a program exception for the executable file. Do to this:
At this point the instance is ready for the migrated database. We will cover this in Part Three.