Welcome to WebmasterWorld Guest from 54.163.35.238

Forum Moderators: open

Message Too Old, No Replies

sql server 2005 which version needed for web sever

     

the_nerd

1:29 pm on Jan 6, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

2:28 am on Jan 7, 2007 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

11:41 am on Jan 7, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

3:11 pm on Jan 7, 2007 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



just a processor license should do it.

topr8

5:29 pm on Jan 7, 2007 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

aspdaddy

5:35 pm on Jan 7, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

4:41 pm on Jan 8, 2007 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



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

4:59 pm on Jan 8, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

5:45 pm on Jan 8, 2007 (gmt 0)

10+ Year Member



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?

 

Featured Threads

Hot Threads This Week

Hot Threads This Month