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 |
|
Drewmon
Starting Member
6 Posts |
 Posted - 2005-11-21 : 19:14:34
|
I'm new to Microsoft SQL and need some guidance.We have an website that looks up user info to authenticate and store miscellaneous info in SQL 7 via one of our websites. Not sure if that counts as "publishing" info to the web via SQL or not? And, we just got online with an external hosting provider to find that SQL 7 doesn't work with Windows 2003 Server at all. D'Oh! Great, a zippy Win2K3 server for the website, but no database.  So, we are looking into what options we have available for trying to control costs and move forward (somewhat) with our version of SQL.I can find good pricing on SQL 2000 Standard but I'm not able to figure out if that will support what we are doing with our website. Microsoft's site is dismal at best since they point everything to SQL 2005 which we simply cannot afford right now (sounds like it would mandate licensing by CPU? Wow! Not too great for a startup company!).So any input appreciated about MS SQL 2000 licensing/versions/options before we buy the wrong thing and waste money!Mmmmmkay. Yeah, did you get the memo about the TPS reports? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-11-21 : 19:26:33
|
| If a web application accesses your SQL Server, then per seat licensing is not an option, and CPU is the only real option.You can always try SQL Server Express 2005 and see if it meets your needs before you purchase a full SQL Server version. From what you've described it's unlikely that your app will max it out (1 CPU, 1 GB RAM, 4 GB database size) |
 |
|
|
Drewmon
Starting Member
6 Posts |
Posted - 2005-11-21 : 19:30:10
|
| I saw SQL2K5 Express on Microsoft's site but wondered if that was "legal" to use in our particular application?Is the "Enterprise" version of SQL2K the equivalent of a processor license or did MS make a real CPU based SQL2K license?Thanks again for any info!Mmmmmkay. Yeah, did you get the memo about the TPS reports? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-11-21 : 19:45:45
|
| SQL Express is legal to use for any application you wish, it simply has performance and capacity limits the other editions do not.If cost is a factor, you definitely cannot afford the Enterprise edition of SQL Server. And if you really need the Enterprise edition (and you don't) then CPU licensing is the only practical option. |
|
|
|
|
|
|
|
|
[?] I'm lost - What edition of SQL2000 to use?