Running RS2000 on Windows 2003
I published a new report today (copied from an existing report, used same
data source calling different stored procedure, changed parameters, etc.).
It worked fine when run locally.
However, when published and run within Report Manager I get the following
error -
Reporting Services Error
----
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
General network error. Check your network documentation.
I'm not sure I've seen this error before. I've had errors before but they
usually occurred because I forgot to give adequate permissions to the stored
procedure or something like that.
I've search around but haven't figured out how to troubleshoot this problem.
I have looked at the trace logs but I'm still learning how to read them.
Here is what appear to be the relevant portion found in them -
In ReportServer__08_17_2007_06_42_51.log
w3wp!library!1058!08/17/2007-10:54:06:: i INFO: Call to RenderFirst(
'/Development/Ref Des Term Count' )
w3wp!library!1058!08/17/2007-10:54:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.ChunkStorage.WriteNewSnapshotToDB(String
effectiveParams, Int32 paramsHash, DateTime createdDate, String description,
Guid snapshotDataID, Boolean isPermanentSnapshot)
at
Microsoft.ReportingServices.Library.ReportSnapshot.WriteNewSnapshotToDB(String effectiveParams, Int32 paramsHash, DateTime createdDate, String description)
at
Microsoft.ReportingServices.Library.RSService.AllocateNewSnapshot(Boolean
isPermanentSnapshot, String effectiveParams, Int32 paramsHash, DateTime
createdDate, String description)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
-- End of inner exception stack trace --
w3wp!library!1058!08/17/2007-10:54:07:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!1058!08/17/2007-10:54:08:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal
error occurred on the report server. See the error log for more details. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
In ReportServerService__main_08_17_2007_05_10_24.log
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__main_08_17_2007_05_10_24.log</Path>
<SystemName>IW-SQL</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:24:: i INFO:
Recycling the service from default domain
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:27:: i INFO:
New app domain started
Other existing reports seem to be working with no problem.
Any help troubleshooting this would be greatly appreciated.
KevinWell I've found a solution. Instead of copying an existing report I just
started from scratch. I built a new one from the ground up and it worked
fine.
Apparently there was something in the report I made from the copy that it
didn't like. I thought I went through it pretty thoroughly to make sure
nothing referred to fields, parameters, etc. that didn't apply but I guess I
missed something.
For future reference I would appreciate any recommendations for catching
problems when copying a report. Maybe copying isn't recommended? It usually
seems to save time (except in this case!).
Kevin|||Rats!!! I thought I had it fixed. My report and stored procedure both have
just one parameter. I just made a simple report (data is listed in a table)
and set a default value for the report parameter and it worked.
Thinking that it was fixed, I removed the default and re-published. Now
when I select a value from the list in the prompt and run the report I get
the error.
So, is the problem something to do with my prompt? Any ideas on
troubleshooting would be appreciated. The prompt is just a simple query from
one table -
SELECT DISTINCT r.item AS PromptValue
,r.item AS PromptLabel
FROM dbname.dbo.tablename r
WHERE r.item <> ''
ORDER BY r.item
The stored procedure queries the same table and is as follows -
CREATE PROCEDURE rpt_Ref_DesTermCount
(
@.StockCode VARCHAR(30) = '%'
)
AS
SELECT r.item
,r.ref_des
,r.TermCount
FROM dbname.dbo.tablename r
WHERE r.item LIKE @.StockCode
ORDER BY r.ref_des
GO
Thanks in advance,
Kevin
Showing posts with label network. Show all posts
Showing posts with label network. Show all posts
Friday, March 30, 2012
Wednesday, March 7, 2012
RS not stable?
Hi there,
I made several reports using RS with SP1, they worked well untill I
made a change: There are two parameters for every report - Network and
Region, which were independent. I changed them to related, i.e whenever
I choose a Network, then only show Regions under this Network.
I made changes on 2 development machines - A and B. After I made this
change, there are lot of errors/issues happened on each machine:
1) On machine A, after deployment, I have to click twice on "View
Report" to view a report in IE.
2) On machine B, besides "click twice problem" in IE. There are tons of
problems when I try to "preview" the report:
a) I use "All" as default value for Network parameter, When I click on
Network drill down button to pick up one Network, sometimes it works,
sometimes it doesn't - always show "All".
b) My test data should have 8 pages for one report, but sometimes show
page 13? sometimes show page 22? If I try to check every page, on page
3 I always got error "Generic error in GDI+", then move to page 5' If
I refresh, it works well.
c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got "
Network is null" error' After I refresh, sometimes it works, sometimes
it doesn't.
For machine B, the RS seems not stable at all, it always sometimes
works, sometimes doesn't work. Seems something messed up.
Anybody got any idea about this? Thanks in advance.
HenryI've used RS for 13 months now and SP1 as soon as it came out, whilst
it isn't perfect I've found it to be quite stable. I think you've some
more fundamental issues, especially the GDI+ error. I can't help you
I'm afraid, but just to let you know, your problems are not normal.
Chris
fanh@.tycoelectronics.com wrote:
> Hi there,
> I made several reports using RS with SP1, they worked well untill I
> made a change: There are two parameters for every report - Network and
> Region, which were independent. I changed them to related, i.e
> whenever I choose a Network, then only show Regions under this
> Network.
> I made changes on 2 development machines - A and B. After I made this
> change, there are lot of errors/issues happened on each machine:
> 1) On machine A, after deployment, I have to click twice on "View
> Report" to view a report in IE.
> 2) On machine B, besides "click twice problem" in IE. There are tons
> of problems when I try to "preview" the report:
> a) I use "All" as default value for Network parameter, When I click on
> Network drill down button to pick up one Network, sometimes it works,
> sometimes it doesn't - always show "All".
> b) My test data should have 8 pages for one report, but sometimes show
> page 13? sometimes show page 22? If I try to check every page, on page
> 3 I always got error "Generic error in GDI+", then move to page 5' If
> I refresh, it works well.
> c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got
> " Network is null" error' After I refresh, sometimes it works,
> sometimes it doesn't.
> For machine B, the RS seems not stable at all, it always sometimes
> works, sometimes doesn't work. Seems something messed up.
> Anybody got any idea about this? Thanks in advance.
> Henry|||I'll echo that (stable, and I use it extensively).
If this is for all reports then I suggest re-installing. If it is for a
specific few reports then you can try looking at the code for the RDL. I
have seen a few times where things got out of wack. For instance I deleted a
group but the group didn't get deleted from the RDL. Given the changes you
have made that is a possibility. In Visual Studio open up your report and
then do a view code and look through the xml and see if anything doesn't
look right.
The other thing I wonder is how you are getting this information, what are
you querying. Could something have changed there?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:%23bnuJX8IFHA.2736@.TK2MSFTNGP09.phx.gbl...
> I've used RS for 13 months now and SP1 as soon as it came out, whilst
> it isn't perfect I've found it to be quite stable. I think you've some
> more fundamental issues, especially the GDI+ error. I can't help you
> I'm afraid, but just to let you know, your problems are not normal.
> Chris
> fanh@.tycoelectronics.com wrote:
> > Hi there,
> >
> > I made several reports using RS with SP1, they worked well untill I
> > made a change: There are two parameters for every report - Network and
> > Region, which were independent. I changed them to related, i.e
> > whenever I choose a Network, then only show Regions under this
> > Network.
> >
> > I made changes on 2 development machines - A and B. After I made this
> > change, there are lot of errors/issues happened on each machine:
> > 1) On machine A, after deployment, I have to click twice on "View
> > Report" to view a report in IE.
> > 2) On machine B, besides "click twice problem" in IE. There are tons
> > of problems when I try to "preview" the report:
> > a) I use "All" as default value for Network parameter, When I click on
> > Network drill down button to pick up one Network, sometimes it works,
> > sometimes it doesn't - always show "All".
> > b) My test data should have 8 pages for one report, but sometimes show
> > page 13? sometimes show page 22? If I try to check every page, on page
> > 3 I always got error "Generic error in GDI+", then move to page 5' If
> > I refresh, it works well.
> > c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got
> > " Network is null" error' After I refresh, sometimes it works,
> > sometimes it doesn't.
> >
> > For machine B, the RS seems not stable at all, it always sometimes
> > works, sometimes doesn't work. Seems something messed up.
> >
> > Anybody got any idea about this? Thanks in advance.
> >
> > Henry
>
I made several reports using RS with SP1, they worked well untill I
made a change: There are two parameters for every report - Network and
Region, which were independent. I changed them to related, i.e whenever
I choose a Network, then only show Regions under this Network.
I made changes on 2 development machines - A and B. After I made this
change, there are lot of errors/issues happened on each machine:
1) On machine A, after deployment, I have to click twice on "View
Report" to view a report in IE.
2) On machine B, besides "click twice problem" in IE. There are tons of
problems when I try to "preview" the report:
a) I use "All" as default value for Network parameter, When I click on
Network drill down button to pick up one Network, sometimes it works,
sometimes it doesn't - always show "All".
b) My test data should have 8 pages for one report, but sometimes show
page 13? sometimes show page 22? If I try to check every page, on page
3 I always got error "Generic error in GDI+", then move to page 5' If
I refresh, it works well.
c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got "
Network is null" error' After I refresh, sometimes it works, sometimes
it doesn't.
For machine B, the RS seems not stable at all, it always sometimes
works, sometimes doesn't work. Seems something messed up.
Anybody got any idea about this? Thanks in advance.
HenryI've used RS for 13 months now and SP1 as soon as it came out, whilst
it isn't perfect I've found it to be quite stable. I think you've some
more fundamental issues, especially the GDI+ error. I can't help you
I'm afraid, but just to let you know, your problems are not normal.
Chris
fanh@.tycoelectronics.com wrote:
> Hi there,
> I made several reports using RS with SP1, they worked well untill I
> made a change: There are two parameters for every report - Network and
> Region, which were independent. I changed them to related, i.e
> whenever I choose a Network, then only show Regions under this
> Network.
> I made changes on 2 development machines - A and B. After I made this
> change, there are lot of errors/issues happened on each machine:
> 1) On machine A, after deployment, I have to click twice on "View
> Report" to view a report in IE.
> 2) On machine B, besides "click twice problem" in IE. There are tons
> of problems when I try to "preview" the report:
> a) I use "All" as default value for Network parameter, When I click on
> Network drill down button to pick up one Network, sometimes it works,
> sometimes it doesn't - always show "All".
> b) My test data should have 8 pages for one report, but sometimes show
> page 13? sometimes show page 22? If I try to check every page, on page
> 3 I always got error "Generic error in GDI+", then move to page 5' If
> I refresh, it works well.
> c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got
> " Network is null" error' After I refresh, sometimes it works,
> sometimes it doesn't.
> For machine B, the RS seems not stable at all, it always sometimes
> works, sometimes doesn't work. Seems something messed up.
> Anybody got any idea about this? Thanks in advance.
> Henry|||I'll echo that (stable, and I use it extensively).
If this is for all reports then I suggest re-installing. If it is for a
specific few reports then you can try looking at the code for the RDL. I
have seen a few times where things got out of wack. For instance I deleted a
group but the group didn't get deleted from the RDL. Given the changes you
have made that is a possibility. In Visual Studio open up your report and
then do a view code and look through the xml and see if anything doesn't
look right.
The other thing I wonder is how you are getting this information, what are
you querying. Could something have changed there?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:%23bnuJX8IFHA.2736@.TK2MSFTNGP09.phx.gbl...
> I've used RS for 13 months now and SP1 as soon as it came out, whilst
> it isn't perfect I've found it to be quite stable. I think you've some
> more fundamental issues, especially the GDI+ error. I can't help you
> I'm afraid, but just to let you know, your problems are not normal.
> Chris
> fanh@.tycoelectronics.com wrote:
> > Hi there,
> >
> > I made several reports using RS with SP1, they worked well untill I
> > made a change: There are two parameters for every report - Network and
> > Region, which were independent. I changed them to related, i.e
> > whenever I choose a Network, then only show Regions under this
> > Network.
> >
> > I made changes on 2 development machines - A and B. After I made this
> > change, there are lot of errors/issues happened on each machine:
> > 1) On machine A, after deployment, I have to click twice on "View
> > Report" to view a report in IE.
> > 2) On machine B, besides "click twice problem" in IE. There are tons
> > of problems when I try to "preview" the report:
> > a) I use "All" as default value for Network parameter, When I click on
> > Network drill down button to pick up one Network, sometimes it works,
> > sometimes it doesn't - always show "All".
> > b) My test data should have 8 pages for one report, but sometimes show
> > page 13? sometimes show page 22? If I try to check every page, on page
> > 3 I always got error "Generic error in GDI+", then move to page 5' If
> > I refresh, it works well.
> > c) I knew in my DB, Network is 8 or 13, not null. But sometimes I got
> > " Network is null" error' After I refresh, sometimes it works,
> > sometimes it doesn't.
> >
> > For machine B, the RS seems not stable at all, it always sometimes
> > works, sometimes doesn't work. Seems something messed up.
> >
> > Anybody got any idea about this? Thanks in advance.
> >
> > Henry
>
Saturday, February 25, 2012
RS and SQL Server and AS on 1 machine - how to do it right?
Hi all,
RS first did work for me after installation on my notebook, but some silly
changes of our network admin ruined everything:
RS does not run any more, gave me some access denied errors. Complete RS
Re-Installation told me at the end that it could not initialize RS: "Setup
could not initialize the Report Server - you must manually initialize Report
server before using it for the first time." But Rsactivate did not cure it.
It give an "
Error starting Webservice:
The Reportserver Webservice has not generated a public key. The service was
eventually not started successfully. See Log files for further Information.
I did look into the log files and work along half a dozen knowledgebase
articles and re-installed RS several times and even .NET framework. NO
SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed several
requests for the same problem - there was NEVER an answer that lead to a
successful solution.
I cannot access localhost reportserver. It keeps reporting access rights
problems all time. Yesterday, after looking at the .LOG files again I gave
full access rights to the Reporting Services directories and everything
below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS again:
RS is running, but when I launch localhost/reportserver I get the following
(translated from German):
Server error in application '/ReportServer'.
--
Program directory 'C:\Program files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\' cannot be accessed. The directory is not available
or it cannot be accessed because of safety settings.
Description: When executing the current Web request an unprocessed error
occurred. Check Batch control to display further Information on this error
and find out where in the Code the error was caused.
Exception details: System.Web.HttpException: Program directory 'C:\Program
files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be
accessed. The directory is not available or it cannot be accessed because of
safety settings.
Source error:
When executing the current Web request an unprocessed error occurred.
Information on the source and the Position of the exception can be displayed
using the exception batch control.
batch control:
[HttpException (0x80004005): Program directory 'C:\Program files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be accessed. The
directory is not available or it cannot be accessed because of safety
settings.]
System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
[HttpException (0x80004005): ASP.NET-Initialisation error]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +964
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128
--
Version information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET-Version:1.1.4322.573
ASP.NET is working - I tested it by running a sample application of ChartFX.
I even did remove the write protection from these directories: same result.
Today I did establish full rights for IWAM, IUSR and ASPNET. And I did set
the default website to (All Unassigned). NO CHANGE.
Now I have reached the end of the road. Please someone tell me the right way
how to define the access rights correctly, and in which sequence, in my
case for having
RS and SQL Server and AS installed together on 1 machine (XP pro).
Any comments appreciated.
HelmutThis is a multi-part message in MIME format.
--=_NextPart_000_00B5_01C4BCC8.A27CB760
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Forgive if you have already tried these:... I looked for a dot net =framework security thing, but couldn't find it... It seems like I had to =go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not found
This error indicates that there is a problem with the virtual directory =configuration. In IIS, navigate to the report server virtual directory, =and right-click Properties. On the Virtual Directory tab, click =Configuration, select the extension, and click Edit. Make sure that =Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server error
Reporting Services requires version 1.1.4322 of the .NET Framework. This =error can occur when the report server or Report Manager virtual =directories are mapped to version 1.0.3705. To check the application =mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable =Path value. If it is set to v1.0.3705, you must configure the virtual =directory to use 1.1.4322. Follow the instructions provided in Knowledge =Base Article 306005 to map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clq9mt$ari$1@.svr7.m-online.net...
> Hi all,
> > RS first did work for me after installation on my notebook, but some =silly
> changes of our network admin ruined everything:
> > RS does not run any more, gave me some access denied errors. Complete =RS
> Re-Installation told me at the end that it could not initialize RS: ="Setup
> could not initialize the Report Server - you must manually initialize =Report
> server before using it for the first time." But Rsactivate did not =cure it.
> It give an "
> Error starting Webservice:
> The Reportserver Webservice has not generated a public key. The =service was
> eventually not started successfully. See Log files for further =Information.
> I did look into the log files and work along half a dozen =knowledgebase
> articles and re-installed RS several times and even .NET framework. NO
> SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed several
> requests for the same problem - there was NEVER an answer that lead to =a
> successful solution.
> > I cannot access localhost reportserver. It keeps reporting access =rights
> problems all time. Yesterday, after looking at the .LOG files again I =gave
> full access rights to the Reporting Services directories and =everything
> below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS again:
> > RS is running, but when I launch localhost/reportserver I get the =following
> (translated from German):
> Server error in application '/ReportServer'.
> --
> Program directory 'C:\Program files\Microsoft SQL =Server\MSSQL\Reporting
> Services\ReportServer\' cannot be accessed. The directory is not =available
> or it cannot be accessed because of safety settings.
> Description: When executing the current Web request an unprocessed =error
> occurred. Check Batch control to display further Information on this =error
> and find out where in the Code the error was caused.
> > Exception details: System.Web.HttpException: Program directory ='C:\Program
> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be
> accessed. The directory is not available or it cannot be accessed =because of
> safety settings.
> > Source error:
> When executing the current Web request an unprocessed error occurred.
> Information on the source and the Position of the exception can be =displayed
> using the exception batch control.
> > batch control:
> [HttpException (0x80004005): Program directory 'C:\Program =files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be accessed. =The
> directory is not available or it cannot be accessed because of safety
> settings.]
> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
> [HttpException (0x80004005): ASP.NET-Initialisation error]
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +964
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) =+128
> --
> Version information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET-Version:1.1.4322.573
> > ASP.NET is working - I tested it by running a sample application of =ChartFX.
> I even did remove the write protection from these directories: same =result.
> > > Today I did establish full rights for IWAM, IUSR and ASPNET. And I did =set
> the default website to (All Unassigned). NO CHANGE.
> > Now I have reached the end of the road. Please someone tell me the =right way
> how to define the access rights correctly, and in which sequence, in =my
> case for having
> RS and SQL Server and AS installed together on 1 machine (XP pro).
> > Any comments appreciated.
> Helmut
> > > > >
--=_NextPart_000_00B5_01C4BCC8.A27CB760
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Forgive if you have already tried these:... I looked =for a dot net framework security thing, but couldn't find it... It seems like I =had to go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I remember incorrectly.)
HTTP 404 File or directory not =found
This error indicates that there is a =problem with the virtual directory configuration. In IIS, navigate to the report server =virtual directory, and right-click Properties. On the Virtual Directory tab, =click Configuration, select the extension, and click Edit. Make sure that =Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server =error
Reporting Services requires version =1.1.4322 of the .NET Framework. This error can occur when the report server or Report =Manager virtual directories are mapped to version 1.0.3705. To check the =application mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click Configuration, scroll to =the .aspx extension, and read the Executable Path value. If it is set to =v1.0.3705, you must configure the virtual directory to use 1.1.4322. Follow the instructions provided in Knowledge Base Article 306005 to map v1.1.4322 =to IIS.
-- Wayne Snyder, MCDBA, SQL =Server MVPMariner, Charlotte, NCwww.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional Association =of SQL Server (PASS) and it'scommunity of SQL Server =professionals.www.sqlpass.org
"Helmut Knappe" =wrote in message news:clq9mt$ari$1@.svr7.m-online.net...> Hi =all,> > RS first did work for me after installation on my notebook, but some =silly> changes of our network admin ruined everything:> > RS does =not run any more, gave me some access denied errors. Complete RS> =Re-Installation told me at the end that it could not initialize RS: "Setup> could =not initialize the Report Server - you must manually initialize =Report> server before using it for the first time." But Rsactivate did not cure it.> It give an "> Error starting Webservice:> The Reportserver Webservice has not generated a public key. The service =was> eventually not started successfully. See Log files for further Information.> I did look into the log files and work along half a =dozen knowledgebase> articles and re-installed RS several times and =even .NET framework. NO> SUCCESS. Answers in this newsgroup DID NOT HELP. =I've noticed several> requests for the same problem - there was NEVER =an answer that lead to a> successful solution.> > I =cannot access localhost reportserver. It keeps reporting access rights> =problems all time. Yesterday, after looking at the .LOG files again I =gave> full access rights to the Reporting Services directories and =everything> below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS again:> => RS is running, but when I launch localhost/reportserver I get the following> (translated from German):> Server error in =application '/ReportServer'.> --> =Program directory 'C:\Program files\Microsoft SQL Server\MSSQL\Reporting> =Services\ReportServer\' cannot be accessed. The directory is not available> or it cannot be accessed because of safety =settings.> Description: When executing the current Web request an unprocessed =error> occurred. Check Batch control to display further Information on this error> and find out where in the Code the error was =caused.> > Exception details: System.Web.HttpException: Program directory 'C:\Program> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be> accessed. The directory is not =available or it cannot be accessed because of> safety =settings.> > Source error:> When executing the current Web request an =unprocessed error occurred.> Information on the source and the =Position of the exception can be displayed> using the exception batch control.> > batch control:> [HttpException =(0x80004005): Program directory 'C:\Program files\Microsoft> SQL =Server\MSSQL\Reporting Services\ReportServer\' cannot be accessed. The> directory is not =available or it cannot be accessed because of safety> =settings.]> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() =+72> =System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263> [HttpException (0x80004005): =ASP.NET-Initialisation error]> =System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +964> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) =+128> --> Version information: =Microsoft .NET Framework Version:1.1.4322.573;> =ASP.NET-Version:1.1.4322.573> > ASP.NET is working - I tested it by running a sample =application of ChartFX.> I even did remove the write protection from these =directories: same result.> > > Today I did establish full rights =for IWAM, IUSR and ASPNET. And I did set> the default website to (All =Unassigned). NO CHANGE.> > Now I have reached the end of =the road. Please someone tell me the right way> how to define the access =rights correctly, and in which sequence, in my> case for =having> RS and SQL Server and AS installed together on 1 machine (XP pro).> => Any comments appreciated.> Helmut> > > => >
--=_NextPart_000_00B5_01C4BCC8.A27CB760--|||This is a multi-part message in MIME format.
--=_NextPart_000_000E_01C4BD93.160672A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello Wayne,
thank you for your answer - no, I haven't checked these. However the =settings were correct: The check function (for 404) was cleared already. =For the http 500 error there was no aspx extension, only one setting for =a * extension, but I guess this covers all. This was pointing to the =1.1.4322 directory.
I'm about to re-install whatever is needed to make it work. The =questions are:
1. What should I re-install ?
- Reporting Services
- SQL Server
- .NET framework
- ... ?
- Windows XP
2. which service packs should I use?
- Windows XP SP 2
- SQL Server 3a
- Reporting Services SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right direction, to the right document etc. =is welcome.
Regards,
Helmut
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> schrieb im =Newsbeitrag news:%23dx8roOvEHA.2116@.TK2MSFTNGP14.phx.gbl...
Forgive if you have already tried these:... I looked for a dot net =framework security thing, but couldn't find it... It seems like I had to =go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not found
This error indicates that there is a problem with the virtual =directory configuration. In IIS, navigate to the report server virtual =directory, and right-click Properties. On the Virtual Directory tab, =click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is =cleared.
HTTP 500 Internal server error
Reporting Services requires version 1.1.4322 of the .NET Framework. =This error can occur when the report server or Report Manager virtual =directories are mapped to version 1.0.3705. To check the application =mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable =Path value. If it is set to v1.0.3705, you must configure the virtual =directory to use 1.1.4322. Follow the instructions provided in Knowledge =Base Article 306005 to map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clq9mt$ari$1@.svr7.m-online.net...
> Hi all,
> > RS first did work for me after installation on my notebook, but some =silly
> changes of our network admin ruined everything:
> > RS does not run any more, gave me some access denied errors. =Complete RS
> Re-Installation told me at the end that it could not initialize RS: ="Setup
> could not initialize the Report Server - you must manually =initialize Report
> server before using it for the first time." But Rsactivate did not =cure it.
> It give an "
> Error starting Webservice:
> The Reportserver Webservice has not generated a public key. The =service was
> eventually not started successfully. See Log files for further =Information.
> I did look into the log files and work along half a dozen =knowledgebase
> articles and re-installed RS several times and even .NET framework. =NO
> SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed =several
> requests for the same problem - there was NEVER an answer that lead =to a
> successful solution.
> > I cannot access localhost reportserver. It keeps reporting access =rights
> problems all time. Yesterday, after looking at the .LOG files again =I gave
> full access rights to the Reporting Services directories and =everything
> below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS =again:
> > RS is running, but when I launch localhost/reportserver I get the =following
> (translated from German):
> Server error in application '/ReportServer'.
> --
> Program directory 'C:\Program files\Microsoft SQL =Server\MSSQL\Reporting
> Services\ReportServer\' cannot be accessed. The directory is not =available
> or it cannot be accessed because of safety settings.
> Description: When executing the current Web request an unprocessed =error
> occurred. Check Batch control to display further Information on this =error
> and find out where in the Code the error was caused.
> > Exception details: System.Web.HttpException: Program directory ='C:\Program
> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be
> accessed. The directory is not available or it cannot be accessed =because of
> safety settings.
> > Source error:
> When executing the current Web request an unprocessed error =occurred.
> Information on the source and the Position of the exception can be =displayed
> using the exception batch control.
> > batch control:
> [HttpException (0x80004005): Program directory 'C:\Program =files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be =accessed. The
> directory is not available or it cannot be accessed because of =safety
> settings.]
> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
> [HttpException (0x80004005): ASP.NET-Initialisation error]
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +964
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest =wr) +128
> --
> Version information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET-Version:1.1.4322.573
> > ASP.NET is working - I tested it by running a sample application of =ChartFX.
> I even did remove the write protection from these directories: same =result.
> > > Today I did establish full rights for IWAM, IUSR and ASPNET. And I =did set
> the default website to (All Unassigned). NO CHANGE.
> > Now I have reached the end of the road. Please someone tell me the =right way
> how to define the access rights correctly, and in which sequence, =in my
> case for having
> RS and SQL Server and AS installed together on 1 machine (XP pro).
> > Any comments appreciated.
> Helmut
> > > > >
--=_NextPart_000_000E_01C4BD93.160672A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello Wayne,
thank you for your answer - no, I =haven't checked these. However the settings were correct: The check function =(for 404) was cleared already. For the http 500 error there was no aspx extension, =only one setting for a * extension, but I guess this covers all. This was =pointing to the 1.1.4322 directory.
I'm about to re-install whatever is =needed to make it work. The questions are:
1. What should I re-install =?
- Reporting Services
- SQL =Server
- .NET =framework
- ... ?
- Windows =XP
2. which service packs should I =use?
- Windows XP SP =2
- SQL Server =3a
- Reporting Services =SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right =direction, to the right document etc. is welcome.
Regards,
Helmut
"Wayne Snyder" schrieb im Newsbeitrag news:%23dx8roOvEHA.=2116@.TK2MSFTNGP14.phx.gbl...
Forgive if you have already tried these:... I =looked for a dot net framework security thing, but couldn't find it... It seems =like I had to go to dot not config and set up an application security piece at =one time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not =found
This error indicates that there is a =problem with the virtual directory configuration. In IIS, navigate to the report =server virtual directory, and right-click Properties. On the Virtual =Directory tab, click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server =error
Reporting Services requires version =1.1.4322 of the .NET Framework. This error can occur when the report server or Report =Manager virtual directories are mapped to version 1.0.3705. To check the =application mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click Configuration, scroll =to the .aspx extension, and read the Executable Path value. If it is set to v1.0.3705, you must configure the virtual directory to use 1.1.4322. =Follow the instructions provided in Knowledge Base Article 306005 to map =v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL =Server MVPMariner, Charlotte, NCwww.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional =Association of SQL Server (PASS) and it'scommunity of SQL Server =professionals.www.sqlpass.org
"Helmut Knappe" wrote in message news:clq9mt$ari$1@.svr7.m-online.net...> Hi =all,> > RS first did work for me after installation on my notebook, but some silly> changes of our network admin ruined everything:> => RS does not run any more, gave me some access denied errors. Complete RS> Re-Installation told me at the end that it could not =initialize RS: "Setup> could not initialize the Report Server - you must =manually initialize Report> server before using it for the first time." =But Rsactivate did not cure it.> It give an "> Error =starting Webservice:> The Reportserver Webservice has not generated a =public key. The service was> eventually not started successfully. See =Log files for further Information.> I did look into the log files =and work along half a dozen knowledgebase> articles and re-installed RS =several times and even .NET framework. NO> SUCCESS. Answers in this =newsgroup DID NOT HELP. I've noticed several> requests for the same =problem - there was NEVER an answer that lead to a> successful =solution.> > I cannot access localhost reportserver. It keeps reporting =access rights> problems all time. Yesterday, after looking at the .LOG =files again I gave> full access rights to the Reporting Services =directories and everything> below to the LOCAL SERVICE and the SYSTEM =accounts. NO SUCCESS again:> > RS is running, but when I launch localhost/reportserver I get the following> (translated from German):> Server error in application '/ReportServer'.> --> Program directory ='C:\Program files\Microsoft SQL Server\MSSQL\Reporting> =Services\ReportServer\' cannot be accessed. The directory is not available> or it =cannot be accessed because of safety settings.> Description: When =executing the current Web request an unprocessed error> occurred. Check Batch =control to display further Information on this error> and find out =where in the Code the error was caused.> > Exception details: System.Web.HttpException: Program directory 'C:\Program> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be> accessed. The directory is not available or it cannot be =accessed because of> safety settings.> > Source =error:> When executing the current Web request an unprocessed error =occurred.> Information on the source and the Position of the exception can be displayed> using the exception batch control.> > =batch control:> [HttpException (0x80004005): Program directory ='C:\Program files\Microsoft> SQL Server\MSSQL\Reporting =Services\ReportServer\' cannot be accessed. The> directory is not available or it =cannot be accessed because of safety> settings.]> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() =+72> System.Web.HttpRuntime.FirstRequestInit(HttpContext =context) +263> [HttpException (0x80004005): ASP.NET-Initialisation error]> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) =+964> =System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128> --> Version information: Microsoft .NET Framework Version:1.1.4322.573;> ASP.NET-Version:1.1.4322.573> > ASP.NET is working - I =tested it by running a sample application of ChartFX.> I even did remove =the write protection from these directories: same result.> > = > Today I did establish full rights for IWAM, IUSR and ASPNET. =And I did set> the default website to (All Unassigned). NO =CHANGE.> > Now I have reached the end of the road. Please someone tell =me the right way> how to define the access rights correctly, and in =which sequence, in my> case for having> RS and SQL =Server and AS installed together on 1 machine (XP pro).> > Any =comments appreciated.> Helmut> > > > =>
--=_NextPart_000_000E_01C4BD93.160672A0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0080_01C4BD8D.F3B2DB80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I guess the best place to go would be here
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSINST=
ALL/htm/gs_ins_overview_v1_3rky.asp
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clsolg$i02$1@.svr7.m-online.net...
Hello Wayne,
thank you for your answer - no, I haven't checked these. However the =settings were correct: The check function (for 404) was cleared already. =For the http 500 error there was no aspx extension, only one setting for =a * extension, but I guess this covers all. This was pointing to the =1.1.4322 directory.
I'm about to re-install whatever is needed to make it work. The =questions are:
1. What should I re-install ?
- Reporting Services
- SQL Server
- .NET framework
- ... ?
- Windows XP
2. which service packs should I use?
- Windows XP SP 2
- SQL Server 3a
- Reporting Services SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right direction, to the right document etc. =is welcome.
Regards,
Helmut
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> schrieb im =Newsbeitrag news:%23dx8roOvEHA.2116@.TK2MSFTNGP14.phx.gbl...
Forgive if you have already tried these:... I looked for a dot net =framework security thing, but couldn't find it... It seems like I had to =go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not found
This error indicates that there is a problem with the virtual =directory configuration. In IIS, navigate to the report server virtual =directory, and right-click Properties. On the Virtual Directory tab, =click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is =cleared.
HTTP 500 Internal server error
Reporting Services requires version 1.1.4322 of the .NET Framework. =This error can occur when the report server or Report Manager virtual =directories are mapped to version 1.0.3705. To check the application =mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable =Path value. If it is set to v1.0.3705, you must configure the virtual =directory to use 1.1.4322. Follow the instructions provided in Knowledge =Base Article 306005 to map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clq9mt$ari$1@.svr7.m-online.net...
> Hi all,
> > RS first did work for me after installation on my notebook, but =some silly
> changes of our network admin ruined everything:
> > RS does not run any more, gave me some access denied errors. =Complete RS
> Re-Installation told me at the end that it could not initialize =RS: "Setup
> could not initialize the Report Server - you must manually =initialize Report
> server before using it for the first time." But Rsactivate did not =cure it.
> It give an "
> Error starting Webservice:
> The Reportserver Webservice has not generated a public key. The =service was
> eventually not started successfully. See Log files for further =Information.
> I did look into the log files and work along half a dozen =knowledgebase
> articles and re-installed RS several times and even .NET =framework. NO
> SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed =several
> requests for the same problem - there was NEVER an answer that =lead to a
> successful solution.
> > I cannot access localhost reportserver. It keeps reporting access =rights
> problems all time. Yesterday, after looking at the .LOG files =again I gave
> full access rights to the Reporting Services directories and =everything
> below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS =again:
> > RS is running, but when I launch localhost/reportserver I get the =following
> (translated from German):
> Server error in application '/ReportServer'.
> --
> Program directory 'C:\Program files\Microsoft SQL =Server\MSSQL\Reporting
> Services\ReportServer\' cannot be accessed. The directory is not =available
> or it cannot be accessed because of safety settings.
> Description: When executing the current Web request an unprocessed =error
> occurred. Check Batch control to display further Information on =this error
> and find out where in the Code the error was caused.
> > Exception details: System.Web.HttpException: Program directory ='C:\Program
> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be
> accessed. The directory is not available or it cannot be accessed =because of
> safety settings.
> > Source error:
> When executing the current Web request an unprocessed error =occurred.
> Information on the source and the Position of the exception can be =displayed
> using the exception batch control.
> > batch control:
> [HttpException (0x80004005): Program directory 'C:\Program =files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be =accessed. The
> directory is not available or it cannot be accessed because of =safety
> settings.]
> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) =+263
> [HttpException (0x80004005): ASP.NET-Initialisation error]
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) =+964
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest =wr) +128
> --
> Version information: Microsoft .NET Framework =Version:1.1.4322.573;
> ASP.NET-Version:1.1.4322.573
> > ASP.NET is working - I tested it by running a sample application =of ChartFX.
> I even did remove the write protection from these directories: =same result.
> > > Today I did establish full rights for IWAM, IUSR and ASPNET. And I =did set
> the default website to (All Unassigned). NO CHANGE.
> > Now I have reached the end of the road. Please someone tell me the =right way
> how to define the access rights correctly, and in which sequence, =in my
> case for having
> RS and SQL Server and AS installed together on 1 machine (XP pro).
> > Any comments appreciated.
> Helmut
> > > > >
--=_NextPart_000_0080_01C4BD8D.F3B2DB80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I guess the best place to go would be here
http://msdn.microsoft.com/li=brary/default.asp?url=3D/library/en-us/RSINSTALL/htm/gs_ins_overview_v1_3=rky.asp
-- Wayne Snyder, MCDBA, SQL Server MVPMariner, =Charlotte, NChttp://www.mariner-usa.com">www.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it'scommunity of SQL Server professionals.http://www.sqlpass.org">www.sqlpass.org
"Helmut Knappe" =wrote in message news:clsolg$i02$1@.svr7.m-onl=ine.net...
Hello Wayne,
thank you for your answer - no, I =haven't checked these. However the settings were correct: The check function =(for 404) was cleared already. For the http 500 error there was no aspx =extension, only one setting for a * extension, but I guess this covers all. This =was pointing to the 1.1.4322 directory.
I'm about to re-install whatever is =needed to make it work. The questions are:
1. What should I re-install =?
- Reporting Services
- SQL =Server
- .NET =framework
- ... =?
- Windows =XP
2. which service packs should I =use?
- Windows XP SP =2
- SQL Server =3a
- Reporting =Services SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right =direction, to the right document etc. is welcome.
Regards,
Helmut
"Wayne Snyder" schrieb im Newsbeitrag news:%23dx8roOvEHA.=2116@.TK2MSFTNGP14.phx.gbl...
Forgive if you have already tried these:... I =looked for a dot net framework security thing, but couldn't find it... It seems =like I had to go to dot not config and set up an application security piece =at one time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not =found
This error indicates that there is a =problem with the virtual directory configuration. In IIS, navigate to the report =server virtual directory, and right-click Properties. On the Virtual =Directory tab, click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server =error
Reporting Services requires version =1.1.4322 of the .NET Framework. This error can occur when the report server or =Report Manager virtual directories are mapped to version 1.0.3705. To check =the application mapping, navigate to the report server virtual =directory, and right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable Path value. =If it is set to v1.0.3705, you must configure the virtual directory to use =1.1.4322. Follow the instructions provided in Knowledge Base Article 306005 to =map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL =Server MVPMariner, Charlotte, NCwww.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional =Association of SQL Server (PASS) and it'scommunity of SQL Server professionals.www.sqlpass.org
"Helmut Knappe" wrote in message news:clq9mt$ari$1@.svr7.m-online.net...> Hi all,> > RS first did work for me after installation on =my notebook, but some silly> changes of our network admin ruined = everything:> > RS does not run any more, gave me some =access denied errors. Complete RS> Re-Installation told me at the =end that it could not initialize RS: "Setup> could not initialize the =Report Server - you must manually initialize Report> server before =using it for the first time." But Rsactivate did not cure it.> It give =an "> Error starting Webservice:> The Reportserver =Webservice has not generated a public key. The service was> eventually not =started successfully. See Log files for further Information.> I did =look into the log files and work along half a dozen knowledgebase> =articles and re-installed RS several times and even .NET framework. NO> =SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed several> = requests for the same problem - there was NEVER an answer that lead =to a> successful solution.> > I cannot access =localhost reportserver. It keeps reporting access rights> problems all =time. Yesterday, after looking at the .LOG files again I gave> full =access rights to the Reporting Services directories and everything> =below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS again:> = > RS is running, but when I launch localhost/reportserver I =get the following> (translated from German):> Server error in application '/ReportServer'.> --> Program directory ='C:\Program files\Microsoft SQL Server\MSSQL\Reporting> =Services\ReportServer\' cannot be accessed. The directory is not available> or it =cannot be accessed because of safety settings.> Description: When =executing the current Web request an unprocessed error> occurred. Check =Batch control to display further Information on this error> and =find out where in the Code the error was caused.> > Exception =details: System.Web.HttpException: Program directory 'C:\Program> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be> accessed. The directory is not available or it cannot be =accessed because of> safety settings.> > Source =error:> When executing the current Web request an unprocessed error occurred.> Information on the source and the Position of the exception can be displayed> using the exception batch control.> > batch control:> [HttpException (0x80004005): Program directory 'C:\Program files\Microsoft> =SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be accessed. The> directory is not available or it cannot be accessed =because of safety> settings.]> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() =+72> System.Web.HttpRuntime.FirstRequestInit(HttpContext =context) +263> [HttpException (0x80004005): ASP.NET-Initialisation error]> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) =+964> =System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128> --> =Version information: Microsoft .NET Framework Version:1.1.4322.573;> ASP.NET-Version:1.1.4322.573> > ASP.NET is working - I =tested it by running a sample application of ChartFX.> I even did =remove the write protection from these directories: same result.> => > Today I did establish full rights for IWAM, IUSR and =ASPNET. And I did set> the default website to (All Unassigned). NO =CHANGE.> > Now I have reached the end of the road. Please someone tell =me the right way> how to define the access rights correctly, and in =which sequence, in my> case for having> RS and SQL =Server and AS installed together on 1 machine (XP pro).> > Any =comments appreciated.> Helmut> > > > =>
--=_NextPart_000_0080_01C4BD8D.F3B2DB80--
RS first did work for me after installation on my notebook, but some silly
changes of our network admin ruined everything:
RS does not run any more, gave me some access denied errors. Complete RS
Re-Installation told me at the end that it could not initialize RS: "Setup
could not initialize the Report Server - you must manually initialize Report
server before using it for the first time." But Rsactivate did not cure it.
It give an "
Error starting Webservice:
The Reportserver Webservice has not generated a public key. The service was
eventually not started successfully. See Log files for further Information.
I did look into the log files and work along half a dozen knowledgebase
articles and re-installed RS several times and even .NET framework. NO
SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed several
requests for the same problem - there was NEVER an answer that lead to a
successful solution.
I cannot access localhost reportserver. It keeps reporting access rights
problems all time. Yesterday, after looking at the .LOG files again I gave
full access rights to the Reporting Services directories and everything
below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS again:
RS is running, but when I launch localhost/reportserver I get the following
(translated from German):
Server error in application '/ReportServer'.
--
Program directory 'C:\Program files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\' cannot be accessed. The directory is not available
or it cannot be accessed because of safety settings.
Description: When executing the current Web request an unprocessed error
occurred. Check Batch control to display further Information on this error
and find out where in the Code the error was caused.
Exception details: System.Web.HttpException: Program directory 'C:\Program
files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be
accessed. The directory is not available or it cannot be accessed because of
safety settings.
Source error:
When executing the current Web request an unprocessed error occurred.
Information on the source and the Position of the exception can be displayed
using the exception batch control.
batch control:
[HttpException (0x80004005): Program directory 'C:\Program files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be accessed. The
directory is not available or it cannot be accessed because of safety
settings.]
System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
[HttpException (0x80004005): ASP.NET-Initialisation error]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +964
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128
--
Version information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET-Version:1.1.4322.573
ASP.NET is working - I tested it by running a sample application of ChartFX.
I even did remove the write protection from these directories: same result.
Today I did establish full rights for IWAM, IUSR and ASPNET. And I did set
the default website to (All Unassigned). NO CHANGE.
Now I have reached the end of the road. Please someone tell me the right way
how to define the access rights correctly, and in which sequence, in my
case for having
RS and SQL Server and AS installed together on 1 machine (XP pro).
Any comments appreciated.
HelmutThis is a multi-part message in MIME format.
--=_NextPart_000_00B5_01C4BCC8.A27CB760
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Forgive if you have already tried these:... I looked for a dot net =framework security thing, but couldn't find it... It seems like I had to =go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not found
This error indicates that there is a problem with the virtual directory =configuration. In IIS, navigate to the report server virtual directory, =and right-click Properties. On the Virtual Directory tab, click =Configuration, select the extension, and click Edit. Make sure that =Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server error
Reporting Services requires version 1.1.4322 of the .NET Framework. This =error can occur when the report server or Report Manager virtual =directories are mapped to version 1.0.3705. To check the application =mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable =Path value. If it is set to v1.0.3705, you must configure the virtual =directory to use 1.1.4322. Follow the instructions provided in Knowledge =Base Article 306005 to map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clq9mt$ari$1@.svr7.m-online.net...
> Hi all,
> > RS first did work for me after installation on my notebook, but some =silly
> changes of our network admin ruined everything:
> > RS does not run any more, gave me some access denied errors. Complete =RS
> Re-Installation told me at the end that it could not initialize RS: ="Setup
> could not initialize the Report Server - you must manually initialize =Report
> server before using it for the first time." But Rsactivate did not =cure it.
> It give an "
> Error starting Webservice:
> The Reportserver Webservice has not generated a public key. The =service was
> eventually not started successfully. See Log files for further =Information.
> I did look into the log files and work along half a dozen =knowledgebase
> articles and re-installed RS several times and even .NET framework. NO
> SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed several
> requests for the same problem - there was NEVER an answer that lead to =a
> successful solution.
> > I cannot access localhost reportserver. It keeps reporting access =rights
> problems all time. Yesterday, after looking at the .LOG files again I =gave
> full access rights to the Reporting Services directories and =everything
> below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS again:
> > RS is running, but when I launch localhost/reportserver I get the =following
> (translated from German):
> Server error in application '/ReportServer'.
> --
> Program directory 'C:\Program files\Microsoft SQL =Server\MSSQL\Reporting
> Services\ReportServer\' cannot be accessed. The directory is not =available
> or it cannot be accessed because of safety settings.
> Description: When executing the current Web request an unprocessed =error
> occurred. Check Batch control to display further Information on this =error
> and find out where in the Code the error was caused.
> > Exception details: System.Web.HttpException: Program directory ='C:\Program
> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be
> accessed. The directory is not available or it cannot be accessed =because of
> safety settings.
> > Source error:
> When executing the current Web request an unprocessed error occurred.
> Information on the source and the Position of the exception can be =displayed
> using the exception batch control.
> > batch control:
> [HttpException (0x80004005): Program directory 'C:\Program =files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be accessed. =The
> directory is not available or it cannot be accessed because of safety
> settings.]
> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
> [HttpException (0x80004005): ASP.NET-Initialisation error]
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +964
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) =+128
> --
> Version information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET-Version:1.1.4322.573
> > ASP.NET is working - I tested it by running a sample application of =ChartFX.
> I even did remove the write protection from these directories: same =result.
> > > Today I did establish full rights for IWAM, IUSR and ASPNET. And I did =set
> the default website to (All Unassigned). NO CHANGE.
> > Now I have reached the end of the road. Please someone tell me the =right way
> how to define the access rights correctly, and in which sequence, in =my
> case for having
> RS and SQL Server and AS installed together on 1 machine (XP pro).
> > Any comments appreciated.
> Helmut
> > > > >
--=_NextPart_000_00B5_01C4BCC8.A27CB760
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Forgive if you have already tried these:... I looked =for a dot net framework security thing, but couldn't find it... It seems like I =had to go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I remember incorrectly.)
HTTP 404 File or directory not =found
This error indicates that there is a =problem with the virtual directory configuration. In IIS, navigate to the report server =virtual directory, and right-click Properties. On the Virtual Directory tab, =click Configuration, select the extension, and click Edit. Make sure that =Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server =error
Reporting Services requires version =1.1.4322 of the .NET Framework. This error can occur when the report server or Report =Manager virtual directories are mapped to version 1.0.3705. To check the =application mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click Configuration, scroll to =the .aspx extension, and read the Executable Path value. If it is set to =v1.0.3705, you must configure the virtual directory to use 1.1.4322. Follow the instructions provided in Knowledge Base Article 306005 to map v1.1.4322 =to IIS.
-- Wayne Snyder, MCDBA, SQL =Server MVPMariner, Charlotte, NCwww.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional Association =of SQL Server (PASS) and it'scommunity of SQL Server =professionals.www.sqlpass.org
"Helmut Knappe"
--=_NextPart_000_00B5_01C4BCC8.A27CB760--|||This is a multi-part message in MIME format.
--=_NextPart_000_000E_01C4BD93.160672A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello Wayne,
thank you for your answer - no, I haven't checked these. However the =settings were correct: The check function (for 404) was cleared already. =For the http 500 error there was no aspx extension, only one setting for =a * extension, but I guess this covers all. This was pointing to the =1.1.4322 directory.
I'm about to re-install whatever is needed to make it work. The =questions are:
1. What should I re-install ?
- Reporting Services
- SQL Server
- .NET framework
- ... ?
- Windows XP
2. which service packs should I use?
- Windows XP SP 2
- SQL Server 3a
- Reporting Services SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right direction, to the right document etc. =is welcome.
Regards,
Helmut
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> schrieb im =Newsbeitrag news:%23dx8roOvEHA.2116@.TK2MSFTNGP14.phx.gbl...
Forgive if you have already tried these:... I looked for a dot net =framework security thing, but couldn't find it... It seems like I had to =go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not found
This error indicates that there is a problem with the virtual =directory configuration. In IIS, navigate to the report server virtual =directory, and right-click Properties. On the Virtual Directory tab, =click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is =cleared.
HTTP 500 Internal server error
Reporting Services requires version 1.1.4322 of the .NET Framework. =This error can occur when the report server or Report Manager virtual =directories are mapped to version 1.0.3705. To check the application =mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable =Path value. If it is set to v1.0.3705, you must configure the virtual =directory to use 1.1.4322. Follow the instructions provided in Knowledge =Base Article 306005 to map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clq9mt$ari$1@.svr7.m-online.net...
> Hi all,
> > RS first did work for me after installation on my notebook, but some =silly
> changes of our network admin ruined everything:
> > RS does not run any more, gave me some access denied errors. =Complete RS
> Re-Installation told me at the end that it could not initialize RS: ="Setup
> could not initialize the Report Server - you must manually =initialize Report
> server before using it for the first time." But Rsactivate did not =cure it.
> It give an "
> Error starting Webservice:
> The Reportserver Webservice has not generated a public key. The =service was
> eventually not started successfully. See Log files for further =Information.
> I did look into the log files and work along half a dozen =knowledgebase
> articles and re-installed RS several times and even .NET framework. =NO
> SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed =several
> requests for the same problem - there was NEVER an answer that lead =to a
> successful solution.
> > I cannot access localhost reportserver. It keeps reporting access =rights
> problems all time. Yesterday, after looking at the .LOG files again =I gave
> full access rights to the Reporting Services directories and =everything
> below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS =again:
> > RS is running, but when I launch localhost/reportserver I get the =following
> (translated from German):
> Server error in application '/ReportServer'.
> --
> Program directory 'C:\Program files\Microsoft SQL =Server\MSSQL\Reporting
> Services\ReportServer\' cannot be accessed. The directory is not =available
> or it cannot be accessed because of safety settings.
> Description: When executing the current Web request an unprocessed =error
> occurred. Check Batch control to display further Information on this =error
> and find out where in the Code the error was caused.
> > Exception details: System.Web.HttpException: Program directory ='C:\Program
> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be
> accessed. The directory is not available or it cannot be accessed =because of
> safety settings.
> > Source error:
> When executing the current Web request an unprocessed error =occurred.
> Information on the source and the Position of the exception can be =displayed
> using the exception batch control.
> > batch control:
> [HttpException (0x80004005): Program directory 'C:\Program =files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be =accessed. The
> directory is not available or it cannot be accessed because of =safety
> settings.]
> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
> [HttpException (0x80004005): ASP.NET-Initialisation error]
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +964
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest =wr) +128
> --
> Version information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET-Version:1.1.4322.573
> > ASP.NET is working - I tested it by running a sample application of =ChartFX.
> I even did remove the write protection from these directories: same =result.
> > > Today I did establish full rights for IWAM, IUSR and ASPNET. And I =did set
> the default website to (All Unassigned). NO CHANGE.
> > Now I have reached the end of the road. Please someone tell me the =right way
> how to define the access rights correctly, and in which sequence, =in my
> case for having
> RS and SQL Server and AS installed together on 1 machine (XP pro).
> > Any comments appreciated.
> Helmut
> > > > >
--=_NextPart_000_000E_01C4BD93.160672A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello Wayne,
thank you for your answer - no, I =haven't checked these. However the settings were correct: The check function =(for 404) was cleared already. For the http 500 error there was no aspx extension, =only one setting for a * extension, but I guess this covers all. This was =pointing to the 1.1.4322 directory.
I'm about to re-install whatever is =needed to make it work. The questions are:
1. What should I re-install =?
- Reporting Services
- SQL =Server
- .NET =framework
- ... ?
- Windows =XP
2. which service packs should I =use?
- Windows XP SP =2
- SQL Server =3a
- Reporting Services =SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right =direction, to the right document etc. is welcome.
Regards,
Helmut
"Wayne Snyder"
Forgive if you have already tried these:... I =looked for a dot net framework security thing, but couldn't find it... It seems =like I had to go to dot not config and set up an application security piece at =one time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not =found
This error indicates that there is a =problem with the virtual directory configuration. In IIS, navigate to the report =server virtual directory, and right-click Properties. On the Virtual =Directory tab, click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server =error
Reporting Services requires version =1.1.4322 of the .NET Framework. This error can occur when the report server or Report =Manager virtual directories are mapped to version 1.0.3705. To check the =application mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click Configuration, scroll =to the .aspx extension, and read the Executable Path value. If it is set to v1.0.3705, you must configure the virtual directory to use 1.1.4322. =Follow the instructions provided in Knowledge Base Article 306005 to map =v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL =Server MVPMariner, Charlotte, NCwww.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional =Association of SQL Server (PASS) and it'scommunity of SQL Server =professionals.www.sqlpass.org
"Helmut Knappe"
--=_NextPart_000_000E_01C4BD93.160672A0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0080_01C4BD8D.F3B2DB80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I guess the best place to go would be here
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSINST=
ALL/htm/gs_ins_overview_v1_3rky.asp
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clsolg$i02$1@.svr7.m-online.net...
Hello Wayne,
thank you for your answer - no, I haven't checked these. However the =settings were correct: The check function (for 404) was cleared already. =For the http 500 error there was no aspx extension, only one setting for =a * extension, but I guess this covers all. This was pointing to the =1.1.4322 directory.
I'm about to re-install whatever is needed to make it work. The =questions are:
1. What should I re-install ?
- Reporting Services
- SQL Server
- .NET framework
- ... ?
- Windows XP
2. which service packs should I use?
- Windows XP SP 2
- SQL Server 3a
- Reporting Services SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right direction, to the right document etc. =is welcome.
Regards,
Helmut
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> schrieb im =Newsbeitrag news:%23dx8roOvEHA.2116@.TK2MSFTNGP14.phx.gbl...
Forgive if you have already tried these:... I looked for a dot net =framework security thing, but couldn't find it... It seems like I had to =go to dot not config and set up an application security piece at one =time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not found
This error indicates that there is a problem with the virtual =directory configuration. In IIS, navigate to the report server virtual =directory, and right-click Properties. On the Virtual Directory tab, =click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is =cleared.
HTTP 500 Internal server error
Reporting Services requires version 1.1.4322 of the .NET Framework. =This error can occur when the report server or Report Manager virtual =directories are mapped to version 1.0.3705. To check the application =mapping, navigate to the report server virtual directory, and =right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable =Path value. If it is set to v1.0.3705, you must configure the virtual =directory to use 1.1.4322. Follow the instructions provided in Knowledge =Base Article 306005 to map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Helmut Knappe" <HK_noSPAM@.biware.com> wrote in message =news:clq9mt$ari$1@.svr7.m-online.net...
> Hi all,
> > RS first did work for me after installation on my notebook, but =some silly
> changes of our network admin ruined everything:
> > RS does not run any more, gave me some access denied errors. =Complete RS
> Re-Installation told me at the end that it could not initialize =RS: "Setup
> could not initialize the Report Server - you must manually =initialize Report
> server before using it for the first time." But Rsactivate did not =cure it.
> It give an "
> Error starting Webservice:
> The Reportserver Webservice has not generated a public key. The =service was
> eventually not started successfully. See Log files for further =Information.
> I did look into the log files and work along half a dozen =knowledgebase
> articles and re-installed RS several times and even .NET =framework. NO
> SUCCESS. Answers in this newsgroup DID NOT HELP. I've noticed =several
> requests for the same problem - there was NEVER an answer that =lead to a
> successful solution.
> > I cannot access localhost reportserver. It keeps reporting access =rights
> problems all time. Yesterday, after looking at the .LOG files =again I gave
> full access rights to the Reporting Services directories and =everything
> below to the LOCAL SERVICE and the SYSTEM accounts. NO SUCCESS =again:
> > RS is running, but when I launch localhost/reportserver I get the =following
> (translated from German):
> Server error in application '/ReportServer'.
> --
> Program directory 'C:\Program files\Microsoft SQL =Server\MSSQL\Reporting
> Services\ReportServer\' cannot be accessed. The directory is not =available
> or it cannot be accessed because of safety settings.
> Description: When executing the current Web request an unprocessed =error
> occurred. Check Batch control to display further Information on =this error
> and find out where in the Code the error was caused.
> > Exception details: System.Web.HttpException: Program directory ='C:\Program
> files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\' =cannot be
> accessed. The directory is not available or it cannot be accessed =because of
> safety settings.
> > Source error:
> When executing the current Web request an unprocessed error =occurred.
> Information on the source and the Position of the exception can be =displayed
> using the exception batch control.
> > batch control:
> [HttpException (0x80004005): Program directory 'C:\Program =files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\' cannot be =accessed. The
> directory is not available or it cannot be accessed because of =safety
> settings.]
> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) =+263
> [HttpException (0x80004005): ASP.NET-Initialisation error]
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) =+964
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest =wr) +128
> --
> Version information: Microsoft .NET Framework =Version:1.1.4322.573;
> ASP.NET-Version:1.1.4322.573
> > ASP.NET is working - I tested it by running a sample application =of ChartFX.
> I even did remove the write protection from these directories: =same result.
> > > Today I did establish full rights for IWAM, IUSR and ASPNET. And I =did set
> the default website to (All Unassigned). NO CHANGE.
> > Now I have reached the end of the road. Please someone tell me the =right way
> how to define the access rights correctly, and in which sequence, =in my
> case for having
> RS and SQL Server and AS installed together on 1 machine (XP pro).
> > Any comments appreciated.
> Helmut
> > > > >
--=_NextPart_000_0080_01C4BD8D.F3B2DB80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I guess the best place to go would be here
http://msdn.microsoft.com/li=brary/default.asp?url=3D/library/en-us/RSINSTALL/htm/gs_ins_overview_v1_3=rky.asp
-- Wayne Snyder, MCDBA, SQL Server MVPMariner, =Charlotte, NChttp://www.mariner-usa.com">www.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it'scommunity of SQL Server professionals.http://www.sqlpass.org">www.sqlpass.org
"Helmut Knappe"
Hello Wayne,
thank you for your answer - no, I =haven't checked these. However the settings were correct: The check function =(for 404) was cleared already. For the http 500 error there was no aspx =extension, only one setting for a * extension, but I guess this covers all. This =was pointing to the 1.1.4322 directory.
I'm about to re-install whatever is =needed to make it work. The questions are:
1. What should I re-install =?
- Reporting Services
- SQL =Server
- .NET =framework
- ... =?
- Windows =XP
2. which service packs should I =use?
- Windows XP SP =2
- SQL Server =3a
- Reporting =Services SP 1
- ...
3. in which sequence should I re-install?
4. which accounts should I use for what?
Any answer pointing in the right =direction, to the right document etc. is welcome.
Regards,
Helmut
"Wayne Snyder"
Forgive if you have already tried these:... I =looked for a dot net framework security thing, but couldn't find it... It seems =like I had to go to dot not config and set up an application security piece =at one time... Sorry but I could not find any info on that ( perhaps I =remember incorrectly.)
HTTP 404 File or directory not =found
This error indicates that there is a =problem with the virtual directory configuration. In IIS, navigate to the report =server virtual directory, and right-click Properties. On the Virtual =Directory tab, click Configuration, select the extension, and click Edit. Make sure =that Check that the file exists (or Verify that the file exists) is cleared.
HTTP 500 Internal server =error
Reporting Services requires version =1.1.4322 of the .NET Framework. This error can occur when the report server or =Report Manager virtual directories are mapped to version 1.0.3705. To check =the application mapping, navigate to the report server virtual =directory, and right-click Properties. On the Virtual Directory tab, click =Configuration, scroll to the .aspx extension, and read the Executable Path value. =If it is set to v1.0.3705, you must configure the virtual directory to use =1.1.4322. Follow the instructions provided in Knowledge Base Article 306005 to =map v1.1.4322 to IIS.
-- Wayne Snyder, MCDBA, SQL =Server MVPMariner, Charlotte, NCwww.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional =Association of SQL Server (PASS) and it'scommunity of SQL Server professionals.www.sqlpass.org
"Helmut Knappe"
--=_NextPart_000_0080_01C4BD8D.F3B2DB80--
Subscribe to:
Posts (Atom)