Showing posts with label dear. Show all posts
Showing posts with label dear. Show all posts

Friday, March 23, 2012

RS2005's own SPs to add users to RS

Dear Anyone,

Is it possible to use Reporting Services' own stored procedure to add users directly into RS's security roles?

Thanks,

Joseph

Direct access to the RS catalog is not supported. Is there a reason why SOAP APIs are not enough?

Thanks

Tudor

sql

RS2005's own SPs to add users to RS

Dear Anyone,

Is it possible to use Reporting Services' own stored procedure to add users directly into RS's security roles?

Thanks,

Joseph

Direct access to the RS catalog is not supported. Is there a reason why SOAP APIs are not enough?

Thanks

Tudor

RS2005 Performance Test Tool

Dear Anyone,

Is there a tool that we can use to simulate the performance of Reporting services?

Our team will be implementing performance tests over the reports we created over the corporate network. in reality, we expect about not more than 500 concurrent users but it could possibly go higher. We would need to do stress testing.

I was wondering if there is a performance tool out there that can simulate numbers of users accessing reports from our server? Any recommendations on how we can test this?

Thanks,

Joseph

Hi,

In my department, we use Opensta.

http://www.opensta.org/

Regards

Ayzan

sql

Wednesday, March 21, 2012

RS2005 Crashed After Editing and Restoring Config Files

Dear Anyone,

Here's what happened. We backed up the web.config and the rsreportserver.config. We messed around with it trying to make an assumption worked. When we finally gave up, we deleted these files and renamed back the web.config and the rsreportserver.config files. To our surprise when we tried to open our report manager, the error below showed up. We tried to reconfigure the report server using the reporting services configuration tool to no avail.

Any insights to what had happened and how to resolve it?

Thanks,
Joseph

Error message:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

check that reportserver service is running|||Yup, report service is running.|||

Hi Joseph,

I have seen something similar if the xml in the config files were mal formed. Open the config file in IE and see if there is a tag missing or something.

David

|||

Thanks for the reply. I have been told that one of the config files is not really an xml file. We've verified this with all of our reporting services installations. Aparently they have some sort of an encrypted data within it. I wonder if this is really true?

|||

We rely on ASP.NET and CLR Security to parse config files (rsReportServer.Config and rssrvpolicy.config).
Unfortunately these things use simplified xml parsers that may not properly handle some of xml features. It is a known fact that rssrvpolicy.config does not handle xml comments.
So whenever you modify config file make sure it is well formed.

RSReportServer.Config contains credentials for connecting to the RS Catalog database. These credentials are encrypted. To change them use Reporting Services Configuration Manager.

Tuesday, March 20, 2012

RS2000 & internal RS Database in SQL 2005

Dear all,
We are migrating step by step our different environements, we would like to
migrate SQL 2005 first, then migrate all the other applications to .NET v2.0,
Reporting Services 2005, ...etc.
We already bought the new SQL 2005 servers and we have several questions
about this :
- Could Reporting Services 2000 that is installed in the Web Servers have
internal Reporting Services Databases that are installed in SQL 2005?
- Is it supported by Microsoft? if so could yoiu please indicate a link to
Microsoft Web site confirming this?
- In order to point to the new databases do we have to uninstall RS 2000
and then install it again on the same machine and pointing to the new Servers
OR can I use rsconfig.exe to change the server and create the Reporting
Services Databases?
Best regards,
Stefan
http://www.itsconsulting.frAny response to my question above?
How can I get this information?
Stefan|||I know that RS 2005 can have its databases on SQL 2000 (and is fully
supported). I do not think that it is supported the other way. My guess is
that it will do a version check of the database and complain. However, would
RS 2000 continue working if you upgraded the database? Probably, but I don't
think it is officially supported.
When you get around to migrating RS 2000 a bit of advice. When you upgrade
the server the reports are still in RS 2000 format. They will continue to
work but I had the case with a few weird little problems here and there.
When I opened each report into the RS 2005 designer and converted them to RS
2005 format and redeployed, all my little problems disappeared.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:11DF485F-901E-4A81-9B85-813F93DE3CF3@.microsoft.com...
> Dear all,
> We are migrating step by step our different environements, we would like
> to
> migrate SQL 2005 first, then migrate all the other applications to .NET
> v2.0,
> Reporting Services 2005, ...etc.
> We already bought the new SQL 2005 servers and we have several questions
> about this :
> - Could Reporting Services 2000 that is installed in the Web Servers have
> internal Reporting Services Databases that are installed in SQL 2005?
> - Is it supported by Microsoft? if so could yoiu please indicate a link to
> Microsoft Web site confirming this?
> - In order to point to the new databases do we have to uninstall RS 2000
> and then install it again on the same machine and pointing to the new
> Servers
> OR can I use rsconfig.exe to change the server and create the Reporting
> Services Databases?
> Best regards,
> Stefan
> http://www.itsconsulting.fr
>

Friday, March 9, 2012

RS Security Best Practices

Dear Anyone,

Does anyone know where I can find some papers regarding best practices on how to implement security in reporting services?

Thanks,

Joseph

Books Online should be a good start for overview. There is a whitepaper on how to develop a custom security extensions, but that might be beyone what you're looking for. If you have specific questions, please ask.

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

Wednesday, March 7, 2012

RS Matrix Rendering Performance - help required

Dear All,
I am currently trialling MS Reporting Services and have so far been highly
impressed with the flexibility and functionality of the software. It
certainly out classes all of the other reporting solutions I have seen. That
is with one exception! I have so far designed several matrix based reports,
all of which render to the screen in <5 seconds and look superb. The
problems start to occur when I try and render the reports to PDF.
As an example, I have one matrix based report with 4 column header fields
and 8 row header fields producing a report of approx 150 pages. When I view
the report as HTML it takes approx 5s to run. If I then attempt to render it
as a PDF, the server CPU usage hits 100% (aspnet_wp.exe) and after several
hours is still attempting to render the report. If take exactly the same
report and remove 4 of the row header fields (doesn't shorten the report as
fields I remove are uniquely defined by a reference which remains) the report
now renders as a PDF in approx 20s !!?
I think this a superb product but desperately require a solution to this
problem. Most of our reporting is high level management reporting, to which
matrix based reports naturally lend themselves. Being restriced to 3-4 row
header fields is quite unworkable for our reporting needs, but I'd be loathed
to have to resort to another solution (e.g. crystal)
Any help would be much appreciated.Just to follow up on the previous posting, we are running MS Reporting
Services SP1 on a 2.4Ghz Single Processor machine with 1Gb Ram
"AndyC" wrote:
> Dear All,
> I am currently trialling MS Reporting Services and have so far been highly
> impressed with the flexibility and functionality of the software. It
> certainly out classes all of the other reporting solutions I have seen. That
> is with one exception! I have so far designed several matrix based reports,
> all of which render to the screen in <5 seconds and look superb. The
> problems start to occur when I try and render the reports to PDF.
> As an example, I have one matrix based report with 4 column header fields
> and 8 row header fields producing a report of approx 150 pages. When I view
> the report as HTML it takes approx 5s to run. If I then attempt to render it
> as a PDF, the server CPU usage hits 100% (aspnet_wp.exe) and after several
> hours is still attempting to render the report. If take exactly the same
> report and remove 4 of the row header fields (doesn't shorten the report as
> fields I remove are uniquely defined by a reference which remains) the report
> now renders as a PDF in approx 20s !!?
> I think this a superb product but desperately require a solution to this
> problem. Most of our reporting is high level management reporting, to which
> matrix based reports naturally lend themselves. Being restriced to 3-4 row
> header fields is quite unworkable for our reporting needs, but I'd be loathed
> to have to resort to another solution (e.g. crystal)
> Any help would be much appreciated.
>

Saturday, February 25, 2012

RS by SQL Express

Dear Friends

I installed RS by SQL Express, but i have a problem, RS was installed in W2003 server and i try to connect by Dataset to other DB, this is a SQL2000 in W2000, when i disigned the report and i see the view the report show me the result, but when i deploy teh report and i try to see by web the report dont respond and show the error "The dataset don;t connect or this function isn't disponible in this version", why is the problem, and who i resolve this problem.

Tahnk you

Hi,

RS Express could only run report against the local data source. To use remote data source, you will need standard/enterprise edition.