Choosing a Licensing Mode

Hello, all. We have a question as to the licensing mode of Reporting
Services for SQL Server 2K. We wish to install according to the following
scheme,
- Report Server: on our web server (ws1)
- Report Manager: on our web server (ws1)
- Report Server Database: on our SQL Server db (sql1)
- Report Designer: on our workstations
Reading what is on this page
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx,
it says that "You must have a valid SQL Server license for each computer
that has a SQL Server 2000 component (such as Reporting Services) installed.
For example, the computer running Reporting Services requires a SQL Server
license. If the report server database is located remotely, a separate
license is required for the remote computer running SQL Server."
Does this mean that we must have a separate SQL Server license for our ws1
machine to be able to run Report Server and Report Manager than the license
we have on our sql1 machine? Thanks in advance :-)The following is general guidance, I'm not an expert on licensing so what I
say definitely does not 'go'. I recommend you speak with your TAM/Sales rep
to ensure you're correctly licensed based on your deployment, hardware, etc.
In general, you need a SQL licence for each computer on which you deploy
server components. Thus, if you deploy report server on computer A and your
SQL engine is on computer B, you need to have a SQL licence for of A and
another for B, totalling 2 processor licenses.
Thyen if you have multi-proc machines, it gets interesting. Speak with
your TAM/Sales rep.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"dw" <cougarmana_NOSPAM@.uncw.edu> wrote in message
news:e9KNnVZbEHA.1644@.tk2msftngp13.phx.gbl...
> Hello, all. We have a question as to the licensing mode of Reporting
> Services for SQL Server 2K. We wish to install according to the following
> scheme,
> - Report Server: on our web server (ws1)
> - Report Manager: on our web server (ws1)
> - Report Server Database: on our SQL Server db (sql1)
> - Report Designer: on our workstations
> Reading what is on this page
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx,
> it says that "You must have a valid SQL Server license for each computer
> that has a SQL Server 2000 component (such as Reporting Services)
> installed.
> For example, the computer running Reporting Services requires a SQL Server
> license. If the report server database is located remotely, a separate
> license is required for the remote computer running SQL Server."
> Does this mean that we must have a separate SQL Server license for our ws1
> machine to be able to run Report Server and Report Manager than the
> license
> we have on our sql1 machine? Thanks in advance :-)
>|||Thanks Lukasz. That's what I was afraid of.
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
news:esiORlcbEHA.2340@.TK2MSFTNGP10.phx.gbl...
> The following is general guidance, I'm not an expert on licensing so what
I
> say definitely does not 'go'. I recommend you speak with your TAM/Sales
rep
> to ensure you're correctly licensed based on your deployment, hardware,
etc.
> In general, you need a SQL licence for each computer on which you deploy
> server components. Thus, if you deploy report server on computer A and
your
> SQL engine is on computer B, you need to have a SQL licence for of A and
> another for B, totalling 2 processor licenses.
> Thyen if you have multi-proc machines, it gets interesting. Speak with
> your TAM/Sales rep.
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "dw" <cougarmana_NOSPAM@.uncw.edu> wrote in message
> news:e9KNnVZbEHA.1644@.tk2msftngp13.phx.gbl...
> > Hello, all. We have a question as to the licensing mode of Reporting
> > Services for SQL Server 2K. We wish to install according to the
following
> > scheme,
> >
> > - Report Server: on our web server (ws1)
> > - Report Manager: on our web server (ws1)
> > - Report Server Database: on our SQL Server db (sql1)
> > - Report Designer: on our workstations
> >
> > Reading what is on this page
> >
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx,
> > it says that "You must have a valid SQL Server license for each computer
> > that has a SQL Server 2000 component (such as Reporting Services)
> > installed.
> > For example, the computer running Reporting Services requires a SQL
Server
> > license. If the report server database is located remotely, a separate
> > license is required for the remote computer running SQL Server."
> >
> > Does this mean that we must have a separate SQL Server license for our
ws1
> > machine to be able to run Report Server and Report Manager than the
> > license
> > we have on our sql1 machine? Thanks in advance :-)
> >
> >
>

Checking Database Recovery Mode

Hi,
How can I find out what the current recovery mode of a database is?
I know that I can set it with ALTER DATABASE command but I don't know how to
check to see what the current mode is. Could you please someone help me?
I didn't find anything in sysdatabases table.
Thank you,
RosieTry:
SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
Hope this helps.
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> Hi,
> How can I find out what the current recovery mode of a database is?
> I know that I can set it with ALTER DATABASE command but I don't know how
> to
> check to see what the current mode is. Could you please someone help me?
> I didn't find anything in sysdatabases table.
> Thank you,
> Rosie
>|||Great! Thank you for your help.
Rosie
"Dan Guzman" wrote:

> Try:
> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
>
>|||I'm glad I was able to help.
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:685AF33B-8EBC-4BE5-9D15-556A1712A1CD@.microsoft.com...[vbcol=seagreen]
> Great! Thank you for your help.
> Rosie
> "Dan Guzman" wrote:
>

Checking Database Recovery Mode

Hi,
How can I find out what the current recovery mode of a database is?
I know that I can set it with ALTER DATABASE command but I don't know how to
check to see what the current mode is. Could you please someone help me?
I didn't find anything in sysdatabases table.
Thank you,
RosieTry:
SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> Hi,
> How can I find out what the current recovery mode of a database is?
> I know that I can set it with ALTER DATABASE command but I don't know how
> to
> check to see what the current mode is. Could you please someone help me?
> I didn't find anything in sysdatabases table.
> Thank you,
> Rosie
>|||Great! Thank you for your help.
Rosie
"Dan Guzman" wrote:
> Try:
> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> > Hi,
> >
> > How can I find out what the current recovery mode of a database is?
> >
> > I know that I can set it with ALTER DATABASE command but I don't know how
> > to
> > check to see what the current mode is. Could you please someone help me?
> >
> > I didn't find anything in sysdatabases table.
> >
> > Thank you,
> > Rosie
> >
>
>|||I'm glad I was able to help.
--
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:685AF33B-8EBC-4BE5-9D15-556A1712A1CD@.microsoft.com...
> Great! Thank you for your help.
> Rosie
> "Dan Guzman" wrote:
>> Try:
>> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
>> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
>> > Hi,
>> >
>> > How can I find out what the current recovery mode of a database is?
>> >
>> > I know that I can set it with ALTER DATABASE command but I don't know
>> > how
>> > to
>> > check to see what the current mode is. Could you please someone help
>> > me?
>> >
>> > I didn't find anything in sysdatabases table.
>> >
>> > Thank you,
>> > Rosie
>> >
>>