What do I need to know about running SQL Server 2008 on a dedicated server as far as licensing goes? What would my cheapest option be? Also, for a fairly small web application, would shared hosting make more sense? (These both would be through a hosting provider) Thanks!

-Shane

link|improve this question
If your server is on the Internet, you'll need that licence. SQL licensing is usually per physical CPU either way. – Randolph West Nov 5 '10 at 23:02
feedback

2 Answers

up vote 1 down vote accepted

A full SQL license is expensive. I would recommend using shared hosting, or run MySQL.

link|improve this answer
Thanks - that's pretty much the conclusion I've come to as well. Looks like I'm switching to MySQL! – Shane Fulmer Nov 6 '10 at 1:55
feedback

I beleive SQL Server Express is free to use without any licensing...it can handle databases up to 2GB i think.

Also you don't get access to the SQL Server Agent and a few other technical parts of the full version...but if you don't need them then it should work fine for small apps.

Paul

link|improve this answer
Maximum database size is increased to 10GB for sql server 2008R2 expressed msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx – DaniSQL Nov 6 '10 at 21:52
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.