How to Add the Premium Add-On Server to a SBS 2011 Domain - SQL Role
The Add on premium server provides the ability to provide additional flexibility to your SBS 2011 domain. The Windows Server 2008 R2 can be the base OS for a
Hyper-V deployment and then can be used as the line of business deployment server. It can also be used for a base for a line of
business SQL Server.
If you have any issues installing SQL Server, keep in mind a key element is that it must see the SBS domain. Thus make sure you are logged in as a SBS domain administrator when installing the software.
This past blog post, while based on SBS
2008 covers the same issues you'll face in SBS 2011.
This step by step is based on
http://demoshowcasesuite.com/demos/37cb96dd-b729-44f5-84c9-1360be5b18cb and you can run through a
hands on lab of this as well.
Downloading the software.
Download the Premium add on from the MVLS site.
Click on the Windows Small Business Server Premium Add-on 2011, and then choose the 64bit download to download the Windows Server 2008 R2
To download the SQL server 2008 r2 for small business choose the 32/64 bit version.
Once you’ve downloaded the media you can install the member server. It will install as a workgroup server. To join it to the domain you must manually join it. Ensure that
it is obtaining it’s IP address from the SBS 2011 server.
Manually join the server to the domain
The wizard that one normally runs to join a computer to the domain does not work to join a server to the domain. Thus don’t even attempt to run
on a server as it will indicate it’s not a supported operating system. On the initial configuration tasks screen, click on provide computer name and domain.
On the system properties screen that comes up, click on change to enter the domain and renaming tab.
Rename the member server to make it descriptive based on your normal naming schema.
Click Domain, and then enter the domain name of the network.
If the server cannot find the domain you may need to enter a static IP and point the DNS to the SBS 2011.
You will be prompted for a domain administrator account in order to join the domain.
You will be then joined to the domain.
You need to reboot the server to finish joining the domain.
The server will be rebooted.
The server will reboot with the non domain user account setting.
To log in as a domain, click on Switch User.
Click on Other User.
Enter the domain username and password.
Click on the blue arrow key to enter the domain.
The member server is now joined to the domain.
Move the server into the right Organizational Unit.
The next step that has to be done for SBS 2011 STANDARD servers only - is to move the server from the client organizational unit to the Sever organizational unit. If you
do not do this you will be unable to successfully add roles to the server. Go back to the SBS 2011 server and check the console and then on the network tab.
You’ll notice that the Premium server is listed in the client computer category.
For SBS Essentials this step is not necessary.
This is due to the fact that when a server is joined to the SBS network, it’s placed in the SBS computers OU. You’ll want to move it to the
SBSServers OU. If you do not you cannot install the TS/RDS role.
Click start, administrative tools, then on
Active Directory Users and Computers (ADUC) console.
In ADUC, expand the domain to
navigate to the
SBSComputers OU which is under the domain, then under
MyBusiness, then under Computers.
Find the premium member server listed and right mouse click, hold and drag it to the
SBSServers Organizational Unit.
Yes when you are prompted to confirm the move.
Go back to the console and confirm that the server is now listed as a server. You may need to click “refresh this view” to refresh it.
You’ll notice that the server is now listed in the Server section.
Installing SQL server 2008 R2 for Small Business.
Click next to begin the install
Choose only those features you need. Again, check with the vendor on this.
Click Next to begin the install.
A test will be made and any errors noted.
If all is clear, click Next.
At this screen name the sql instance or choose the default - again check with the vendor:
Click next to continue
Review the drive space and click next
Set up appropriate SQL accounts - again check with the vendor
If the SQL needs a SA account ask the vendor if they can use windows authentication - but in general check with the vendor in the setup of SQL
Check what account they need for analysis services
Decide if you want to send error reports to Microsoft
It will check for install problems, click next
And we're ready to go, click Install
SQL will now install:
And then it will successfully complete:
I have a question on this: I have sbs deployed pre production and I have a second physical box. (i have premium add on purchased. The requirement was to make the second box a ts/rds server which is good. However, SQL is also required in the environment. I understand that its not Ideal to put it on the TS/RDS but could it be placed there anyway? could it be placed on the sbs server itself? what are the pros and cons. my SBS is (slightly) higher spec than my TS/RDS box.
any info would be appreciated.
I've done all this, SQL is up and running but the second server shows "offline" in the SBS console.