I am about to do a network upgrade for a client with a limited budget.
Their situation is that they currently do not have a server at all but are using an XP system for their server requirements - Web Hosting, SQL Server (possibly MYSQL), Data Storage etc.
They have no security on any levels which is very scare.
My proposal is for them to install a Server to implement everything above and I am looking at SBS Server 2008 as it comes with SQL, IIS and Active Directory etc.
I would usually recommend against SBS and have a multi-server environment to split out the website, database and file storage / Active Directory however budget is a concern of theirs.
So.... my question is this: As they will be running a web server on the SBS 2008 Premium, are their any limitations with SQL as to how many clients will have access to the data via their website? or is the licensing that comes with SBS going to be sufficient?
Also in sub of this, any suggestions on ways to maximise security of this single box SBS system?
Oh, they have also expressed that they may like to replicate the SQL data to a server based in Melbourne at some point via VPN, will this affect things with SBS server?