Reporting Services setup and permissions - UPDATE

I have Reporting Services set up on a SQL Server machine separate from the development machine. I have used Reporting Services configuration to set up ReportServices as the virtual directory. This did place a new web instance under the Default Web directory in IIS (I am using 5.1), however when I got into the c:\inetpub\wwwroot directory, there is not a ReportServices directory. I thought this is where I would set user permission for the ASPNET account.

I have set the permissions to the Reporting Services folder in the C:Program Files\...\ReportingServices directory, however I still am getting an error message about the IUSR account not having the proper permissions for deploying the report from the development machine.

What might I need to check here? I am not adversly opposed to having to uninstall and reinstall IIS if needed.

Also, when I connect to RS on the SQL machine and I right click on Roles, properties and roles are greyed out.

Thanks

I have been looking more into the settings for Report Configuration and also looking at the permissions set for the database in SQL Server. Now at least I do have it where if I want to deploy the report, it requests the Windows login name. I did this and it did deploy, however I do not want to do this all of the time.

Should I set the Authentication to SQL instead of Windows. I do know that SQL Server was set up for mixed.

|||I resolved the issue. Under the Reporting Services main folder, I had to give the proper permissions to ASPNET on the Home folder.

Reporting Services not showing in central admin

I downloaded and installed SQL Server 2005 SP2 update on my reporting services server. I think downloaded and installed the share point reporting services admin to my share point dev server. I open up the central administration and there is no reporting services menu option under the Application menu. The sharepoint server is a farm with backend database on one server and all the web apps on the other (where the add-in was installed). The reporting server is a separate server running its own instance of SQL 2005.

Am I missing something with this setup?

Make sure the feature is activated by checking whether "Report Server Integration Feature" is activated by going to Site Actions->Site Settings-> Site Collection features.

Note: You may need to be site owner of the Central Admin web site in order to view the "Site Collection features" link.

HTH,
Prash

Reporting Services from WebBrowser control - Print = "unable to load client print control&q

UPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)

---

UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.

---

My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."

I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.

Any ideas how to support Reporting Services "Print" from within a WebBrowser control?

RELATED THREADS

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=332145&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=264478&SiteID=1

This link has the answer(s) for your question(s):

http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/webbrowser/webbrowser.asp

especially check out for the section "Controlling Download and Execution"

Shyam

Hi to everybody,

I have installed on a windows server 2003 machine with all the last update until 12/10/06

sql server 2k analysis services with all the last update

the problem is that when I tray to export the report

I recieve this error

Reporting Services Error

--
Exception of type

Microsoft.ReportingServices.ReportRendering.ReportRenderingException

was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Cannot find font '?'.

--

Microsoft Reporting Services
Any suggestion is apprecieted
ty

You may want to try using www.sysinternals.com filemon tool to determine which font is missing, then replace it with a font from another machine.

Is it any export format or just PDF?

|||Thank you Andrew,

I have reinstalled the fonts and it works well..

but now I have another kind of problem

8128 :
Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.

this is the trace of the event viewer. that come's up some times..|||From a blog I found:

Found this reference from: Gert E.R. Drapers

on http://www.derkeiler.com

xp_qv, hosted in xpsqlbot.dll is a wrapper around functionality in

sqlboot.dll, which returns information about the SKU type, licensing etc

It is not documented that is why you can not find a reference. I should be getting called very

infrequently and as far as I know it only visits the Registry.|||Hi Andrew ,

thank you for your replay

but I have also this error.

Reporting Services Error

---

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Query execution failed for data set 'PDBrandModel'.

(rsErrorExecutingCommand) Get Online Help

Timeout expired. The timeout period elapsed prior to completion of the

operation or the server is not responding.|||

The above error doesn't look related.

The timeout error could be due to a long-running query. Check timeout settings for IIS & Reporting Services, and see if it is possible to optimize query in Query Analyzer. Turning on trace in the .config file of Reporting Services and using SQL Profiler could also track down the issue.

cheers,

Andrew

|||Hi to all,

I have tryied all the things suggest by you..

I have to understand the way to change the timeout on reporting services

and I don't know how to do that

Reporting Services Error

---

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Query execution failed for data set 'PDLiability'. (rsErrorExecutingCommand)

Get Online Help

Timeout expired. The timeout period elapsed prior to completion of the

operation or the server is not responding.|||

Go to data set and click on ellipse and leave timeout field empty.

Reporting Services Error

Hi to everybody,

I have installed on a windows server 2003 machine with all the last update until 12/10/06

sql server 2k analysis services with all the last update

the problem is that when I tray to export the report

I recieve this error

Reporting Services Error

--
Exception of type

Microsoft.ReportingServices.ReportRendering.ReportRenderingException

was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Cannot find font '?'.

--

Microsoft Reporting Services
Any suggestion is apprecieted

Roberto,

Did you try posting this in the reporting services forum?

This is a SSIS forum and I doubt you will get any response here

Rafael Salas