| Author |
 Topic  |
|
|
VodkaFish
Average Member
USA
654 Posts |
 Posted - 16 October 2003 : 17:35:20
|
Exactly what is a 5 "client" license?
When MS refers to client - is that 5 usernames to connect to the db at once? 5 connections, even if the same username? 5 web servers?
I'm just not sure. As I have to move some things around on my site and I know I have to convert some stuff to mysql, I'd like to be able to leave a few things as they are on MS SQL Server if possible. Only problem is possible cost, and clearing up this issue will let me know if I have to get the semi-ludicrous server or the completely-ludicrous one. |
v ø d k â f ï § h |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 16 October 2003 : 19:07:26
|
| Ahh, I see you are back to trying to figure this out. I will post what I think, even though you know, and then other people can tell me if I am wrong. I would like to know as well. I believe it would be 5 connections at the same time from different servers. At least that is how I think of it to be. So I have a webserver, 10 connections coming into that from users. That one server is querying the database on a single connection for those 10 requests from users. I would think that if you were buying SQL Server because you had on dozens upon dozens of users on your website that it would get kinda spendy just to run MS SQL. That is why my theory is the way it is. |
Erick
Snowmobile Fanatics
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 October 2003 : 20:23:50
|
| with sql server 2000 MS now do what is called procesor licencing, this is what you buy if you are using a web server to access your sql, so if your sql server is a dual processor, then you need a two processor licence for SQL 2000 |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 16 October 2003 : 20:29:21
|
| What approximate price is single proc. version or where can I find it online? |
Erick
Snowmobile Fanatics
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 October 2003 : 20:40:43
|
Enterprise Edition
$19,999 US per processor
Standard Edition
$4,999 US per processor
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
sr_erick
Senior Member
USA
1318 Posts |
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 17 October 2003 : 00:10:53
|
Do you think MSDE could be used for a highly accessed website?
What about SQL Server 7.0? Anyone think that should be considered? All I have are "normal" tables and a few stored procedures. |
v ø d k â f ï § h |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 17 October 2003 : 03:59:40
|
quote:
Originally posted by VodkaFish
Do you think MSDE could be used for a highly accessed website?
Not legally no.
quote:
What about SQL Server 7.0? Anyone think that should be considered? All I have are "normal" tables and a few stored procedures.
if cost is your worry, look at MySQL |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 October 2003 : 10:47:03
|
| Microsoft used to offer an Internect Connect option, but my recent purchases have shown me that the per processor license was the path to follow for web sites using MSSQL as a database backend. |
 |
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 17 October 2003 : 13:41:47
|
quote:
Originally posted by HuwR
if cost is your worry, look at MySQL
I have been, and it's currently what I'm going to have to lean towards. My current host has SQL Server, but I'm going above the amount of space I'm given, and I don't wish to delete anything. As I'm also going above other things in the plan (like bandwidth), I am probably going to set up my own server(s). While I will be using mysql for some things, I already have a lot done in SQL Server and would have loved to have kept it there (especially since I simply like it better). Shame it's so much. |
v ø d k â f ï § h |
Edited by - VodkaFish on 17 October 2003 13:42:42 |
|
|
| |
Topic |
|
Topic Locked
