RSClientPrint error 0x8007F304

I thought I finally had everything in place to do clienside printing using
RSClientPrint. I even got the dialog box for installing the software at the
client. However, now when I call my java function to print, I get a error
printing number of 0x8007F304.
Does anyone recognize it? Can anyone help?
--
Thanks,
CGWAfter working with this a little more, I believe the problem occurs when
RSClientPrint.Print method is invoked for a report without that report being
opened first in the browser. I was hoping to bypass that, but RSClientPrint
doesn't seem inclined to allow that. Bummer.
--
Thanks,
CGW
"CGW" wrote:
> I thought I finally had everything in place to do clienside printing using
> RSClientPrint. I even got the dialog box for installing the software at the
> client. However, now when I call my java function to print, I get a error
> printing number of 0x8007F304.
> Does anyone recognize it? Can anyone help?
> --
> Thanks,
> CGW|||The control was not designed to work in this way. You will need to call the
SOAP APIs.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"CGW" <CGW@.discussions.microsoft.com> wrote in message
news:3E3F8389-4525-4130-A47A-76592F22E643@.microsoft.com...
> After working with this a little more, I believe the problem occurs when
> RSClientPrint.Print method is invoked for a report without that report
> being
> opened first in the browser. I was hoping to bypass that, but
> RSClientPrint
> doesn't seem inclined to allow that. Bummer.
> --
> Thanks,
> CGW
>
> "CGW" wrote:
>> I thought I finally had everything in place to do clienside printing
>> using
>> RSClientPrint. I even got the dialog box for installing the software at
>> the
>> client. However, now when I call my java function to print, I get a error
>> printing number of 0x8007F304.
>> Does anyone recognize it? Can anyone help?
>> --
>> Thanks,
>> CGW|||Thanks. I had about come to that conclusion. And I've never really used SOAP
APIs. I had about decided to use the rs utility and scripts to automate
morning reports. However, can you point me to a good intro to the RS SOAP
APIs and how to use them?
--
Thanks,
CGW
"Brian Welcker [MSFT]" wrote:
> The control was not designed to work in this way. You will need to call the
> SOAP APIs.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "CGW" <CGW@.discussions.microsoft.com> wrote in message
> news:3E3F8389-4525-4130-A47A-76592F22E643@.microsoft.com...
> > After working with this a little more, I believe the problem occurs when
> > RSClientPrint.Print method is invoked for a report without that report
> > being
> > opened first in the browser. I was hoping to bypass that, but
> > RSClientPrint
> > doesn't seem inclined to allow that. Bummer.
> > --
> > Thanks,
> >
> > CGW
> >
> >
> > "CGW" wrote:
> >
> >> I thought I finally had everything in place to do clienside printing
> >> using
> >> RSClientPrint. I even got the dialog box for installing the software at
> >> the
> >> client. However, now when I call my java function to print, I get a error
> >> printing number of 0x8007F304.
> >>
> >> Does anyone recognize it? Can anyone help?
> >>
> >> --
> >> Thanks,
> >>
> >> CGW
>
>|||By the way... Just how was the control designed to work? Since it accepts the
report name, parameters, server, etc, I made the assumption that client
printing could be accomplished through the use of the control alone.
--
Thanks,
CGW
"Brian Welcker [MSFT]" wrote:
> The control was not designed to work in this way. You will need to call the
> SOAP APIs.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "CGW" <CGW@.discussions.microsoft.com> wrote in message
> news:3E3F8389-4525-4130-A47A-76592F22E643@.microsoft.com...
> > After working with this a little more, I believe the problem occurs when
> > RSClientPrint.Print method is invoked for a report without that report
> > being
> > opened first in the browser. I was hoping to bypass that, but
> > RSClientPrint
> > doesn't seem inclined to allow that. Bummer.
> > --
> > Thanks,
> >
> > CGW
> >
> >
> > "CGW" wrote:
> >
> >> I thought I finally had everything in place to do clienside printing
> >> using
> >> RSClientPrint. I even got the dialog box for installing the software at
> >> the
> >> client. However, now when I call my java function to print, I get a error
> >> printing number of 0x8007F304.
> >>
> >> Does anyone recognize it? Can anyone help?
> >>
> >> --
> >> Thanks,
> >>
> >> CGW
>
>

rsactivate error - trying to install on 2003 with Sharepoint servi

I am trying to install SQL Reporting Services on a Windows Server 2003 box
that is running Sharepoint Services 2.0.
When you run the install you are warned that you will need to manually
initialize SQL Reporting because of Sharepoint and are referred to the
documentation. In the rssetup.chm there is an article entitled
"Troubleshooting a Side-by-Side Installation of Reporting Services and
Windows SharePoint Services". I followed these instructions, but when I get
to the last step where you run rsactivate, I get an error:
Failure starting the web service:
The service is already activated.
I did have reporting installed on this server once before but it was
uninstalled. I tried uninstalling reporting services when I got this error,
then tried again but I get the same result. I've been deleting the virtual
directories, the program files folder, and the databases before trying again.
I also noticed that two com + packages are left behind. If you don't remove
them the next installation adds two more. I removed all of them and tried
again but still the same result. I don't possess any knowledge of web
services so I'm not sure where to look next.
Can anyone help please?
--
-JeffWhat error message do you see when viewing http://localhost/reportserver?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> I am trying to install SQL Reporting Services on a Windows Server 2003 box
> that is running Sharepoint Services 2.0.
> When you run the install you are warned that you will need to manually
> initialize SQL Reporting because of Sharepoint and are referred to the
> documentation. In the rssetup.chm there is an article entitled
> "Troubleshooting a Side-by-Side Installation of Reporting Services and
> Windows SharePoint Services". I followed these instructions, but when I
get
> to the last step where you run rsactivate, I get an error:
> Failure starting the web service:
> The service is already activated.
> I did have reporting installed on this server once before but it was
> uninstalled. I tried uninstalling reporting services when I got this
error,
> then tried again but I get the same result. I've been deleting the
virtual
> directories, the program files folder, and the databases before trying
again.
> I also noticed that two com + packages are left behind. If you don't
remove
> them the next installation adds two more. I removed all of them and tried
> again but still the same result. I don't possess any knowledge of web
> services so I'm not sure where to look next.
> Can anyone help please?
> --
> -Jeff|||Reporting Services Erro
----
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help
Bad Data.
----
Microsoft Reporting Services
"Brian Hartman [MSFT]" wrote:
> What error message do you see when viewing http://localhost/reportserver?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > I am trying to install SQL Reporting Services on a Windows Server 2003 box
> > that is running Sharepoint Services 2.0.
> >
> > When you run the install you are warned that you will need to manually
> > initialize SQL Reporting because of Sharepoint and are referred to the
> > documentation. In the rssetup.chm there is an article entitled
> > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > Windows SharePoint Services". I followed these instructions, but when I
> get
> > to the last step where you run rsactivate, I get an error:
> >
> > Failure starting the web service:
> > The service is already activated.
> >
> > I did have reporting installed on this server once before but it was
> > uninstalled. I tried uninstalling reporting services when I got this
> error,
> > then tried again but I get the same result. I've been deleting the
> virtual
> > directories, the program files folder, and the databases before trying
> again.
> > I also noticed that two com + packages are left behind. If you don't
> remove
> > them the next installation adds two more. I removed all of them and tried
> > again but still the same result. I don't possess any knowledge of web
> > services so I'm not sure where to look next.
> >
> > Can anyone help please?
> >
> > --
> > -Jeff
>
>|||Try the following: rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> Reporting Services Error
> ----
--
> The report server cannot decrypt the symmetric key used to access
sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information. (rsReportServerDisabled) Get
> Online Help
> Bad Data.
> ----
--
> Microsoft Reporting Services
>
>
> "Brian Hartman [MSFT]" wrote:
> > What error message do you see when viewing
http://localhost/reportserver?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > I am trying to install SQL Reporting Services on a Windows Server 2003
box
> > > that is running Sharepoint Services 2.0.
> > >
> > > When you run the install you are warned that you will need to manually
> > > initialize SQL Reporting because of Sharepoint and are referred to the
> > > documentation. In the rssetup.chm there is an article entitled
> > > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > > Windows SharePoint Services". I followed these instructions, but when
I
> > get
> > > to the last step where you run rsactivate, I get an error:
> > >
> > > Failure starting the web service:
> > > The service is already activated.
> > >
> > > I did have reporting installed on this server once before but it was
> > > uninstalled. I tried uninstalling reporting services when I got this
> > error,
> > > then tried again but I get the same result. I've been deleting the
> > virtual
> > > directories, the program files folder, and the databases before trying
> > again.
> > > I also noticed that two com + packages are left behind. If you don't
> > remove
> > > them the next installation adds two more. I removed all of them and
tried
> > > again but still the same result. I don't possess any knowledge of web
> > > services so I'm not sure where to look next.
> > >
> > > Can anyone help please?
> > >
> > > --
> > > -Jeff
> >
> >
> >|||Excellent!!!! That did it. I could swear I'd already tried that and almost
replied with that, but I thought I should try again. I wonder if I tried
that before I deleted the extra com + packages. Is that possible? Do you
understand what happened here, because it would be nice to be able to explain
it to my co-workers?
Thanks so much,
-Jeff
"Brian Hartman [MSFT]" wrote:
> Try the following: rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> > Reporting Services Error
> > ----
> --
> >
> > The report server cannot decrypt the symmetric key used to access
> sensitive
> > or encrypted data in a report server database. You must either restore a
> > backup key or delete all encrypted content and then restart the service.
> > Check the documentation for more information. (rsReportServerDisabled) Get
> > Online Help
> > Bad Data.
> >
> > ----
> --
> > Microsoft Reporting Services
> >
> >
> >
> >
> > "Brian Hartman [MSFT]" wrote:
> >
> > > What error message do you see when viewing
> http://localhost/reportserver?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights
> > >
> > > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > > I am trying to install SQL Reporting Services on a Windows Server 2003
> box
> > > > that is running Sharepoint Services 2.0.
> > > >
> > > > When you run the install you are warned that you will need to manually
> > > > initialize SQL Reporting because of Sharepoint and are referred to the
> > > > documentation. In the rssetup.chm there is an article entitled
> > > > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > > > Windows SharePoint Services". I followed these instructions, but when
> I
> > > get
> > > > to the last step where you run rsactivate, I get an error:
> > > >
> > > > Failure starting the web service:
> > > > The service is already activated.
> > > >
> > > > I did have reporting installed on this server once before but it was
> > > > uninstalled. I tried uninstalling reporting services when I got this
> > > error,
> > > > then tried again but I get the same result. I've been deleting the
> > > virtual
> > > > directories, the program files folder, and the databases before trying
> > > again.
> > > > I also noticed that two com + packages are left behind. If you don't
> > > remove
> > > > them the next installation adds two more. I removed all of them and
> tried
> > > > again but still the same result. I don't possess any knowledge of web
> > > > services so I'm not sure where to look next.
> > > >
> > > > Can anyone help please?
> > > >
> > > > --
> > > > -Jeff
> > >
> > >
> > >
>
>|||I don't think the COM+ changes had anything to do with this. At some point,
you ran or installed something that reset the password on your ASPNet
account. Installing a version of the .Net framework will do this. So will
running aspnet_regiis. When the password is reset (reset = changed without
supplying the original one) on an account, the decryption keys associated
with that account are lost. There is probably an event in your windows
event log that indicates this happened.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:61D89FDE-0F89-4319-AB1A-F7D8C1462E07@.microsoft.com...
> Excellent!!!! That did it. I could swear I'd already tried that and
almost
> replied with that, but I thought I should try again. I wonder if I tried
> that before I deleted the extra com + packages. Is that possible? Do you
> understand what happened here, because it would be nice to be able to
explain
> it to my co-workers?
> Thanks so much,
> -Jeff
> "Brian Hartman [MSFT]" wrote:
> > Try the following: rsactivate -r -c <config file>
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> > > Reporting Services Error
> >
> ----
> > --
> > >
> > > The report server cannot decrypt the symmetric key used to access
> > sensitive
> > > or encrypted data in a report server database. You must either restore
a
> > > backup key or delete all encrypted content and then restart the
service.
> > > Check the documentation for more information. (rsReportServerDisabled)
Get
> > > Online Help
> > > Bad Data.
> > >
> >
> ----
> > --
> > > Microsoft Reporting Services
> > >
> > >
> > >
> > >
> > > "Brian Hartman [MSFT]" wrote:
> > >
> > > > What error message do you see when viewing
> > http://localhost/reportserver?
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights
> > > >
> > > > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in
message
> > > > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > > > I am trying to install SQL Reporting Services on a Windows Server
2003
> > box
> > > > > that is running Sharepoint Services 2.0.
> > > > >
> > > > > When you run the install you are warned that you will need to
manually
> > > > > initialize SQL Reporting because of Sharepoint and are referred to
the
> > > > > documentation. In the rssetup.chm there is an article entitled
> > > > > "Troubleshooting a Side-by-Side Installation of Reporting Services
and
> > > > > Windows SharePoint Services". I followed these instructions, but
when
> > I
> > > > get
> > > > > to the last step where you run rsactivate, I get an error:
> > > > >
> > > > > Failure starting the web service:
> > > > > The service is already activated.
> > > > >
> > > > > I did have reporting installed on this server once before but it
was
> > > > > uninstalled. I tried uninstalling reporting services when I got
this
> > > > error,
> > > > > then tried again but I get the same result. I've been deleting
the
> > > > virtual
> > > > > directories, the program files folder, and the databases before
trying
> > > > again.
> > > > > I also noticed that two com + packages are left behind. If you
don't
> > > > remove
> > > > > them the next installation adds two more. I removed all of them
and
> > tried
> > > > > again but still the same result. I don't possess any knowledge of
web
> > > > > services so I'm not sure where to look next.
> > > > >
> > > > > Can anyone help please?
> > > > >
> > > > > --
> > > > > -Jeff
> > > >
> > > >
> > > >
> >
> >
> >|||On the start menu go to microsoft sqlserver then to reporting services
and open the help. click in installing notification services and you
will find the pathes there.

RS2005 Report Distribution + License

I understand the licensing part where installing the on the same server is
free and if you move RS to another box a license is required.
1. Is it recommended to separate the DB from RS? I assume it will depend
on the report load but for now I can say only RS, DB, and IIS would be on the
box.
2. Are there any costs for delivering (emailing) reports to external
customers or having external users view and download reports through the web?
Also, does anyone know if Crystal Reports Server XI has a fee for this? I
am trying to compare the costs for each.
ThanksNo costs for emailing.
Have external users view it, then you need to check out the SQL Server
licensing for internet use. I know that licensing is different than for an
intranet.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mc" <mc@.discussions.microsoft.com> wrote in message
news:52FFEB45-5674-4383-870B-E36FCA5812A9@.microsoft.com...
>I understand the licensing part where installing the on the same server is
> free and if you move RS to another box a license is required.
> 1. Is it recommended to separate the DB from RS? I assume it will depend
> on the report load but for now I can say only RS, DB, and IIS would be on
> the
> box.
> 2. Are there any costs for delivering (emailing) reports to external
> customers or having external users view and download reports through the
> web?
> Also, does anyone know if Crystal Reports Server XI has a fee for this? I
> am trying to compare the costs for each.
> Thanks|||Do you have link for that or are you referring to a processor license opposed
to user and device cal's
Thanks for the response
"Bruce L-C [MVP]" wrote:
> No costs for emailing.
> Have external users view it, then you need to check out the SQL Server
> licensing for internet use. I know that licensing is different than for an
> intranet.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:52FFEB45-5674-4383-870B-E36FCA5812A9@.microsoft.com...
> >I understand the licensing part where installing the on the same server is
> > free and if you move RS to another box a license is required.
> >
> > 1. Is it recommended to separate the DB from RS? I assume it will depend
> > on the report load but for now I can say only RS, DB, and IIS would be on
> > the
> > box.
> >
> > 2. Are there any costs for delivering (emailing) reports to external
> > customers or having external users view and download reports through the
> > web?
> > Also, does anyone know if Crystal Reports Server XI has a fee for this? I
> > am trying to compare the costs for each.
> >
> > Thanks
>
>|||Right, the processor license for use of SQL Server over the internet. RS
licensing is SQL Server licensing. Wherever RS is installed you have to have
the exact same license as if you had a SQL Server DB on the box.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mc" <mc@.discussions.microsoft.com> wrote in message
news:7CD2D763-A49F-48AC-A88D-FF33402FA179@.microsoft.com...
> Do you have link for that or are you referring to a processor license
> opposed
> to user and device cal's
> Thanks for the response
>
> "Bruce L-C [MVP]" wrote:
>> No costs for emailing.
>> Have external users view it, then you need to check out the SQL Server
>> licensing for internet use. I know that licensing is different than for
>> an
>> intranet.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:52FFEB45-5674-4383-870B-E36FCA5812A9@.microsoft.com...
>> >I understand the licensing part where installing the on the same server
>> >is
>> > free and if you move RS to another box a license is required.
>> >
>> > 1. Is it recommended to separate the DB from RS? I assume it will
>> > depend
>> > on the report load but for now I can say only RS, DB, and IIS would be
>> > on
>> > the
>> > box.
>> >
>> > 2. Are there any costs for delivering (emailing) reports to external
>> > customers or having external users view and download reports through
>> > the
>> > web?
>> > Also, does anyone know if Crystal Reports Server XI has a fee for this?
>> > I
>> > am trying to compare the costs for each.
>> >
>> > Thanks
>>|||Do you know the price associated with a processor license?
"Bruce L-C [MVP]" wrote:
> Right, the processor license for use of SQL Server over the internet. RS
> licensing is SQL Server licensing. Wherever RS is installed you have to have
> the exact same license as if you had a SQL Server DB on the box.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:7CD2D763-A49F-48AC-A88D-FF33402FA179@.microsoft.com...
> > Do you have link for that or are you referring to a processor license
> > opposed
> > to user and device cal's
> >
> > Thanks for the response
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No costs for emailing.
> >>
> >> Have external users view it, then you need to check out the SQL Server
> >> licensing for internet use. I know that licensing is different than for
> >> an
> >> intranet.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:52FFEB45-5674-4383-870B-E36FCA5812A9@.microsoft.com...
> >> >I understand the licensing part where installing the on the same server
> >> >is
> >> > free and if you move RS to another box a license is required.
> >> >
> >> > 1. Is it recommended to separate the DB from RS? I assume it will
> >> > depend
> >> > on the report load but for now I can say only RS, DB, and IIS would be
> >> > on
> >> > the
> >> > box.
> >> >
> >> > 2. Are there any costs for delivering (emailing) reports to external
> >> > customers or having external users view and download reports through
> >> > the
> >> > web?
> >> > Also, does anyone know if Crystal Reports Server XI has a fee for this?
> >> > I
> >> > am trying to compare the costs for each.
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>|||No. I just know the theory. I know that a per processor used on an intranet
is different than per process for intranet.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mc" <mc@.discussions.microsoft.com> wrote in message
news:7BCCB8E9-EC69-4A24-9EB7-26FEA1F9BA29@.microsoft.com...
> Do you know the price associated with a processor license?
>
> "Bruce L-C [MVP]" wrote:
>> Right, the processor license for use of SQL Server over the internet. RS
>> licensing is SQL Server licensing. Wherever RS is installed you have to
>> have
>> the exact same license as if you had a SQL Server DB on the box.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:7CD2D763-A49F-48AC-A88D-FF33402FA179@.microsoft.com...
>> > Do you have link for that or are you referring to a processor license
>> > opposed
>> > to user and device cal's
>> >
>> > Thanks for the response
>> >
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> No costs for emailing.
>> >>
>> >> Have external users view it, then you need to check out the SQL Server
>> >> licensing for internet use. I know that licensing is different than
>> >> for
>> >> an
>> >> intranet.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> news:52FFEB45-5674-4383-870B-E36FCA5812A9@.microsoft.com...
>> >> >I understand the licensing part where installing the on the same
>> >> >server
>> >> >is
>> >> > free and if you move RS to another box a license is required.
>> >> >
>> >> > 1. Is it recommended to separate the DB from RS? I assume it will
>> >> > depend
>> >> > on the report load but for now I can say only RS, DB, and IIS would
>> >> > be
>> >> > on
>> >> > the
>> >> > box.
>> >> >
>> >> > 2. Are there any costs for delivering (emailing) reports to
>> >> > external
>> >> > customers or having external users view and download reports through
>> >> > the
>> >> > web?
>> >> > Also, does anyone know if Crystal Reports Server XI has a fee for
>> >> > this?
>> >> > I
>> >> > am trying to compare the costs for each.
>> >> >
>> >> > Thanks
>> >>
>> >>
>> >>
>>|||Thanks for the help Bruce.
On a side note, could you provide any feedback to these questions
1) Is it possible to create a report template containing text that would
be evaluated at runtime by a sql query? For example, the text in my
reports need to cater to various languages so report template would be
generic. Can I configure text (textboxes) to do a lookup at runtime?
2) How flexible are the graphing capabilities? Can a third party
package be used to create graphs as long as the rdl file is constructed
properly? I interested in how dynamic you can make the values on the graph.
3) Does RS provide a good audit mechanism for logging and tracking reports?
Thanks - mike
"Bruce L-C [MVP]" wrote:
> No. I just know the theory. I know that a per processor used on an intranet
> is different than per process for intranet.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:7BCCB8E9-EC69-4A24-9EB7-26FEA1F9BA29@.microsoft.com...
> > Do you know the price associated with a processor license?
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Right, the processor license for use of SQL Server over the internet. RS
> >> licensing is SQL Server licensing. Wherever RS is installed you have to
> >> have
> >> the exact same license as if you had a SQL Server DB on the box.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:7CD2D763-A49F-48AC-A88D-FF33402FA179@.microsoft.com...
> >> > Do you have link for that or are you referring to a processor license
> >> > opposed
> >> > to user and device cal's
> >> >
> >> > Thanks for the response
> >> >
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> No costs for emailing.
> >> >>
> >> >> Have external users view it, then you need to check out the SQL Server
> >> >> licensing for internet use. I know that licensing is different than
> >> >> for
> >> >> an
> >> >> intranet.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> news:52FFEB45-5674-4383-870B-E36FCA5812A9@.microsoft.com...
> >> >> >I understand the licensing part where installing the on the same
> >> >> >server
> >> >> >is
> >> >> > free and if you move RS to another box a license is required.
> >> >> >
> >> >> > 1. Is it recommended to separate the DB from RS? I assume it will
> >> >> > depend
> >> >> > on the report load but for now I can say only RS, DB, and IIS would
> >> >> > be
> >> >> > on
> >> >> > the
> >> >> > box.
> >> >> >
> >> >> > 2. Are there any costs for delivering (emailing) reports to
> >> >> > external
> >> >> > customers or having external users view and download reports through
> >> >> > the
> >> >> > web?
> >> >> > Also, does anyone know if Crystal Reports Server XI has a fee for
> >> >> > this?
> >> >> > I
> >> >> > am trying to compare the costs for each.
> >> >> >
> >> >> > Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>sql

RS2005 on SQL Server 2000 backend database

We are currently thinking about installing Reporting Services 2005 on a SQL
Server 2000 database box and allow the RS2005 instance use a SQL Server 2000
database. Are there any reasons on why we shouldn't do this?No problem whatsoever. Fully supported (I ran this way for months). Note,
you do need a SQL Server 2005 license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:F169BCBE-9784-48E9-BCA2-CEAC19211E90@.microsoft.com...
> We are currently thinking about installing Reporting Services 2005 on a
> SQL
> Server 2000 database box and allow the RS2005 instance use a SQL Server
> 2000
> database. Are there any reasons on why we shouldn't do this?|||Bruce;
I need a clarification for this.. he needs one SQL 2000 license and one
SQL 2005 license
-Aaron
Bruce L-C [MVP] wrote:
> No problem whatsoever. Fully supported (I ran this way for months). Note,
> you do need a SQL Server 2005 license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "David" <dilworth@.newsgroups.nospam> wrote in message
> news:F169BCBE-9784-48E9-BCA2-CEAC19211E90@.microsoft.com...
> > We are currently thinking about installing Reporting Services 2005 on a
> > SQL
> > Server 2000 database box and allow the RS2005 instance use a SQL Server
> > 2000
> > database. Are there any reasons on why we shouldn't do this?|||Thanks for Bruce,'s input.
Hi David,
As Bruce has mentioned, you can use both SQL Server 2000 and SQL server
2005 database as your SSRS 2005's backend database storage, this won't
affect the functionality of Reporting service since the backend database
only stores some data and settings of the Reporting service, all the
built-in components are still referenced from the SSRS 2005's installation.
Here is blog article also describes how to do this:
#Using SQL 2000 for SSRS 2005 metadata storage
http://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.sql

RS OLAP Connection Problem

I have a stand alone win2k3 reporting services server(i.e. SQL is not on the
box). RS SP1 is installed.
I have a SQLRS report developed in visual studio (on the same box) that runs
MDX against an analysis services cube. I am using the OLE DB provider for
OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
services server to get the pivot table service and 8.0 provider to be
available)
I can successfully connect to Analysis Services and preview the report in
visual studio.
When I run the report in Report Manger, the report bombs with...
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'ServerNameBlahBlah'.
(rsErrorOpeningConnection) Get Online Help
Database 'CubeNameBlahBlah' does not exist.
I have a AS database role setup that should allow the stored
credentials to successfully authenticate.
HELP !!!!That is what you get when you don't have rights to the AS datasource. Open
Visual Studio Report Designer by right-clicking and choosing "Run as" and
choose the same credentials you are using as stored credentials for the AS
datasource. See if you can then preview the report, you will probably get a
similar error.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"James" <carbonc@.carbonc.com> wrote in message
news:e8X%231pbJFHA.3928@.TK2MSFTNGP09.phx.gbl...
>I have a stand alone win2k3 reporting services server(i.e. SQL is not on
>the
> box). RS SP1 is installed.
> I have a SQLRS report developed in visual studio (on the same box) that
> runs
> MDX against an analysis services cube. I am using the OLE DB provider for
> OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
> services server to get the pivot table service and 8.0 provider to be
> available)
> I can successfully connect to Analysis Services and preview the report in
> visual studio.
> When I run the report in Report Manger, the report bombs with...
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'ServerNameBlahBlah'.
> (rsErrorOpeningConnection) Get Online Help
> Database 'CubeNameBlahBlah' does not exist.
> I have a AS database role setup that should allow the stored
> credentials to successfully authenticate.
>
> HELP !!!!
>

RS Authoring over the Internet

It appears that to enable true authoring over the internet, you need to
create local users on the RS/IIS box, and create identical SQL logins so
remote users can build their DSN's for their reports.
Other ideas?
JeffFor one, use AD groups in SQL.|||Nope, doesn't work. Just tried it again to verify. I created a local user on
the box, added him to a local group, created a login for the group, and
added the login to the database role.
When trying to connect over the internet using ISQLW for example, I get
"login failed for user 'erstesting'". Native SQL logins work just fine.
Jeff
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410131248.5c092472@.posting.google.com...
> For one, use AD groups in SQL.

RS 2005 with remote catalog on SQL 2000?

We currently have a box running with RS 2000 and a separate box running SQL
2000 containing our report catalog.
Is it possbile to have a mixed mode? The box our catalog is stored on is on
a huge cluster and we are not prepared to migrate it yet.Yes. This is supported and expected. I am currently running RS 2005 on a SQL
Server 2000 db.
Note that the box that has your RS needs to have a 2005 license.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott - LBI" <Scott - LBI@.discussions.microsoft.com> wrote in message
news:276398B2-743D-489E-BB27-2DD68CB8FE98@.microsoft.com...
> We currently have a box running with RS 2000 and a separate box running
> SQL
> 2000 containing our report catalog.
> Is it possbile to have a mixed mode? The box our catalog is stored on is
> on
> a huge cluster and we are not prepared to migrate it yet.

RS 2005 using SQL Server 2000 as a repository?

Hi - If I want a Reporting Services 2005 installation in which the repository
is on a *different* box than the RS services, can the repository database be
SQL Server 2000 rather than SQL Server 2005?
Thanks and regards,Yes. As a matter of fact it can be on the same box (mine is). You do need a
2005 license for the box that has RS 2005 installed. In your case a 2005
license for the box with RS services and the metadata box can stay at 2000
without a license for 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:1D8C637A-2E76-487F-B006-0F6012B08EDE@.microsoft.com...
> Hi - If I want a Reporting Services 2005 installation in which the
> repository
> is on a *different* box than the RS services, can the repository database
> be
> SQL Server 2000 rather than SQL Server 2005?
> Thanks and regards,|||Hi Bruce, thanks a lot for the quick response.
Regards
"Bruce L-C [MVP]" wrote:
> Yes. As a matter of fact it can be on the same box (mine is). You do need a
> 2005 license for the box that has RS 2005 installed. In your case a 2005
> license for the box with RS services and the metadata box can stay at 2000
> without a license for 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:1D8C637A-2E76-487F-B006-0F6012B08EDE@.microsoft.com...
> > Hi - If I want a Reporting Services 2005 installation in which the
> > repository
> > is on a *different* box than the RS services, can the repository database
> > be
> > SQL Server 2000 rather than SQL Server 2005?
> >
> > Thanks and regards,
>
>