New to Reporting Services

We have a license for SQL Server Enterprise.The license is per processor.We plan to use Reporting Services. I was wondering if there is going to be a limitation for the number of the users that can use this. Similar with Crystal asking for license for more than 5 concurrent users.
We'll access Reporting Services from a web site.Unfortunately the web site is plain ASP.Is there any way I can use Reporting Service(maybe the web service) from plain ASP, or should I think about a way to integrate an ASP.NET page?
The report is generated based on some data the users are entering, and is not related in any way to any database, can I push some xml from my page to the Reporting Service?
Do I need to have a SSL certificate to use Reporting Services?
Can I just download Reporting Services from Microsoft, or is it available only on a CD? We are somehow in a hurry, I don't have too much time to wait for CD's.
Thanks,
IoanaThe requirements for SQL Server Reporting Services are listed herehttp://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx you will see that the server needs the .NET framework. When that is setup ASP applications should be able to call the reports with a URL or you can use the web service that is part of it.
To my knowledge there is no limit for the number of concurrent Reporting Services users.
An SSL certificate isn't essential but is advisable.
You can download the demonstration which should get you going until you get the CD
Steve|||Thank you Steve.That answers all my questions.:o)

New Instance

I'd like to install a named instance of SQL server, if this is just for
testing in the dev lab do I still need to have a license for it?
In the prod version I have one instance with several databases can I give
another DBA rights to view and admin only one database of that list. How do
I restrict the other DBA from viewing other databases?
ThanksHi
This seems to be something I am never 100% sure about, so it would be better
to clarify it with you software provider. I think the answer depends on how
you have licenced your current copy and what version it is:
For Server + User Cal licencing
http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. Installation-Server Software. You may install and use one copy of the
Server Software on a single Server. SQL Server Enterprise Edition. If
you have acquired the Enterprise Edition of the Server Software, you may
install any number of instances of the Server Software on
that Server. An "instance" shall mean a running copy of the Server Software.
Client Software. You may install the Client Software (SQL
Server Personal Edition) on any internal Device.
Server + Device cals seems to be similar to User Cal
http://www.microsoft.com/sql/howtobuy/servercal.asp
For processor licencing http://www.microsoft.com/sql/howtobuy/processor.asp:
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. License Structure. The Server Software is licensed on an individual
processor basis. You need one Server Software license for each of
your Server's processors. As an exception to that rule, if you have made a
processor inaccessible to all operating system copies on
which the Server Software is set up to run, you do not need a Server
Software license for that processor. Examples of processors that
you have made inaccessible to operating system copies are processors that
you have isolated by partitioning or other similar method.
You do not need more than one Server Software license for any processor.
b. Server Software. You may install and run any number of copies of the
Server Software on a single Server. You may use the
Management Tools, Books-Online, and Development Tools components of
Microsoft SQL Server (collectively "Tools") solely for
internal use in conjunction with your Server Software.
This would imply you can have multiple instances.
HTH
John
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> I'd like to install a named instance of SQL server, if this is just for
> testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I give
> another DBA rights to view and admin only one database of that list. How
> do
> I restrict the other DBA from viewing other databases?
> Thanks|||Niles wrote:
> I'd like to install a named instance of SQL server, if this is just
> for testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I
> give another DBA rights to view and admin only one database of that
> list. How do I restrict the other DBA from viewing other databases?
> Thanks
They can still "see" the other database names, but you can assign them
access to only the database they are supposed to maintain.
--
David Gugick
Imceda Software
www.imceda.com|||Per Server Licensing, you need additional Server License.
Per CPU, no additional licensing is required as long as you are properly
licenses for each CPU in the machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ONsggru4EHA.1300@.TK2MSFTNGP14.phx.gbl...
> Hi
> This seems to be something I am never 100% sure about, so it would be
better
> to clarify it with you software provider. I think the answer depends on
how
> you have licenced your current copy and what version it is:
> For Server + User Cal licencing
> http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. Installation-Server Software. You may install and use one copy of the
> Server Software on a single Server. SQL Server Enterprise Edition. If
> you have acquired the Enterprise Edition of the Server Software, you may
> install any number of instances of the Server Software on
> that Server. An "instance" shall mean a running copy of the Server
Software.
> Client Software. You may install the Client Software (SQL
> Server Personal Edition) on any internal Device.
> Server + Device cals seems to be similar to User Cal
> http://www.microsoft.com/sql/howtobuy/servercal.asp
> For processor licencing
http://www.microsoft.com/sql/howtobuy/processor.asp:
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. License Structure. The Server Software is licensed on an individual
> processor basis. You need one Server Software license for each of
> your Server's processors. As an exception to that rule, if you have made a
> processor inaccessible to all operating system copies on
> which the Server Software is set up to run, you do not need a Server
> Software license for that processor. Examples of processors that
> you have made inaccessible to operating system copies are processors that
> you have isolated by partitioning or other similar method.
> You do not need more than one Server Software license for any processor.
> b. Server Software. You may install and run any number of copies of the
> Server Software on a single Server. You may use the
> Management Tools, Books-Online, and Development Tools components of
> Microsoft SQL Server (collectively "Tools") solely for
> internal use in conjunction with your Server Software.
> This would imply you can have multiple instances.
> HTH
> John
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> > I'd like to install a named instance of SQL server, if this is just for
> > testing in the dev lab do I still need to have a license for it?
> >
> > In the prod version I have one instance with several databases can I
give
> > another DBA rights to view and admin only one database of that list.
How
> > do
> > I restrict the other DBA from viewing other databases?
> >
> > Thanks
>|||I haven't tested this yet but If I put a database under a named instance can
I then give them access to that instance only?
Thanks
"David Gugick" wrote:
> Niles wrote:
> > I'd like to install a named instance of SQL server, if this is just
> > for testing in the dev lab do I still need to have a license for it?
> >
> > In the prod version I have one instance with several databases can I
> > give another DBA rights to view and admin only one database of that
> > list. How do I restrict the other DBA from viewing other databases?
> >
> > Thanks
> They can still "see" the other database names, but you can assign them
> access to only the database they are supposed to maintain.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

New Instance

I'd like to install a named instance of SQL server, if this is just for
testing in the dev lab do I still need to have a license for it?
In the prod version I have one instance with several databases can I give
another DBA rights to view and admin only one database of that list. How do
I restrict the other DBA from viewing other databases?
Thanks
Hi
This seems to be something I am never 100% sure about, so it would be better
to clarify it with you software provider. I think the answer depends on how
you have licenced your current copy and what version it is:
For Server + User Cal licencing
http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. Installation-Server Software. You may install and use one copy of the
Server Software on a single Server. SQL Server Enterprise Edition. If
you have acquired the Enterprise Edition of the Server Software, you may
install any number of instances of the Server Software on
that Server. An "instance" shall mean a running copy of the Server Software.
Client Software. You may install the Client Software (SQL
Server Personal Edition) on any internal Device.
Server + Device cals seems to be similar to User Cal
http://www.microsoft.com/sql/howtobuy/servercal.asp
For processor licencing http://www.microsoft.com/sql/howtobuy/processor.asp:
1. GRANT OF LICENSE. Microsoft grants you the following rights, provided you
comply with all terms and conditions of this EULA:
a. License Structure. The Server Software is licensed on an individual
processor basis. You need one Server Software license for each of
your Server's processors. As an exception to that rule, if you have made a
processor inaccessible to all operating system copies on
which the Server Software is set up to run, you do not need a Server
Software license for that processor. Examples of processors that
you have made inaccessible to operating system copies are processors that
you have isolated by partitioning or other similar method.
You do not need more than one Server Software license for any processor.
b. Server Software. You may install and run any number of copies of the
Server Software on a single Server. You may use the
Management Tools, Books-Online, and Development Tools components of
Microsoft SQL Server (collectively "Tools") solely for
internal use in conjunction with your Server Software.
This would imply you can have multiple instances.
HTH
John
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
> I'd like to install a named instance of SQL server, if this is just for
> testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I give
> another DBA rights to view and admin only one database of that list. How
> do
> I restrict the other DBA from viewing other databases?
> Thanks
|||Niles wrote:
> I'd like to install a named instance of SQL server, if this is just
> for testing in the dev lab do I still need to have a license for it?
> In the prod version I have one instance with several databases can I
> give another DBA rights to view and admin only one database of that
> list. How do I restrict the other DBA from viewing other databases?
> Thanks
They can still "see" the other database names, but you can assign them
access to only the database they are supposed to maintain.
David Gugick
Imceda Software
www.imceda.com
|||Per Server Licensing, you need additional Server License.
Per CPU, no additional licensing is required as long as you are properly
licenses for each CPU in the machine.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ONsggru4EHA.1300@.TK2MSFTNGP14.phx.gbl...
> Hi
> This seems to be something I am never 100% sure about, so it would be
better
> to clarify it with you software provider. I think the answer depends on
how
> you have licenced your current copy and what version it is:
> For Server + User Cal licencing
> http://www.microsoft.com/sql/howtobuy/serverpluscal.asp
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you
> comply with all terms and conditions of this EULA:
> a. Installation-Server Software. You may install and use one copy of the
> Server Software on a single Server. SQL Server Enterprise Edition. If
> you have acquired the Enterprise Edition of the Server Software, you may
> install any number of instances of the Server Software on
> that Server. An "instance" shall mean a running copy of the Server
Software.
> Client Software. You may install the Client Software (SQL
> Server Personal Edition) on any internal Device.
> Server + Device cals seems to be similar to User Cal
> http://www.microsoft.com/sql/howtobuy/servercal.asp
> For processor licencing
http://www.microsoft.com/sql/howtobuy/processor.asp:
> 1. GRANT OF LICENSE. Microsoft grants you the following rights, provided
you[vbcol=seagreen]
> comply with all terms and conditions of this EULA:
> a. License Structure. The Server Software is licensed on an individual
> processor basis. You need one Server Software license for each of
> your Server's processors. As an exception to that rule, if you have made a
> processor inaccessible to all operating system copies on
> which the Server Software is set up to run, you do not need a Server
> Software license for that processor. Examples of processors that
> you have made inaccessible to operating system copies are processors that
> you have isolated by partitioning or other similar method.
> You do not need more than one Server Software license for any processor.
> b. Server Software. You may install and run any number of copies of the
> Server Software on a single Server. You may use the
> Management Tools, Books-Online, and Development Tools components of
> Microsoft SQL Server (collectively "Tools") solely for
> internal use in conjunction with your Server Software.
> This would imply you can have multiple instances.
> HTH
> John
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:E2B9F076-111F-40F6-95CC-6266A19907C5@.microsoft.com...
give[vbcol=seagreen]
How
>
|||I haven't tested this yet but If I put a database under a named instance can
I then give them access to that instance only?
Thanks
"David Gugick" wrote:

> Niles wrote:
> They can still "see" the other database names, but you can assign them
> access to only the database they are supposed to maintain.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>