Number of licenses SQL and CALs that I need

Question

Number of licenses SQL and CALs that I need

sistemas_casinomnes

SSChasing Mays

Points: 659
More actions
November 30, 2010 at 8:00 am

#147877

Hello, I have to buy sql licenses.
I have a client-server application, the server application is running in the server machine where the sql is installed. The server application connects to sql server with the user "sa".
All the clients (10 is the number of users in my office) use a client application that connect to the server application and don´t know what user is connected to the sql server.
I have 10 license CALS of Windows Server 2003.
I think that I need 1 License for SQL Server and 1 License of user Sql (CAL).
I don´t need 10 license CAL for SQL, because the server application use the "sa" user. Maybe, I don't need a license for user SQL (CAL)
Is that right?
Thanks for your help.
Viky

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Wrong, it's not the amount of logins but the # of peoples.

You need 10 cals. I'd also confirm what is the tipping point between CAL and processor and verify if it's not cheaper to go straight to processor.

At 10 cals licenses it should be cheaper than 1 processor license, but if you think you'll need 20+ in the [not so] near future, you might consider using processor license mode.

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 2

You can use the script on the link below to calculate the break even point for Processor vs. Server/CAL licensing.

Calculate SQL CAL Break Even Point

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153583

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Nice script.

I don't want to seem too anal, but I have a Case sensitive server and your script fails @ @edition (lower e).

:hehe:

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Aside: Stop using the sa account. That's so far into the 'worst practices' territory you'll need a map to find it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 5

Ninja's_RGR'us (11/30/2010)
Nice script.
I don't want to seem too anal, but I have a Case sensitive server and your script fails @ @edition (lower e).
:hehe:

Fixed, I hope.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Michael Valentine Jones (11/30/2010)
Ninja's_RGR'us (11/30/2010)
Nice script.
I don't want to seem too anal, but I have a Case sensitive server and your script fails @ @edition (lower e).
:hehe:
Fixed, I hope.

Yes it works now. Tx :w00t: