Client has 5 employees and they are running a small program that needs an SQL server. The load on the server will be minimal.

Three questions:

1. It seems that there is a SQL Server 2008 R2 instance running on the box allready running since I find "SBSMONITORING" and "SHAREPOINT" servers in the "Sql Server Configuration Manager". I do not however see any "MSSQLSERVER" server so I assume that thes SQL server instance that comes preconfigured with this OS is not something you can normally access and that one would need the Premium Addon to enable this. Correct?

1 & 2 - Microsoft SQL Server 2008 R2 Express is included and installed on SBS 2011. You can create new instance of this server. Never use existing instances. Premium add-on is needed if you like to use

1 & 2 - Microsoft SQL Server 2008 R2 Express is included and installed on SBS 2011. You can create new instance of this server. Never use existing instances. Premium add-on is needed if you like to use SQL Standard (on separate server).
3. It should work

I hope you have enough memory and powerful processor, because SBS have many running heavy services.

Featured Post

Constantly trying to correctly format email signatures? Spending all of your time at every user’s desk to make updates? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today!

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.