will Applications for Server 2008 R2 work on SBS 2011?

I have to build a server and the largest cost is, of course, the microsoft SQL and server software. It's a small business, and there will not be more than 25 users. Avionte, a staffing software, calls for Windows 2008 R2 SP1 and MS SQL standard.
Will software that calls for server 2008 work with 2011? I noticed that the windows versions for 2008 R2 and SBS 2008 are both the same. Would that work as an alternative?
It also calls for MS SQL standard; My searches indicated that MS SQL standard for sbs is exactly the same. But will it work on SBS 2008 as readily as SBS 2011 if I can't use 2011?
Who is Participating?

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

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.

Lee W, MVPTechnology and Business Process AdvisorCommented:
If you need SQL, get the SBS 2011 Premium Add-on.

Yes, SQL should work fine on SBS - but it's not generally recommended for performance reasons and because the SBS install already does a lot.  Generally, you would want to run both SBS and SQL on separate logical servers (in a VM) on the same physical server.
I agree with Lee - get the premium add-on for SBS 2011. It is under $1000 for a whole other license of w2k8r2 and SQL server.
BitTrekkerAuthor Commented:
Brilliant, so there are no compatability issues between server 2008 standard and sbs 2011. The SBS NOS won't be doing anything else. Simply running the database software Avionte. Do you still recommend implementing a virtual solution?
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Lee W, MVPTechnology and Business Process AdvisorCommented:
Why wouldn't you use a virtual solution? Less hardware needed, greater flexibility for upgrade.

Also, I haven't checked on pricing in a while but the premium add-on for 2011 was $1600 or so.if I remember correctly - it should be cheaper than buying SQL separately, but it was expensive.  In SBS 2008, the license for SBS Premium which.included both SBS and SQL was $1600, but SQL got very expensive and the increase was significant.
The expense comes form the additional CAL's that have to be purchased for the add on.
BitTrekkerAuthor Commented:
@leew: I was going to say additional cost for virtualization licensing, though I see there are free solutions available. I'll talk to my boss about it.

@Geodash: Since there are far fewer 25 users, we were considering sbs 2011 essentials because it doesn't require CALs. If we were to go with essentials and purchase MS SQL standard for Small Business, would we still have to purchase SQL CALs? Likewise, is we were to go with standard and premium add-on, would CALs have to be purchased for SBS and MS SQL separately?  I'm having a bit of difficulty navigating this issue. Thanks for bringing it up.
Rephrase -

Q. How many users can use the SBS 2011 Premium Add-on software?
A. If you acquired the SBS 2011 Premium Add-on for the SBS 2011 Essentials license, then you may have
no more than 25 connections accessing a licensed instance of the server software. If you acquired the SBS
2011 Premium Add-on for the SBS 2011 Standard or SBS 2008 license, then you may have no more than
75 connections accessing a licensed instance of the server software.

They severely changed this with SBS2008 to SBS2011 sorry for confusion
Lee W, MVPTechnology and Business Process AdvisorCommented:
SBS premium add-on requires CALs for both standard and essentials.  

Re: virtualization, esxi is free as is hyper-v.

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
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
Microsoft Server OS

From novice to tech pro — start learning today.