Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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

2 Answers 2

up vote 1 down vote accepted

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

share|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

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

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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