Showing posts with label iis. Show all posts
Showing posts with label iis. Show all posts

Friday, March 30, 2012

Report: Boolean-Parameter

Hi,
when I use a Boolean-Parameter in a report I get the choices true/false -
although I have a german SQL-Server and a german IIS. How can I change this
behaviour?
cu
Andréyou can fill in your own non-queried values, BUT it will then appear as a
drop down list instead of two radio buttons.
"André Köster" wrote:
> Hi,
> when I use a Boolean-Parameter in a report I get the choices true/false -
> although I have a german SQL-Server and a german IIS. How can I change this
> behaviour?
> cu
> André|||André,
Have you tried to set the language property on the report to German? Not
sure if that will work or not.
AK Code Rat.
"André Köster" wrote:
> Hi,
> when I use a Boolean-Parameter in a report I get the choices true/false -
> although I have a german SQL-Server and a german IIS. How can I change this
> behaviour?
> cu
> Andrésql

Friday, March 23, 2012

Report Viewer Control - Export to PDF, Works on local IIS computer, but not another.

When exporting a report to a pdf file, I am experiencing what seems to be a "hang up" on the server. The code executes fine from my development machine, but when moved to the server I get this response. I also recieve this message if I click the refresh button. Acrobat could not open 'pdf9c9.tmp' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decode). To create an Adobe PDF document, go to the source application. Then print the document to Adobe PDF.

Here is my code for reference. It works fine on one IIS, but not another. What could I be missing?

Dim warningsAs Microsoft.Reporting.WebForms.Warning() =Nothing

Dim streamidsAsString() =Nothing

Dim mimeTypeAsString =Nothing

Dim encodingAsString =Nothing

Dim extensionAsString =Nothing

Dim deviceInfoAsString

Dim bytesAsByte()

Dim lrAsNew Microsoft.Reporting.WebForms.LocalReport

lr.ReportPath ="Report1.rdlc"

'lr.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DischargeSummary", ObjectDataSource1()))

deviceInfo ="<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>"

bytes = ReportViewer1.LocalReport.Render("PDF", deviceInfo, mimeType, encoding, extension, streamids, warnings)

Response.ClearContent()

Response.ClearHeaders()

Response.ContentType ="application/pdf"

Response.BinaryWrite(bytes)

Response.Flush()

Response.Close()

Check security permission on the server.

Monday, March 12, 2012

Report Services Install problems!

Installing Reporting Services with IIS and Report Services running on one
machine and Reporting databases on remote SQL Server. Getting the error below
when attempting to view http://servername/reports page.
Any ideas?
Thanks.
Frank
Server Error in '/Reports' Application
----
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Unable to load file
'ReportingServicesEmailDeliveryProvider'.
Source Error:
Line 256: <add assembly="System.EnterpriseServices,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 257: <add assembly="System.Web.Mobile,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 258: <add assembly="*"/>
Line 259: </assemblies>
Line 260:
Source File: c:\nos\microsoft.net\framework\v1.1.4322\Config\machine.config
Line: 258
Assembly Load Trace: The following information can be helpful to determine
why the assembly 'ReportingServicesEmailDeliveryProvider' could not be loaded.
=== Pre-bind state information === LOG: DisplayName = ReportingServicesEmailDeliveryProvider
(Partial)
LOG: Appbase = file:///D:/ReportingServices/MSSQL/Reporting
Services/ReportManager
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom,
partial, or location-based assembly bind).
LOG: Post-policy reference: ReportingServicesEmailDeliveryProvider
LOG: Attempting download of new URL
file:///C:/NOS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/reports/a21cac91/f4eaffac/ReportingServicesEmailDeliveryProvider.DLL.
LOG: Attempting download of new URL
file:///C:/NOS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/reports/a21cac91/f4eaffac/ReportingServicesEmailDeliveryProvider/ReportingServicesEmailDeliveryProvider.DLL.
LOG: Attempting download of new URL
file:///D:/ReportingServices/MSSQL/Reporting
Services/ReportManager/bin/ReportingServicesEmailDeliveryProvider.DLL.
LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file
(C:\NOS\Microsoft.NET\Framework\v1.1.4322\aspnet.config).
LOG: Using machine configuration file from
C:\NOS\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: ReportingServicesEmailDeliveryProvider,
Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032> Server Error in '/Reports' Application.
> ----
--
> Configuration Error
> Description: An error occurred during the processing of a configuration
file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: Unable to load file
> 'ReportingServicesEmailDeliveryProvider'.
> Source Error:
>
> Line 256: <add assembly="System.EnterpriseServices,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 257: <add assembly="System.Web.Mobile,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 258: <add assembly="*"/>
> Line 259: </assemblies>
> Line 260:
>
Which OS? Is it a Domain controller?
I received the same message on my lab computer after making it domain
controller (Win2K, SP4). In KB824308 I found some useful information that
helped me to some extent. Now rs is at least able to show part of the
standard page.
I still receive an error, though: "Internal error. The profile for the user
is a temporary profile". Aaaaaargh!
Leif|||Windows 2003 Server. I was told that it is not a domain controller. I will
look at the kb article. hopefully it applies. Thanks. Frank
"Leif" wrote:
> > Server Error in '/Reports' Application.
> > ----
> --
> >
> > Configuration Error
> > Description: An error occurred during the processing of a configuration
> file
> > required to service this request. Please review the specific error details
> > below and modify your configuration file appropriately.
> >
> > Parser Error Message: Unable to load file
> > 'ReportingServicesEmailDeliveryProvider'.
> >
> > Source Error:
> >
> >
> > Line 256: <add assembly="System.EnterpriseServices,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> > Line 257: <add assembly="System.Web.Mobile,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> > Line 258: <add assembly="*"/>
> > Line 259: </assemblies>
> > Line 260:
> >
> Which OS? Is it a Domain controller?
> I received the same message on my lab computer after making it domain
> controller (Win2K, SP4). In KB824308 I found some useful information that
> helped me to some extent. Now rs is at least able to show part of the
> standard page.
> I still receive an error, though: "Internal error. The profile for the user
> is a temporary profile". Aaaaaargh!
> Leif
>
>

Friday, March 9, 2012

Report Server Web Site Shows File Not Found

Hi -

I have installed VS2005 and SQL Server 2005, with all reporting services features turned on. When I look at IIS i see applications for ReportingServer and Reports.

But i cannot seem to browse or run any reports. From SQL Server management Studio, from IIS, from browser all give same results - page not found. Did I miss a configuration? Who needs permissions to what? I created the report in VS2005 and deployed it but i cannot see it in the IIS virtual directory for ReportServices. When i look at folders in management studio, i see the folders for the project, and the report, but they dont show up in IIS.

HELP! nothing works!

Deployed reports don't go into IIS. They are stored internally in the reporting services databases.

Go to http://localhost/reports

This should show you 'Report Manager'. You can execute your reports from there.

Regards

Paul

|||When you deploy reports in VS, what is the ReportServerUrl property of the project? You should be able to access the same url from IE.|||

The ReportServer settings on the project are to the Reporting Services web services. For URL access to a report you need to look at the help file. Here is an example:

http://servername/reportserver?/SampleReports/Employee Sales Summary&rs:Command=Render&rs:format=HTML4.0

Report server spawning multiple w3wp.exe threads

We have Win2003 SP1, SQL 2000 SP4, RS 2000 SP2 installed on our dev
machine and it works ok - having problems using anonamous access under
IIS but that is another issue.....
On our production server ( win2003 SP1, SQL 2000 SP4 ) we installed RS
2000 and SP2, accepting all the default installation options accept
SSL, and we have the following problems....
When we try to access http:\\servername\reports it takes a good few
minutes to load the web page, after asking for a domain user account,
and then the whole server runs like a dog.
Just getting to the first web page creates 12-15 copies of w3wp.exe,
each of which swallow between 20 and 130 MB of memory, and ramps up the
CPU usage.
I you try to upload a report, or access an existing report it spawns
off another 8-10 copies of w3wp.exe and eats more memory, and seriously
slows the server down.
The only way to release the resources it has useems to be to restart
IIS.
I "think" that this may be due to some hardening or lock down of
production server, but I am struggling on what to do next.
The RS logs do not seem to show any problems, but the Win App log shows
"ID 124 ReportServer Service has been activated" 5-6 times for every
action you take against reporting services.
I have been through the "checking reporting services is installed"
guides and it all seems ok, so there is something key I am missing here
!!!
Anyone else had similar problems and found the solution, or could at
least point me in the right direction to progress this issue !An update...
Thanks our freinds at the hosting company, it turns out this was all
due to .Net framework and IIS
We have apps running under 1.1 and 2.0 frameworks, and RS was set to
use default app pool on the IIS config.
Created a new app pool, and let both RS directories use that instead -
bingo !
Lots of w3wp.exe still created, but not hosing the box, and the number
goes up and down as usage changes.
Advice has been to create a new app pool just for reporting services,
as it is a hungry beast !

Wednesday, March 7, 2012

Report Server Install - I Need Help...

Baby steps I guess... I did a synchiwam and can now get to the IIS report
server page but with the following error, any thoughts?
[ExternalException (0x5): Cannot execute a program. The command being
executed was "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
@."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline".]
The full error follows my sig...
Thanks
Travis
Server Error in '/ReportServer' Application.
----
Cannot execute a program. The command being executed was
"c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
@."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline".
Description: An unhandled exception occurred during compilation using the
CodeDomProvider 'Microsoft.CSharp.CSharpCodeProvider'. Please review the
stack trace for more information about the error and where it originated in
the code.
Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
@."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline".
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[ExternalException (0x5): Cannot execute a program. The command being
executed was "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
@."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline".]
System.CodeDom.Compiler.Executor.ExecWaitWithCaptureUnimpersonated(IntPtr
userToken, String cmd, String currentDir, TempFileCollection tempFiles,
String& outputName, String& errorName, String trueCmdLine) +2050
System.CodeDom.Compiler.Executor.ExecWaitWithCapture(IntPtr userToken,
String cmd, String currentDir, TempFileCollection tempFiles, String&
outputName, String& errorName, String trueCmdLine) +260
System.CodeDom.Compiler.CodeCompiler.Compile(CompilerParameters options,
String compilerDirectory, String compilerExe, String arguments, String&
outputFile, Int32& nativeReturnValue, String trueArgs) +383
System.CodeDom.Compiler.CodeCompiler.FromFileBatch(CompilerParameters
options, String[] fileNames) +548
System.CodeDom.Compiler.CodeCompiler.FromDomBatch(CompilerParameters
options, CodeCompileUnit[] ea) +428
System.CodeDom.Compiler.CodeCompiler.FromDom(CompilerParameters options,
CodeCompileUnit e) +90
System.CodeDom.Compiler.CodeCompiler.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromDom(CompilerParameters
options, CodeCompileUnit e) +37
System.Web.Compilation.BaseCompiler.GetCompiledType() +227
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032an update to .NET 2.0 took care of things...
> Baby steps I guess... I did a synchiwam and can now get to the IIS report
> server page but with the following error, any thoughts?
> [ExternalException (0x5): Cannot execute a program. The command being
> executed was "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe"
> /noconfig @."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
> Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline".]
>

Saturday, February 25, 2012

report server cannot be initialized

Hi!
I have a problem while i want to test the status of the report server in my
win xp os:
-my os is win xp professional + sp2
-first i installed iis
-then i installed sql server 2005 standard edition
but when i want to initialize reporting service (using configure report
server page) , the "initialized "
option is disabled, and when i type http://localhost/reportserver in IE, IE
changes the address to a search keyword and
doesn't display report server page.
please, give me a solution for this!
thanks!Verify your web server is running and make sure you have asp.net installed,
run %WINNT%\Microsoft.NET\Framework\%framework version%\aspnet_regiis.exe -i.
Open IIS console and verify that the virtual directory reportserver and
reports exist, browse the default the root of the reprtserver virtual from
IIS. Did you change the default virtual directory during the install..?
"fazarmnia" wrote:
> Hi!
> I have a problem while i want to test the status of the report server in my
> win xp os:
> -my os is win xp professional + sp2
> -first i installed iis
> -then i installed sql server 2005 standard edition
> but when i want to initialize reporting service (using configure report
> server page) , the "initialized "
> option is disabled, and when i type http://localhost/reportserver in IE, IE
> changes the address to a search keyword and
> doesn't display report server page.
> please, give me a solution for this!
> thanks!

Report Server - Access Error

Any help appreciated...
Installed Reporting Services on Win2003 machine with a SQL2000 db.
Reporting Services was installed with an IIS without default website, running
IIS5.0 Isolation mode.
When navigating to http://<hostheader>/reports I get the folllowing error...
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
When navigating to http://<hostheader>/ReportServer, the following error
occurs...
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
I have ensure the account running reports is included in the group running
the webservices. Also made the change to utilise <ReportServerURL> to the
http://<hostheader>/ReportServer.
Any assistance appreciated...
JamesHi, James
You either need to have the default website in IIS in order to use
Reporting Services, or you must specify a different website in which
the Reports and ReportService virtual directories will be created.
To use a different website than the Default IIS site, you will need to
change the configuration files for the report server app, service, and
report manager app. Please see the following article for more
information on how to setup RS for a non-Default website:
RS 2005 BOL => http://msdn2.microsoft.com/en-us/library/ms155921.aspx
couldn't find the equivalent BOL article for RS2000 in the MSDN, so
here is a link to an article on the web that will suffice:
http://www.awprofessional.com/articles/article.asp?p=357694&seqNum=3&rl=1
Have fun!
Regards,
Thiago Silva
JamesC wrote:
> Any help appreciated...
> Installed Reporting Services on Win2003 machine with a SQL2000 db.
> Reporting Services was installed with an IIS without default website, running
> IIS5.0 Isolation mode.
> When navigating to http://<hostheader>/reports I get the folllowing error...
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer.
>
> When navigating to http://<hostheader>/ReportServer, the following error
> occurs...
>
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer.
>
> I have ensure the account running reports is included in the group running
> the webservices. Also made the change to utilise <ReportServerURL> to the
> http://<hostheader>/ReportServer.
> Any assistance appreciated...
> James|||All resolved, needed to ensure that the web server was not running in IIS5.0
isolation mode.
Thanks.
"tafs7" wrote:
> Hi, James
> You either need to have the default website in IIS in order to use
> Reporting Services, or you must specify a different website in which
> the Reports and ReportService virtual directories will be created.
> To use a different website than the Default IIS site, you will need to
> change the configuration files for the report server app, service, and
> report manager app. Please see the following article for more
> information on how to setup RS for a non-Default website:
> RS 2005 BOL => http://msdn2.microsoft.com/en-us/library/ms155921.aspx
> couldn't find the equivalent BOL article for RS2000 in the MSDN, so
> here is a link to an article on the web that will suffice:
> http://www.awprofessional.com/articles/article.asp?p=357694&seqNum=3&rl=1
> Have fun!
> Regards,
> Thiago Silva
> JamesC wrote:
> > Any help appreciated...
> >
> > Installed Reporting Services on Win2003 machine with a SQL2000 db.
> > Reporting Services was installed with an IIS without default website, running
> > IIS5.0 Isolation mode.
> >
> > When navigating to http://<hostheader>/reports I get the folllowing error...
> >
> > The report server is not responding. Verify that the report server is
> > running and can be accessed from this computer.
> >
> >
> > When navigating to http://<hostheader>/ReportServer, the following error
> > occurs...
> >
> >
> > The report server is not responding. Verify that the report server is
> > running and can be accessed from this computer.
> >
> >
> > I have ensure the account running reports is included in the group running
> > the webservices. Also made the change to utilise <ReportServerURL> to the
> > http://<hostheader>/ReportServer.
> >
> > Any assistance appreciated...
> >
> > James
>