License

[KSiva]

Hi all,

We are buying sql server 2000 profession edition and about 50 computers will connect to the server ( by odbc connectivity). I am pretty sure that we dont have to buy each license for the computers. But the management is bit worry about that. Can some one confirm this for me ( probably a link)

Thanks,
Siva Sivakumar Kandaraj
System Administrator,Web Programmer
Melbourne
Australia.

 

[Vancouverite]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_5alh.asp

 

[tlbroadbent]

There is no SQL Server Professional Edition. Do you have Enterprise or Standard Edition? There are two licensing models; Server/Per-Seat CAL or Per Processor. If you choose the 1st, you must buy a license for each client device that connects to SQL Server. If you choose the 2nd, unlimited clients can connect.

Generally, the break-even point is about 25 client connections. If more than 25 client devices connect, Per Processor licensing is cheaper than Server/Per-Seat licensing.

If users will connect to SQL Server from the internet, there is only one choice; Per Processor licensing.

Check the following link for more details.

http://www.microsoft.com/sql/howtobuy/production.asp

If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[KSiva]

Thanks mate!

I have been reading thru this. NO WONDER Bill gates is the richest man!

Thanks again,
Siva Sivakumar Kandaraj
System Administrator,Web Programmer
Melbourne
Australia.

 

[KSiva]

Hello tlbroadbent,

I am not sure if I can do this: As I said my program which developed using Python, will connects to central sql server. There are more than 50 users ( expecting about 100) will be then connecting to sql server using ODBC. I actually spoke to MicroSoft about this, they says we will have to pay for each connection. I am just wondering if there is another way to do this ( suppose creating a centralised ODBC connectivity and then all the users can connect thru that) ... If I can do this .. we'll save few grand $$

Any help!
Siva Sivakumar Kandaraj
System Administrator,Web Programmer
Melbourne
Australia.

 

[JamesLean]

I would have to disagree with whoever you spoke to at Microsoft! In your case i would have thought that per-processor licensing would be the way to go.

It doesn't matter how your users connect or what applications they use to do so. You just have one license for each processor in your Server. --James

 

[tlbroadbent]

The Microsoft EULA is very clear on the matter of multiple tier connectivity. You may connect through a COM obect or a web page on the company intranet but every client device requires a license under the Server licensing model. There may be only one connection to the server but the connections to the intermediate tier must be licensed.

The MS person you spoke with was incorrect. You can buy processor licensing. Only, if you choose Server licensing must every client must be licensed. If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm