Today many applications (SAP, SIEBEL, MANUGISTICS, PEOPLESOFT, and so
on) does not have a client direct access to connect to the database.
They use an Application Server that has only one connection to the
database and the users get connected to this application server.
THE QUESTION: How to control SQL Server User License in this new model,
automatically?
You cannot enable SQL Server Audit because users are not connected
directly to the database.
You cannot use Identity Management applications because they do not
work on NOT Enterprise Business software.
How to do that if you have hundred of applications and database?
Regards,
Marcio 9 2403
I don't see how it it's possible to automate CAL tracking with an n-tier
application model. It's more cost-effective to use processor licensing with
enterprise systems like this anyway so it's a non-issue.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"mleal" <ma************ ****@ig.com.br> wrote in message
news:11******** *************@g 10g2000cwb.goog legroups.com... Today many applications (SAP, SIEBEL, MANUGISTICS, PEOPLESOFT, and so on) does not have a client direct access to connect to the database. They use an Application Server that has only one connection to the database and the users get connected to this application server.
THE QUESTION: How to control SQL Server User License in this new model, automatically?
You cannot enable SQL Server Audit because users are not connected directly to the database. You cannot use Identity Management applications because they do not work on NOT Enterprise Business software.
How to do that if you have hundred of applications and database?
Regards, Marcio
Hi Dan. Thanks for answering.
But I cannot use processor licensing for all these applications and the
other ones we have here.
Believe me, it would increase the costs a lot.
Try to imagine almost 1000 databases. How do I know that I have the
CALs that I need?
It's a very complicated problem.
Regards,
Marcio
mleal wrote: Hi Dan. Thanks for answering.
But I cannot use processor licensing for all these applications and the other ones we have here. Believe me, it would increase the costs a lot.
Try to imagine almost 1000 databases. How do I know that I have the CALs that I need?
It's a very complicated problem.
Regards, Marcio
The point is that SQL Server CALs are licensed per end user not per
connection. So regardless of the method used to connect SQL Server
can't count the number of users for you. The number of databases is
also irrelevent.
With Enterprise Edition, Processor Licensing is cheaper unless you have
fewer than about 100 users per processor. About half that number for
Standard Edition. So if your user base is that small you shouldn't have
so much trouble tracking the number of licences required. How many
users do you have?
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online: http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--
David,
I agree with you and I know that I need to count CALs by my number of
end user.
The problem I don't know correctly how many users I have and many of
them are not employee any more.
My solution for that would be: Export all my users from the
application, because if it connects to the application it needs a sql
license, and than match it to my HR system. If user is an employee I
count a sql license. This would be a solutions.
But it is hard work. Is there not another way?
Thanks,
Marcio
mleal wrote: David,
I agree with you and I know that I need to count CALs by my number of end user.
The problem I don't know correctly how many users I have and many of them are not employee any more.
My solution for that would be: Export all my users from the application, because if it connects to the application it needs a sql license, and than match it to my HR system. If user is an employee I count a sql license. This would be a solutions.
But it is hard work. Is there not another way?
Thanks, Marcio
If you really don't know how many users you have then that is one way.
I still don't understand why this would be an issue. Like I said, CALs
are economical only for small enterprises. If you only have 100 or 200
employees then it can't be that difficult to track what applications
they need to use (I once used to do it for a user base of less than
300). Also, applications such as SAP or SIEBEL will cost you FAR more
per user than SQL Server will. For that reason I've never considered
that any of them would be licensed any other way than with a processor
licence. I've not known CAL licensing used with those apps in practice.
Check out the licensing and pricing options at: http://www.microsoft.com/sql/howtobuy/default.mspx
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online: http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--
Maybe you could periodically select stuff from master.db.syspr ocesses, and
count the number of distinct remote client workstation names or number
of distinct client user names over some suitable period?
-tapio
Something developed out of the following might give a guess of the
number of distinct "real users" you have?
Of course this needs changes if you use sqlserver security.
if not exists (select 1 from sysobjects
where name = 'connstats' and type='U')
begin
create table connstats (
client varchar(20)
,ntuser varchar(20)
,program varchar(40)
,dbname varchar(20)
,ts datetime
)
end
go
if exists (select 1 from sysobjects
where name = 'dbu_gather_sta ts' and type='p')
drop procedure dbu_gather_stat s
go
create procedure DBU_gather_stat s
as
begin
insert into connstats(clien t, ntuser, program, dbname, ts)
select p.hostname, p.nt_username, p.program_name
,d.name, getdate()
from master.dbo.sysp rocesses as p
,master.dbo.sys databases as d
where p.dbid = d.dbid
end
go
grant execute on DBU_gather_stat s to public
go
if exists (select 1 from sysobjects
where name = 'dbu_stats' and type='p')
drop procedure dbu_stats
go
create procedure DBU_stats
as
begin
select
"date"=substrin g(convert(varch ar,ts,126),1,10 )
,"clients"=coun t(distinct client)
,"users"=count( distinct ntuser)
,"programs"=cou nt(distinct program)
from master..connsta ts
group by
substring(conve rt(varchar,ts,1 26),1,10)
end
go
grant execute on DBU_stats to public
go
Ouch... i didn't see the original post about having an n-tier
architecture until now, so my previous post is of no help to the
original poster. Sorry for this minor waste of bandwidth.
-tapio
David, thanks.
Last question: Thing big.
How would you manage CALs from more than 300 servers, 500 databases
used for more than 400 applications with lots of users being created
and deleted from applications and employees that use these applications
being hired or fired? (you need to manage if employee is active to
count a license). At the end of year this is the number we need,
accurate, to buy more or restart, diminish, with MS.
Thanks for your help.
Marcio
mleal wrote: David, thanks.
Last question: Thing big.
How would you manage CALs from more than 300 servers, 500 databases used for more than 400 applications with lots of users being created and deleted from applications and employees that use these applications being hired or fired? (you need to manage if employee is active to count a license). At the end of year this is the number we need, accurate, to buy more or restart, diminish, with MS. Thanks for your help. Marcio
The number of servers, applications and databases is irrelevant as far
as CAL numbers are concerned so the problem is much simpler than you
make it sound. I assume you are talking about CAL numbers in the
thousands or tens of thousands? Have you talked to a Microsoft
licensing specialist? I expect they can suggest an assessment of your
CAL numbers that can satisfy both you and them. At that level you
aren't expected to account for every single user. This is my opinion
not Microsoft's but I'm guessing you can use departmental head counts
or other organizational metrics as the basis for the numbers.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online: http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
-- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ray Dillinger |
last post by:
Okay, most of my career has been spent doing linguistics or
hardcore math, and letting other people write the interfaces
to it. Now I'm up for something a little different and I
need to expand my repertoire into network programming.
So I'm asking for basic pointers and help.
I need to write an application server. Fairly standard stuff,...
|
by: wxqun |
last post by:
We are going to build a DB2 server on a new P570 server for a data
warehouse project. Since the size of the data warehouse is less than
200G, the DB2 server is only assigned 5/10th shared CPU. In this case,
how many DB2 license we should purchase, also how many CPU should be
used when run the "db2licm" command?
Anyone has experience on...
|
by: Jobs |
last post by:
Download the JAVA , .NET and SQL Server interview with answers
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of
attending interviews. If you own a company best way to judge if the
candidate is worth of it.
http://www.questpond.com/InterviewRatingSheet.zip
|
by: =?Utf-8?B?cmJiZW5zb24=?= |
last post by:
To begin,, the network infactructure-
Servers -
Server00 - Windows Server 2003/Installed
Server01 - Windows Server 2003/plan to install
Server10 - Linux RedHat Workstation/Installed
Client/Workstations -
Client 00 - Windows XP Pro/Installed
Client 01 - Windows XP Home/Installed
|
by: Coldfire |
last post by:
Since i cannot show the differences in a two-column like table. I am first putting
MS SQL Server 2005 and then MySQL 5.x.
MS SQL Server 2005
Brief Overview
- SQL Server is a full-fledged database system developed specifically for large enterprise databases. All advanced features of a relational database are fully implemented.
- Once...
| |
by: jasonnance77 |
last post by:
I have built a SSIS package which runs fine in BIDS. I went into Sql
Server Management Studio and created a new job and job step. When I
select the SQL Server Integration Services Package, I get the below
error. There are no options on selecting a SSIS package.
I searched this error for about 5 hours yesterday and the only
solution I...
|
by: helveticus |
last post by:
I'm in the process of finalizing my site. I spent quite a bit of time
designing content pages and would like to cut on development time by
simply managing the DB (SQL server, evt. MySQL) via MS Access. This
works well in my local environment. Can this be extended to a host
provider environment as well? Aside from interaction delays, what are...
|
by: sachinkale123 |
last post by:
I want to stop Sql server Agent Windows service.
I am using below code to stop or start the windows service. Which is I am doing sucessfully.
ManagedComputer mc = default(ManagedComputer);
mc = new ManagedComputer();
Service svc = default(Service);
svc = mc.Services;
if (svc.ServiceState ==...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |