Another question regarding licensing

Hi all,
I read different statements below and now I'm totally confused. My case is
as following: We want install SQLServer 2000 Standard Edition on a single
processor server. Our application Saperion is the only application which uses
that SQL instance. For Saperion we have a concurrent licensing model. That
means we have defined about 40 user who could use these applicaton, but at
the same time only 20 user have access. So, in maximum 20 user can work with
Saperion with SQL as the database engine.
Now the question is what kind of license do I have to buy. I understand the
processor licensing model, but the device CAL's and User CAL's not!
Thank you for your kind help in this matter.
Regards,
KE
User and device CAL licensing is based on total numbers rather than
concurrent numbers. On the information given it seems you would need 40 user
CALs if you chose the User CAL model. Device CALs are licensed per end-user
device so if you have multiple users sharing a workstation for example then
device CALs may be more cost effective than user CALs.
That's my understanding, but don't take my word for it. Ask a Microsoft
representative if you want a definitive answer.
Lots of info on licensing here:
http://www.microsoft.com/sql/howtobuy/default.asp
You may find the FAQ helpful.
David Portas
SQL Server MVP
|||Hi David,
Thank you very much for your answer. 40 user CAL's are not logical for me,
because Saperion never allows us to have more than 20 users online. That
means maximum 20 users can use the SQL server at a certain time. Logical for
me would be 20 user CAL's. If I'm wrong, tell me why......
Best regards,
KE
"David Portas" wrote:

> User and device CAL licensing is based on total numbers rather than
> concurrent numbers. On the information given it seems you would need 40 user
> CALs if you chose the User CAL model. Device CALs are licensed per end-user
> device so if you have multiple users sharing a workstation for example then
> device CALs may be more cost effective than user CALs.
> That's my understanding, but don't take my word for it. Ask a Microsoft
> representative if you want a definitive answer.
> Lots of info on licensing here:
> http://www.microsoft.com/sql/howtobuy/default.asp
> You may find the FAQ helpful.
> --
> David Portas
> SQL Server MVP
> --
>
|||SQL Server isn't licensed per CONCURRENT user. The fact that Saperion is
licensed that way wouldn't affect SQL Server licensing.
A user licence grants A USER a licence to use the software so one licence is
required PER USER not per connection or connected user.
David Portas
SQL Server MVP
|||Hi David,
Thank you very much for your explanation. In my point of view the SQL
licensing NOT per CONCURRENT user is very strange. Logical for me would be
only the CONCURRENT approach. However MS can do what they want!?!?!?
I have following additional question. Do we need for each SQL server
installation CAL's for all possible user (40 in our case)?
Example 1:
2 SQL Server Standard with user CAL's, 40 user can work with applications,
which use these servers.
Do we need 2 server licenses and 40 CAL's or 80 CAL's?
Example 2:
1 SQL Server Standard with processor license, 1 SQL Server Standard with
user CAL's.
According to MS homepage for the SQL Server with processor license I do not
need any CAL's. Is that correct? If yes, I assume that we need 1 server
license and 40 CAL's for the second SQL installation?
Thank you very much in advance.
Regards,
KE
"David Portas" wrote:

> SQL Server isn't licensed per CONCURRENT user. The fact that Saperion is
> licensed that way wouldn't affect SQL Server licensing.
> A user licence grants A USER a licence to use the software so one licence is
> required PER USER not per connection or connected user.
> --
> David Portas
> SQL Server MVP
> --
>
|||Inline below:

> I have following additional question. Do we need for each SQL server
> installation CAL's for all possible user (40 in our case)?
> Example 1:
> 2 SQL Server Standard with user CAL's, 40 user can work with applications,
> which use these servers.
> Do we need 2 server licenses and 40 CAL's or 80 CAL's?
2 server licenses. 40 CAL's. You can look at it like each user has a piece of paper that gives
him/her the right to connect to SQL Servers.

> Example 2:
> 1 SQL Server Standard with processor license, 1 SQL Server Standard with
> user CAL's.
> According to MS homepage for the SQL Server with processor license I do not
> need any CAL's. Is that correct? If yes, I assume that we need 1 server
> license and 40 CAL's for the second SQL installation?
Correct.
FYI: To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KE" <KE@.discussions.microsoft.com> wrote in message
news:7D9A468D-FB00-4D72-AD37-2324CF8C84AF@.microsoft.com...[vbcol=seagreen]
> Hi David,
> Thank you very much for your explanation. In my point of view the SQL
> licensing NOT per CONCURRENT user is very strange. Logical for me would be
> only the CONCURRENT approach. However MS can do what they want!?!?!?
> I have following additional question. Do we need for each SQL server
> installation CAL's for all possible user (40 in our case)?
> Example 1:
> 2 SQL Server Standard with user CAL's, 40 user can work with applications,
> which use these servers.
> Do we need 2 server licenses and 40 CAL's or 80 CAL's?
> Example 2:
> 1 SQL Server Standard with processor license, 1 SQL Server Standard with
> user CAL's.
> According to MS homepage for the SQL Server with processor license I do not
> need any CAL's. Is that correct? If yes, I assume that we need 1 server
> license and 40 CAL's for the second SQL installation?
> Thank you very much in advance.
> Regards,
> KE
>
>
>
> "David Portas" wrote:

Another licensing question

I have a software (weblogic) that users (I have 2500 users) connect to.
Behind Weblogic I run a SQL 2000 server standard edition.
It is only Weblogic that connects to SQL (require 5 connections)
My question is, I was told to buy a SQL processor license instead of a User
or Device CAL?
Why spend 15000$ for a processor license when I can only get 5 CALS ?
Thanks for any help
JP
JP Breton wrote:
> I have a software (weblogic) that users (I have 2500 users) connect
> to.
> Behind Weblogic I run a SQL 2000 server standard edition.
> It is only Weblogic that connects to SQL (require 5 connections)
> My question is, I was told to buy a SQL processor license instead of
> a User or Device CAL?
> Why spend 15000$ for a processor license when I can only get 5 CALS ?
> Thanks for any help
> JP
Q. How do I license SQL Server 2000 CALs in a multiplexed
environment?
A. In most cases Microsoft requires a CAL for every device that
accesses or uses the services of SQL Server 2000. If you are unsure
whether a CAL is required, you should contact your Microsoft sales
representative or account manager. Inquires can be directed to Microsoft
Licensing by calling (800)426-9400.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Another licensing question

I have a software (weblogic) that users (I have 2500 users) connect to.
Behind Weblogic I run a SQL 2000 server standard edition.
It is only Weblogic that connects to SQL (require 5 connections)
My question is, I was told to buy a SQL processor license instead of a User
or Device CAL?
Why spend 15000$ for a processor license when I can only get 5 CALS '
Thanks for any help
JPJP Breton wrote:
> I have a software (weblogic) that users (I have 2500 users) connect
> to.
> Behind Weblogic I run a SQL 2000 server standard edition.
> It is only Weblogic that connects to SQL (require 5 connections)
> My question is, I was told to buy a SQL processor license instead of
> a User or Device CAL?
> Why spend 15000$ for a processor license when I can only get 5 CALS '
> Thanks for any help
> JP
Q. How do I license SQL Server 2000 CALs in a multiplexed
environment?
A. In most cases Microsoft requires a CAL for every device that
accesses or uses the services of SQL Server 2000. If you are unsure
whether a CAL is required, you should contact your Microsoft sales
representative or account manager. Inquires can be directed to Microsoft
Licensing by calling (800)426-9400.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Another licensing question

I have a software (weblogic) that users (I have 2500 users) connect to.
Behind Weblogic I run a SQL 2000 server standard edition.
It is only Weblogic that connects to SQL (require 5 connections)
My question is, I was told to buy a SQL processor license instead of a User
or Device CAL?
Why spend 15000$ for a processor license when I can only get 5 CALS '
Thanks for any help
JPJP Breton wrote:
> I have a software (weblogic) that users (I have 2500 users) connect
> to.
> Behind Weblogic I run a SQL 2000 server standard edition.
> It is only Weblogic that connects to SQL (require 5 connections)
> My question is, I was told to buy a SQL processor license instead of
> a User or Device CAL?
> Why spend 15000$ for a processor license when I can only get 5 CALS '
> Thanks for any help
> JP
Q. How do I license SQL Server 2000 CALs in a multiplexed
environment?
A. In most cases Microsoft requires a CAL for every device that
accesses or uses the services of SQL Server 2000. If you are unsure
whether a CAL is required, you should contact your Microsoft sales
representative or account manager. Inquires can be directed to Microsoft
Licensing by calling (800)426-9400.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Analysis Services upgrade to Enterprise Edition

I was running SQL 2000 Standard with the Analysis Services
repository in a SQL database.
I upgraded SQL to Enterprise. When a user tried to create
a partitioned cube he got: user-defined partitions are
available only if you install Analysis Services SQL Server
2000 Enterprise Edition
I "upgraded" to Analysis Services Enterprise - actually
all it did was reinstall. Since I had already migrated
the repository to SQL, my cubes did not exist.
Here is probably where my mistake occurred: I "re-
migraded" the repository to SQL ... my cubes are still not
there.
I have since restored the repository database from a pre-
upgraded Analysis Services version ... my cubes are still
not there.
I have a large project that is waiting for these cubes.
Please tell me I have a chance of getting these cubes back!
Does anyone have any suggestiongs?
TIA
WadeIf you were using SQL Database A as repository before upgrading and
migrating repsitory to SQL Database B after upgrading, then restore the
backup to Database A won't help. You need to edit the repository connection
string so it points to the database holds the right meta data for OLAP.
Thanks
Wei Zhang
Microsoft OLAP Support

Analysis Services upgrade to Enterprise Edition

I was running SQL 2000 Standard with the Analysis Services
repository in a SQL database.
I upgraded SQL to Enterprise. When a user tried to create
a partitioned cube he got: user-defined partitions are
available only if you install Analysis Services SQL Server
2000 Enterprise Edition
I "upgraded" to Analysis Services Enterprise - actually
all it did was reinstall. Since I had already migrated
the repository to SQL, my cubes did not exist.
Here is probably where my mistake occurred: I "re-
migraded" the repository to SQL ... my cubes are still not
there.
I have since restored the repository database from a pre-
upgraded Analysis Services version ... my cubes are still
not there.
I have a large project that is waiting for these cubes.
Please tell me I have a chance of getting these cubes back!
Does anyone have any suggestiongs?
TIA
Wade
If you were using SQL Database A as repository before upgrading and
migrating repsitory to SQL Database B after upgrading, then restore the
backup to Database A won't help. You need to edit the repository connection
string so it points to the database holds the right meta data for OLAP.
Thanks
Wei Zhang
Microsoft OLAP Support

Analysis Services in SQL Server 2000 for Small Business Server 2003

Hi there
Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
SQL Server 2000 Standard Edition does include Analysis Services, but I don't
get the option
to install AS under the "Select SQL Server components" on my SBS 2003
Premium Technologies CD.
Please help
Best regards
Loane
Hi
You may be better off asking this in microsoft.public.windows.server.sbs
SQL Server is only available in the premium edition, therefore it sounds
like you must have that version?
Apparently there is a checkbox to tick that will install it, so it is a
matter of finding it!!!
http://tinyurl.com/8ntfy
Also read the section "Configuring Analysis Services" at
http://www.microsoft.com/technet/pro.../anservog.mspx
John
"Loane Sharp" <look_sharp_not@.hotmail.com> wrote in message
news:eHIq9e%23fFHA.3936@.tk2msftngp13.phx.gbl...
> Hi there
> Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
> SQL Server 2000 Standard Edition does include Analysis Services, but I
> don't get the option
> to install AS under the "Select SQL Server components" on my SBS 2003
> Premium Technologies CD.
> Please help
> Best regards
> Loane
>
|||Thanks John

> Hi
> You may be better off asking this in microsoft.public.windows.server.sbs
> SQL Server is only available in the premium edition, therefore it sounds
> like you must have that version?
> Apparently there is a checkbox to tick that will install it, so it is a
> matter of finding it!!!
> http://tinyurl.com/8ntfy
> Also read the section "Configuring Analysis Services" at
> http://www.microsoft.com/technet/pro.../anservog.mspx
>
> John
>

Analysis Services in SQL Server 2000 for Small Business Server 2003

Hi there
Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
SQL Server 2000 Standard Edition does include Analysis Services, but I don't
get the option
to install AS under the "Select SQL Server components" on my SBS 2003
Premium Technologies CD.
Please help
Best regards
LoaneHi
You may be better off asking this in microsoft.public.windows.server.sbs
SQL Server is only available in the premium edition, therefore it sounds
like you must have that version?
Apparently there is a checkbox to tick that will install it, so it is a
matter of finding it!!!
http://tinyurl.com/8ntfy
Also read the section "Configuring Analysis Services" at
http://www.microsoft.com/technet/pr...n/anservog.mspx
John
"Loane Sharp" <look_sharp_not@.hotmail.com> wrote in message
news:eHIq9e%23fFHA.3936@.tk2msftngp13.phx.gbl...
> Hi there
> Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
> SQL Server 2000 Standard Edition does include Analysis Services, but I
> don't get the option
> to install AS under the "Select SQL Server components" on my SBS 2003
> Premium Technologies CD.
> Please help
> Best regards
> Loane
>|||Thanks John

> Hi
> You may be better off asking this in microsoft.public.windows.server.sbs
> SQL Server is only available in the premium edition, therefore it sounds
> like you must have that version?
> Apparently there is a checkbox to tick that will install it, so it is a
> matter of finding it!!!
> http://tinyurl.com/8ntfy
> Also read the section "Configuring Analysis Services" at
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx[/ur
l]
>
> John
>

Analysis Services in SQL Server 2000 for Small Business Server 2003

Hi there
Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
SQL Server 2000 Standard Edition does include Analysis Services, but I don't
get the option
to install AS under the "Select SQL Server components" on my SBS 2003
Premium Technologies CD.
Please help
Best regards
LoaneHi
You may be better off asking this in microsoft.public.windows.server.sbs
SQL Server is only available in the premium edition, therefore it sounds
like you must have that version?
Apparently there is a checkbox to tick that will install it, so it is a
matter of finding it!!!
http://tinyurl.com/8ntfy
Also read the section "Configuring Analysis Services" at
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
John
"Loane Sharp" <look_sharp_not@.hotmail.com> wrote in message
news:eHIq9e%23fFHA.3936@.tk2msftngp13.phx.gbl...
> Hi there
> Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
> SQL Server 2000 Standard Edition does include Analysis Services, but I
> don't get the option
> to install AS under the "Select SQL Server components" on my SBS 2003
> Premium Technologies CD.
> Please help
> Best regards
> Loane
>|||Thanks John
> Hi
> You may be better off asking this in microsoft.public.windows.server.sbs
> SQL Server is only available in the premium edition, therefore it sounds
> like you must have that version?
> Apparently there is a checkbox to tick that will install it, so it is a
> matter of finding it!!!
> http://tinyurl.com/8ntfy
> Also read the section "Configuring Analysis Services" at
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
>
> John
>

Analysis Services 2005 is not getting connected

All,

I am running Windows 2003 Server Standard Edition. Installed SQL Server 2000 and SP4 with default instance.

Installed SQL Server 2005 including analysis services with named instance (SQL2005).

Able to connect to SQL Server 2005. But when i am trying to connect to analysis services with

Windows authentication and server name as "UKPRESALES1\SQL2005".

Getting an Error : "A connection cannot be made to redirector. ensure that sqlbrowser service is running."

Pls suggest me. Finally I ended up in un-installing everything and trying out.

Raja.

Have you read the following paper on AS connectivity problems?

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

It could be a firewall problem...

HTH,

Chris

|||

Indeed, please make sure that both Analysis Services 2005 (msmdsrv.exe) and SQL Browser are allowed in the firewall to accept connections (related article here: http://msdn2.microsoft.com/en-us/library/ms175638.aspx).

|||

hello chris,

Windows Firewall have been disabled already. That too i am trying to connect in the local machine. Even the Sql browser service is running under local account.

As of now i am trying to install sql 2005 in default instance. Later I will install Sql 2000 with named instance.

Pls help me if any other solution is available.

Rajas.

|||So, to be clear - you can't connect even from the same server that you've installed AS on?

Analysis Services 2005 is not getting connected

All,

I am running Windows 2003 Server Standard Edition. Installed SQL Server 2000 and SP4 with default instance.

Installed SQL Server 2005 including analysis services with named instance (SQL2005).

Able to connect to SQL Server 2005. But when i am trying to connect to analysis services with

Windows authentication and server name as "UKPRESALES1\SQL2005".

Getting an Error : "A connection cannot be made to redirector. ensure that sqlbrowser service is running."

Pls suggest me. Finally I ended up in un-installing everything and trying out.

Raja.

Have you read the following paper on AS connectivity problems?

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

It could be a firewall problem...

HTH,

Chris

|||

Indeed, please make sure that both Analysis Services 2005 (msmdsrv.exe) and SQL Browser are allowed in the firewall to accept connections (related article here: http://msdn2.microsoft.com/en-us/library/ms175638.aspx).

|||

hello chris,

Windows Firewall have been disabled already. That too i am trying to connect in the local machine. Even the Sql browser service is running under local account.

As of now i am trying to install sql 2005 in default instance. Later I will install Sql 2000 with named instance.

Pls help me if any other solution is available.

Rajas.

|||So, to be clear - you can't connect even from the same server that you've installed AS on?