Calculated Cell

Some calculated cells need to be migrated from Analysis Services 2000 to 2005.
In 2000 we have them only on a single cube. In 2005 we are migrating the entire database as a cube and the cubes within 2000 are implemented as perspectives in 2005.

Is there any elegant way to ensure that the calculated cells do not affect other cubes(perspectives) in 2005?

You may want to ask this question in Analysis Services forum.

CAL licenses - don't understand!

Hi
I'm in the process of migrating from hosting web sites on a shared server
and just buying SQL Server DBs when I need them, to a dedicated server which
I have to administer. So now I need to buy a 'proper' copy of SQL Server as
well as the Developer Edition version I develop on.
I read everything I could find about this on the MS site and ended up none
the wiser. If I have a one-processor server serving web sites from its own
copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
sites on the server, each with its own db, does this use 1 CAL or 10?
I'm so confused!
Thanks for any clarification.Read about "multiplexing". You need to go Per Processor if you don't want to
ensure that everyone
who accesses your web site has a SQL Server CAL.
http://www.microsoft.com/sql/howtobuy/faq.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim P" <TimP@.discussions.microsoft.com> wrote in message
news:409D6E35-21E7-4E12-BE01-32BAD2382BA1@.microsoft.com...
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server whi
ch
> I have to administer. So now I need to buy a 'proper' copy of SQL Server a
s
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.|||"Tim P" wrote:

> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server whi
ch
> I have to administer. So now I need to buy a 'proper' copy of SQL Server a
s
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
If you are hosting a publicly accessible website then you need to purchase a
Processor licence.
If you are hosting an intranet site where you can determine and control the
number of users then you have the option of Processor or CAL licensing. You
need one CAL per end-user or end-user device.
Licensing issues are often difficult and consfusing so if you have any
doubts consult a Microsoft rep or authorised dealer.
David Portas
SQL Server MVP
--|||Ah, that makes sense.
Thanks guys!
"David Portas" wrote:

> "Tim P" wrote:
>
> If you are hosting a publicly accessible website then you need to purchase
a
> Processor licence.
> If you are hosting an intranet site where you can determine and control th
e
> number of users then you have the option of Processor or CAL licensing. Yo
u
> need one CAL per end-user or end-user device.
> Licensing issues are often difficult and consfusing so if you have any
> doubts consult a Microsoft rep or authorised dealer.
> --
> David Portas
> SQL Server MVP
> --
>

CAL licenses - don't understand!

Hi
I'm in the process of migrating from hosting web sites on a shared server
and just buying SQL Server DBs when I need them, to a dedicated server which
I have to administer. So now I need to buy a 'proper' copy of SQL Server as
well as the Developer Edition version I develop on.
I read everything I could find about this on the MS site and ended up none
the wiser. If I have a one-processor server serving web sites from its own
copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
sites on the server, each with its own db, does this use 1 CAL or 10?
I'm so confused!
Thanks for any clarification.Read about "multiplexing". You need to go Per Processor if you don't want to ensure that everyone
who accesses your web site has a SQL Server CAL.
http://www.microsoft.com/sql/howtobuy/faq.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim P" <TimP@.discussions.microsoft.com> wrote in message
news:409D6E35-21E7-4E12-BE01-32BAD2382BA1@.microsoft.com...
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.|||"Tim P" wrote:
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
If you are hosting a publicly accessible website then you need to purchase a
Processor licence.
If you are hosting an intranet site where you can determine and control the
number of users then you have the option of Processor or CAL licensing. You
need one CAL per end-user or end-user device.
Licensing issues are often difficult and consfusing so if you have any
doubts consult a Microsoft rep or authorised dealer.
--
David Portas
SQL Server MVP
--|||Ah, that makes sense.
Thanks guys!
"David Portas" wrote:
> "Tim P" wrote:
> > Hi
> >
> > I'm in the process of migrating from hosting web sites on a shared server
> > and just buying SQL Server DBs when I need them, to a dedicated server which
> > I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> > well as the Developer Edition version I develop on.
> >
> > I read everything I could find about this on the MS site and ended up none
> > the wiser. If I have a one-processor server serving web sites from its own
> > copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> > sites on the server, each with its own db, does this use 1 CAL or 10?
> >
> > I'm so confused!
> >
> > Thanks for any clarification.
> If you are hosting a publicly accessible website then you need to purchase a
> Processor licence.
> If you are hosting an intranet site where you can determine and control the
> number of users then you have the option of Processor or CAL licensing. You
> need one CAL per end-user or end-user device.
> Licensing issues are often difficult and consfusing so if you have any
> doubts consult a Microsoft rep or authorised dealer.
> --
> David Portas
> SQL Server MVP
> --
>

CAL licenses - don't understand!

Hi
I'm in the process of migrating from hosting web sites on a shared server
and just buying SQL Server DBs when I need them, to a dedicated server which
I have to administer. So now I need to buy a 'proper' copy of SQL Server as
well as the Developer Edition version I develop on.
I read everything I could find about this on the MS site and ended up none
the wiser. If I have a one-processor server serving web sites from its own
copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
sites on the server, each with its own db, does this use 1 CAL or 10?
I'm so confused!
Thanks for any clarification.
Read about "multiplexing". You need to go Per Processor if you don't want to ensure that everyone
who accesses your web site has a SQL Server CAL.
http://www.microsoft.com/sql/howtobuy/faq.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim P" <TimP@.discussions.microsoft.com> wrote in message
news:409D6E35-21E7-4E12-BE01-32BAD2382BA1@.microsoft.com...
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
|||"Tim P" wrote:

> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
If you are hosting a publicly accessible website then you need to purchase a
Processor licence.
If you are hosting an intranet site where you can determine and control the
number of users then you have the option of Processor or CAL licensing. You
need one CAL per end-user or end-user device.
Licensing issues are often difficult and consfusing so if you have any
doubts consult a Microsoft rep or authorised dealer.
David Portas
SQL Server MVP
|||Ah, that makes sense.
Thanks guys!
"David Portas" wrote:

> "Tim P" wrote:
>
> If you are hosting a publicly accessible website then you need to purchase a
> Processor licence.
> If you are hosting an intranet site where you can determine and control the
> number of users then you have the option of Processor or CAL licensing. You
> need one CAL per end-user or end-user device.
> Licensing issues are often difficult and consfusing so if you have any
> doubts consult a Microsoft rep or authorised dealer.
> --
> David Portas
> SQL Server MVP
> --
>

CAL and POS software

I have a client that is migrating to SQL Server as the D/B for their POS software. The software uses a Pool Manager to exchange data with the D/B. The pool maintains 3 active connections to the D/B per module instance. The POS clients connect to the Po
ol Manager. Considering that their are only 3 connections to SQL per instance, and the POS clients connect to the Pool Manager instead of the SQL D/B, do each of the POS clients still require a CAL or would the server only require CALs to cover the maxim
um Pool D/B connections? Given 3 open modules, this would be a maximum of 9 connections which would require 9 CALs vs. 30. At around $150 per CAL, this could mean a cost difference of $2000 in a SQL+CAL vs. SQL Processor license. Although the obvious i
s to avoid the issue and go for the processor license, $2K is a significant chunk of my client's money in a typically strained budget.
This is what is known as multiplexing and it's explained in the SQL Server
2000 Pricing and Licensing white paper available at
http://www.microsoft.com/sql/howtobu...licensing.asp. The part that
pertains to you is:
MULTIPLEXING: USE OF MIDDLEWARE, TRANSACTION SERVERS, AND MULTI-TIERED
ARCHITECTURES
Sometimes organizations develop network scenarios that use various forms of
hardware and/or software that reduce the number of devices or users that
directly access or utilize the software on a particular server, often called
multiplexing or pooling hardware or software. For example, say a client PC
is using a server application that calls the Microsoft Transaction Server
(MTS) component of Microsoft Windows 2000 Server on one server, which in
turn pulls data from a Microsoft SQL Server database on another server. In
this case, the only direct connection to Microsoft SQL Server is coming from
the server running MTS. The client PC has a direct connection to the server
running MTS, but also has an indirect connection to SQL Server because it is
ultimately retrieving and using the SQL Server data through MTS. Use of such
multiplexing or pooling hardware and/or software does not reduce the number
of CALs required in order to access or utilize SQL Server software. A CAL is
required for each distinct device or user to the multiplexing or pooling
software or hardware front end. If, in the above example, 50 PCs were
connected to the MTS server, 50 SQL Server Device CALs would be required.
This is true no matter how many tiers of hardware or software exist between
the SQL Server and the client devices that ultimately use its data, services
or functionality.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"microchp" <anonymous@.discussions.microsoft.com> wrote in message
news:E090746F-3208-4042-9E35-0554766D6908@.microsoft.com...
> I have a client that is migrating to SQL Server as the D/B for their POS
software. The software uses a Pool Manager to exchange data with the D/B.
The pool maintains 3 active connections to the D/B per module instance. The
POS clients connect to the Pool Manager. Considering that their are only 3
connections to SQL per instance, and the POS clients connect to the Pool
Manager instead of the SQL D/B, do each of the POS clients still require a
CAL or would the server only require CALs to cover the maximum Pool D/B
connections? Given 3 open modules, this would be a maximum of 9 connections
which would require 9 CALs vs. 30. At around $150 per CAL, this could mean
a cost difference of $2000 in a SQL+CAL vs. SQL Processor license. Although
the obvious is to avoid the issue and go for the processor license, $2K is a
significant chunk of my client's money in a typically strained budget.