Re: Windows 2003 / BI / SQL Server and CALS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hello ray,

For licensing call MS support to get the correct information or your reseller.

Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm


Hi,

Will try and put this so it makes as much sense as possible (and I
will probably fail)

I am a BI / Cognos / SQL server consultant and I tend to leave the
licencing to the client I am working for..but should really understand
a bit more .

When we implement Cognos we tend to go through the following

1 Server (windows 2003 std or Enterprise) for the application (Cognos
all components ) , accessed via IIS ..will sometimes install free
version of SQL server for the content database (as it is below 2 gig)

1 Server (windows 2003 std or enterprise) for the data warehouse,
normally Sql server 2005 standard or Enterprise..

Access to the Cognos application is controlled via linking into the
clients AD or other LDAP

When the user logs into the web app (via IE) they will normally have
to login (and this gets authenticated via LDAP / AD) .

The cognos app is set to use a windows domain account and this gets
used to query the MSSQL content database.

If the reports require Data from the Warehouse again this is done via
the Service account.

soooo

1) as the users are accessing via IIS and authenticating against a DC
(Mostly) does this need additional CALS
2) Do we need SQL server CALS also or just a CAL for the cognos
machine.
3) For the clients that are using another LDAP does this affect CALS
4) any other tips..normally i tell the client to ring Microsoft
Licence
Advisor.
Regards



.

Relevant Pages

  • Re: Windows 2003 / BI / SQL Server and CALS
    ... I am a BI / Cognos / SQL server consultant and I tend to leave the ... licencing to the client I am working for..but should really understand ... Do we need SQL server CALS also or just a CAL for the cognos ...
    (microsoft.public.windows.server.general)
  • Windows 2003 / BI / SQL Server and CALS
    ... I am a BI / Cognos / SQL server consultant and I tend to leave the licencing ... to the client I am working for..but should really understand a bit more. ... Sql server 2005 standard or Enterprise.. ... Do we need SQL server CALS also or just a CAL for the cognos machine. ...
    (microsoft.public.windows.server.general)
  • Re: SQL (User) CALS - Connections
    ... > restrict the 12th person from accessing the the SQL server ... You can't restrict additional users from connecting to SQL Server. ... the CALs are basically a license that authorizes you to access SQL ... Server from each client. ...
    (microsoft.public.sqlserver.setup)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)