sql server 2005 which version needed for web sever

[the_nerd]

Hi,

does anybody know which MS SQL Server 2005 Version I need if I want to install it on a dedicated server that will serve database queries for my dedicated webserver(s) - "cals" and the like?

Thanks, nerd.

[txbakers]

If it's not a lot of queries, you can use the express version or developer version.

If it's going to be a lot of queries with heavy lifting, you should get the "real" version.

[the_nerd]

thanks, txbakers

I already compared express, workgroup, standard and enterprise versions. What I'm not sure about is whether I need a processor licence or cals (Client access Licences) to get the licencing right.

[txbakers]

just a processor license should do it.

[topr8]

hold on i could be mistaken but i thought that express version could only run on the SAME machine as the web server

[aspdaddy]

Compare the cost of 1 device CAL per webserver to the cost of the number of processor licences you need and go for the cheapest.

[LifeinAsia]

According to Micro$oft:

Processor licensing is a better choice for externally focused server applications, such as Internet and extranet scenarios. It is often difficult to count devices or users in these scenarios, so hardware-based pricing is more straightforward.

[microsoft.com...]

[aspdaddy]

They would say that wouldnt they, proc licences cost much more. If you are using webservers to access and not using windows authentication its very, very easy to count the number of users and devices :)

>such as Internet and extranet scenarios
LOL, Totally different scanarios when it comes to licencing.

[JuDDer]

They would say that wouldnt they, proc licences cost much more. If you are using webservers to access and not using windows authentication its very, very easy to count the number of users and devices
>such as Internet and extranet scenarios
LOL, Totally different scanarios when it comes to licencing.

That raises a very interesting question.

If you had a single server to run SQL which you access via a website on a seperate server, does that mean the only "user" would be the web server, meaning it would be fine to use a standard 5 client access license, or would a "processor" license still be needed?