Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql server 2000 licensing

Status
Not open for further replies.

Shift838

IS-IT--Management
Joined
Jan 27, 2003
Messages
987
Location
US
I am wondering how this per seat and per server licensing really works. I have various .net applications that connect to sql through a DSNless connection. Would each of these applications that reside on the same server be considered a device?

I need to know if I can just choose per seat and select the standard 5 or we need to purchase more or a server access license. If the .net applications will not cause sql to alert an error if all 10+ are hitting at the same time with the configuration of per seat set to 5 then I can do that.

Thank You,

 
my understanding, though it may be incorrect so please correct me if im wrong, is that each person using the application will require a sql seat. They are using sqlserver even if its through a third party application. thats why most public applications that use sql server do per server lics so they dont have to worry about it. in an intranet you can control lics and not worry about it as much.

if im wrong please correct me.
 
I have no idea if you are wrong. I need to know if the applications will be counted as devices..
 
The basics are:

If you choose per device it counts each physical device that connects to the SQL Server or that uses the data from the SQL Server. (You can't have 10000 people connect to a middle ware server to get around the licensing. You'd still need to license the 10,000 machines.)

If you choose per user it counts each user that connect to the SQL Server. If 3 people all share a workstation and you use per user it will require 3 user cals.

I've got a FAQ on licensing faq962-5153 which covers many of these questions.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(Not quite so old any more.)
 
Denny,

Thanks for the information, that really worked. GREAT FAQ too by the way. exactly what I needed.

chris
 
no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(Not quite so old any more.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top