The right M.S. server

I'm in need of a M.S. server to get off a peer-to-peer network
this is for a 21 user setup. we will not use Exchange but want to have remote access to the file server or the PCs on this new domain. The server also needs to run SQL 20008 R2 for a company database
My first thought is Small Business Server 2011 Standard and add open license of SQL 2008 R2
then setup Remote Web Access but will are not going to use Exchange.
Question
What other M.S. server can I purchase instead of SBS that will give me a remote access solution?
LVL 1
jsarinanaI.T. ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Don S.Commented:
Actually SBS 2011 is not sold any more.  It's replacement would be Server 2012 Essentials.  It does not include Exchange or SQL and is designed to be the on premises server for smaller organizations.
jsarinanaI.T. ManagerAuthor Commented:
don6718
I can still get it
Server 2012 Essentials does not come with SQL understood. Is there a diff. edition that come with SQL or that can be added too?
Don S.Commented:
SQL would need to be purchased separately but can be installed on the Server 2012 Essentials server.
SBS 2011 standard does not come with SQL server either, but a premium addon pack can be purchased to add it in.  That is probably your least expensive route, BUT sbs2011 was retired from sale in 2013 (there may be some licenses left in the channel) and it's end of life date is .  That makes me reticent to suggest installing a "new" server with 5 yr old software (It's built on server 2008 R2 and exchange 2010) on it that is already out of mainstream support and is set to go out of extended support in less than 5 years (2020).
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

RantCanSr. Systems AdministratorCommented:
2012 essentials. Is the DB larger than 10GB? If not then you may use SQL 2014 Express.
Lee W, MVPTechnology and Business Process AdvisorCommented:
With 21 users you're getting very close to the Essentials limit.  I would say you're better off using Windows Server 2012 Standard, Installing Hyper-V on the physical server, and installing TWO VMs, one for the SQL database and one for your domain controller and installing the essentials role on the DC should give you the remote web access capability as well as backups.  And don't forget you need to buy Windows CALs and SQL CALs.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jsarinanaI.T. ManagerAuthor Commented:
RantCan
Does 2012 Essentials include SQL 2014 Express or do I need to add Express, this maybe an option ?
Lee W, MVPTechnology and Business Process AdvisorCommented:
I believe it comes with installed instances that are dedicated to functions so regardless, you'd have to download and install it... It's not bundled in specifically to give the end user a database they can use for whatever.
jsarinanaI.T. ManagerAuthor Commented:
Anyone know if Small Business Server 2012 Standard comes with SQL 2014 Express and what's the DB size limit for this Express?
jsarinanaI.T. ManagerAuthor Commented:
Is there a Standard version of 2012?
Lee W, MVPTechnology and Business Process AdvisorCommented:
"Small Business Server 2012"  Doesn't exist.  The last version which is no longer sold is 2011.  ESSENTIALS 2012 exists.  

To be clear, SQL Express databases are used in a variety of places in an SBS server and I believe Essentials... BUT, they are not bundled in for your use for any other databases.... if you want to run your own company databases (or databases for applications used by your company) you MUST download and install your own instance(s) on the server (You can have more than one).
jsarinanaI.T. ManagerAuthor Commented:
thanks
RantCanSr. Systems AdministratorCommented:
Right.
SQL Express is handy because it is free, but is for low demand applications that can get no further than 10 GB in size. SQL Standard is expensive but scale-able in terms of DB size, clustering, and other advanced features. Enterprise is able to utilize larger memory allocations, and increased processing power.

https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.