MS SQL advice/help

Xpage

Senior member
Jun 22, 2005
459
15
81
www.riseofkingdoms.com
I'm not the biggest noob when it comes to computers though I know the hardware better than the software.

I'm attempting to understand the difference between between SQL server packages. On some sites I see them offer Includes a sever and CALs; while on other sites I see them licence SQL by the processor.

I understand that the CALS are client access licences while the per processor is unlimited client access. So I need some advice what would be best for me.

Here's the background. A 2 years ago a friend and I decide to design and code a game. I handle the game design, bug finding, and some of the website stuff while he codes the game and does a majority of the website creation.

Our game is coded in ASP.NET and to manage the values and numbers and all the other fun stuff he uses a SQL database. My coder is earning his PhD and knows his stuff pretty well. He also likes to use microsoft stuff, thus he wants MS SQL. Now in our game users don't access the database so I think we can use the Server + CAL packages which I see. Is this correct?

Anyway I am planning a few months ahead for the best case scenario where shared hosting is not an option and the bandwidth is our main problem with dedicated hosting. Thus I would need to build a server and co-locate it (no problem there) and get the software we need.

Thanks in advace for your answers.
If you want to see the game for whatever reason it can be found at
www.riseofkingdoms.com/rok

Note: It is still in beta testing, though not for much longer.
 

oog

Golden Member
Feb 14, 2002
1,721
0
0
it's my understanding (which may be wrong -- call MS or a reseller) that since every user hitting the asp.net website indirectly accesses the db, you would need a CAL for each of those users. in these cases, a per-processor license is cheaper.
 

elcamino74ss

Senior member
Jun 6, 2005
215
0
0
I prefer the per proc license too. I wont take long to get a ton of users hitting it and then you have a fixed cost.