homepage Welcome to WebmasterWorld Guest from 54.204.58.87
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
sql server 2005 which version needed for web sever
the_nerd




msg:3210345
 1:29 pm on Jan 6, 2007 (gmt 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.

 

txbakers




msg:3210893
 2:28 am on Jan 7, 2007 (gmt 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.

the_nerd




msg:3211150
 11:41 am on Jan 7, 2007 (gmt 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.

txbakers




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

just a processor license should do it.

topr8




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

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

aspdaddy




msg:3211371
 5:35 pm on Jan 7, 2007 (gmt 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.

LifeinAsia




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

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




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

JuDDer




msg:3212288
 5:45 pm on Jan 8, 2007 (gmt 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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved