Welcome to WebmasterWorld Guest from 54.242.53.253

Forum Moderators: open

Message Too Old, No Replies

sql server 2005 which version needed for web sever

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 29, 2003
posts:790
votes: 0


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.

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

Senior Member

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

joined:Sept 1, 2001
posts:4392
votes: 0


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.

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 29, 2003
posts:790
votes: 0


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.

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

Senior Member

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

joined:Sept 1, 2001
posts:4392
votes: 0


just a processor license should do it.
5:29 pm on Jan 7, 2007 (gmt 0)

Senior Member

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

joined:Apr 19, 2002
posts:3212
votes: 13


hold on i could be mistaken but i thought that express version could only run on the SAME machine as the web server
5:35 pm on Jan 7, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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.
4:41 pm on Jan 8, 2007 (gmt 0)

Moderator from US 

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

joined:Dec 10, 2005
posts:5628
votes: 48


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...]
4:59 pm on Jan 8, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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.

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

Junior Member

10+ Year Member

joined:Jan 28, 2002
posts:166
votes: 0


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?