Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MarkSD19
Starting Member
1 Post |
 Posted - 2008-08-21 : 20:26:48
|
| I am hoping someone can give me advice on what type of SQL Server license I need. I have a custom .NET application that is running on a W2K server and uses 1.1 Framework. The application displays web surveys to people. Even though in theory hundreds of anonymous users could be logged in at any one time, in terms of the database there are only two clients. One client handles all of the individual user sessions and the other handles any survey programmers who are administering the surveys. The software currently runs on W2K Server using the free version of MSDE. It works fine with this setup. I need to get a new server (my current one is too old and slow) and am planning on updating my OS to Windows Server 2008. The question is what to do with the SQL component. I want to use SQL 2005 (2008 is too new for me and I am not technical enough to debug it). I could in theory start out using the Developer Edition of 2005 and buy my license once my sw app is finished. I would rather buy something now that I can use for many years. I have looked at Microsoft's website at the following:http://www.microsoft.com/sql/prodinfo/features/compare-features.mspxI cannot tell from this what to do. I plan to buy my server from Dell. They can install SQL 2005 Standard Edition with 5 CALs for under $500. Will this version work for me given that I only have two users signed in? My 2008 Standard OS supports up to 4GB of RAM. So the limitation on SQL Standard will not be a big deal. I think I am OK in terms of CALs, but want to make sure that I won't run into some glitch. Will this work? Let me know if you need any more data. Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-21 : 20:28:48
|
quote:
Even though in theory hundreds of anonymous users could be logged in at any one time
This requires CPU licensing. What edition you need depends on what features you require.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Which Edition do I Need?