Ok I have a newly developed web application that 20 users will have access to internally at the office. The app is heavily data intensive as it will use hand held scanners for entry and there are multiple check points at which this data will be accessed. Here is where I get confused.
1. The developers said originally that we needed two servers. One to host mssql and another to actually do the work of input and output to the sql server. However we talked to them and they said a single server would work if we had enough specs. That would be SBS2011 Standard. As I got to looking it seems I would still have to purchase MSSQL and additional licences to my understanding. we were looking to use office 365 vs exchange seeing as I have 2 other servers with exchange that in my opinion don't do as well as they should.
2. After reading all this information I contacted a server guy we have used for some time and handed him all the information I had been given. He then comes back to me with the recommendation that he would use a single server and run VM's to still wind up with 2 server os's running the setup.
3. Here is my quesitons
If I could run this on SBS 2011 Standard or 2012 Standard and had to purchase MSSQL 2008 + enough license for 20 users internally what happens when I have the possibility of 100 people accessing the website from an external facing part of the app? would I need additional licensing for that as well?
The server guy seems to think I really need to not allow the DC to be accessed easily from the web yet I have 2 other DC's at two other locations that are and I have no issues with them. What do you guys think?
I have dealt with another server that ran Exchange and a second data related application that ran SQL that server ran very very poorly until I had installed a second DATA only drive the the application. I don't want to wind up in that situation again. Which is the primary reason for going with office 365 in exchanges place.
The dilemma is I originally had roughly a 6K budget on this server and the developers talked like a single setup would work. Now with throwing MSSQL and 20 license + on it I am not sure I can do that. In the end I want a good strong setup not just over powered and Im willing to do what it takes to make it run right. Even it that means VM and larger scale hardware. I hope this explains the situation please ask more questions as needed.
Just looking for opinions and Advice at this point.