Showing posts with label reportserver. Show all posts
Showing posts with label reportserver. Show all posts

Thursday, March 29, 2012

Error loading http://localhost/ReportServer

Hi!

I've installed the Report Server but when I try to go to http://localhost/ReportServer I get the following error:

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

And the log in the c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDUMPER_ERRORLOG.log file is this:

12/01/06 12:51:40, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 5344
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0A0F2A04
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Archivos de programa\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0058.mdmp
12/01/06 12:51:42, ACTION, aspnet_wp.exe, Watson Invoke: No

Does anybody have which could be the problem?

Thanks in advance! :)

Tomas,

I have the exact same problem. Did you ever solve your problem?

|||

Hi Chuck,

Yes, I solved this problem deleting from the web.config (folders ReportServer and/or ReportManaget) this:

xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0

If you have more problems (I had :) ) tell me and I'll try to help you: eltommy@.gmail.com

Good luck!!!

|||

Hi Tomás

I′m having the same problem

When I go to Initialization in Configure Reporting Server the error is :

There was an error while switching panels. The most likely cause is an error retrieving VMI properties. The exceptions details are:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I didn′t found the line that you mentioned

Bellow is my web.config. I tried to erase :xmlns="urn:schemas-microsoft-com:asm.v1, but I haven′t success.

Thanks in advance

Consuelo

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="MicrosoftWebControls" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"/>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics"/>
<section name="UIConfig" type="Microsoft.ReportingServices.UI.UIConfigSectionHandler,ReportingServicesWebUserInterface"/>
</configSections>
<system.net>
<defaultProxy enabled="false"/>
</system.net>
<system.web>
<pages validateRequest="false"/>
<compilation defaultLanguage="c#" debug="false"/>
<customErrors mode="Off"/>
<authentication mode="Windows"/>
<identity impersonate="true"/>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
<sessionState mode="InProc" cookieless="false" timeout="20"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<httpRuntime executionTimeout="9000"/>
<securityPolicy>
<trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
</securityPolicy>
<trust level="RosettaMgr" originUrl=""/>
<httpHandlers>
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</httpHandlers>
</system.web>
<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</appSettings>
<RStrace>
<add name="FileName" value="ReportServerWebApp_"/>
<add name="Prefix" value="tid, time"/>
<add name="TraceListeners" value="debugwindow, file"/>
<add name="TraceFileMode" value="unique"/>
<add name="Components" value="all"/>
</RStrace>
<system.diagnostics>
<switches>
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch" value="3"/>
</switches>
</system.diagnostics>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
<bindingRedirect oldVersion="8.0.242.0" newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

|||

I found a solution

I was with SQL SERVER 2000 and 2005 installed. I desinstalled both and erased ReportServer and Reports folders in IIS, after that installed just SQL SERVER 2005. Now it′s ok.

|||I'm very happy about you Consuelo, this kind of issues are very stressing and in your case it was difficult to find the solution. Congratulations!!! :)sql

Error loading http://localhost/ReportServer

Hi!

I've installed the Report Server but when I try to go to http://localhost/ReportServer I get the following error:

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

And the log in the c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDUMPER_ERRORLOG.log file is this:

12/01/06 12:51:40, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 5344
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0A0F2A04
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Archivos de programa\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0058.mdmp
12/01/06 12:51:42, ACTION, aspnet_wp.exe, Watson Invoke: No

Does anybody have which could be the problem?

Thanks in advance! :)

Tomas,

I have the exact same problem. Did you ever solve your problem?

|||

Hi Chuck,

Yes, I solved this problem deleting from the web.config (folders ReportServer and/or ReportManaget) this:

xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0

If you have more problems (I had :) ) tell me and I'll try to help you: eltommy@.gmail.com

Good luck!!!

|||

Hi Tomás

I′m having the same problem

When I go to Initialization in Configure Reporting Server the error is :

There was an error while switching panels. The most likely cause is an error retrieving VMI properties. The exceptions details are:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I didn′t found the line that you mentioned

Bellow is my web.config. I tried to erase :xmlns="urn:schemas-microsoft-com:asm.v1, but I haven′t success.

Thanks in advance

Consuelo

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="MicrosoftWebControls" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"/>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics"/>
<section name="UIConfig" type="Microsoft.ReportingServices.UI.UIConfigSectionHandler,ReportingServicesWebUserInterface"/>
</configSections>
<system.net>
<defaultProxy enabled="false"/>
</system.net>
<system.web>
<pages validateRequest="false"/>
<compilation defaultLanguage="c#" debug="false"/>
<customErrors mode="Off"/>
<authentication mode="Windows"/>
<identity impersonate="true"/>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
<sessionState mode="InProc" cookieless="false" timeout="20"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<httpRuntime executionTimeout="9000"/>
<securityPolicy>
<trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
</securityPolicy>
<trust level="RosettaMgr" originUrl=""/>
<httpHandlers>
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</httpHandlers>
</system.web>
<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</appSettings>
<RStrace>
<add name="FileName" value="ReportServerWebApp_"/>
<add name="Prefix" value="tid, time"/>
<add name="TraceListeners" value="debugwindow, file"/>
<add name="TraceFileMode" value="unique"/>
<add name="Components" value="all"/>
</RStrace>
<system.diagnostics>
<switches>
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch" value="3"/>
</switches>
</system.diagnostics>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
<bindingRedirect oldVersion="8.0.242.0" newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

|||

I found a solution

I was with SQL SERVER 2000 and 2005 installed. I desinstalled both and erased ReportServer and Reports folders in IIS, after that installed just SQL SERVER 2005. Now it′s ok.

|||I'm very happy about you Consuelo, this kind of issues are very stressing and in your case it was difficult to find the solution. Congratulations!!! :)

Monday, March 26, 2012

Error Installing RS with exising DB

I am getting the following error while attempting to install RS on a Small
Business Server 2000 box that already contains the ReportServer DB from a
previous setup where the Web portion of RS resided on another box.
The error is:
"A database with the specified name (ReportServer) already exists and is not
a valid report server database. You must either remote the existing database
or select a new database name."
What may be wrong?
Tx
AndyRS won't allow you to install onto a DB that already exists locally. If the
RS that used this database is not needed anymore, then just delete it (and
the temp database associated with it), then you can install. Or you can just
select a new name for the database when running setup.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Schmidt" <andys@.minunteclinic.com> wrote in message
news:ub2%23zNz$EHA.1296@.TK2MSFTNGP10.phx.gbl...
>I am getting the following error while attempting to install RS on a Small
> Business Server 2000 box that already contains the ReportServer DB from a
> previous setup where the Web portion of RS resided on another box.
> The error is:
> "A database with the specified name (ReportServer) already exists and is
> not
> a valid report server database. You must either remote the existing
> database
> or select a new database name."
> What may be wrong?
> Tx
> Andy
>|||Daniel,
I don't want to re-create all of the folder structure, permissions, etc. If
I create a new db is there a way to import from the old db's tables?
Tx
Andy
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:#6$JXoAAFHA.204@.TK2MSFTNGP10.phx.gbl...
> RS won't allow you to install onto a DB that already exists locally. If
the
> RS that used this database is not needed anymore, then just delete it (and
> the temp database associated with it), then you can install. Or you can
just
> select a new name for the database when running setup.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Andy Schmidt" <andys@.minunteclinic.com> wrote in message
> news:ub2%23zNz$EHA.1296@.TK2MSFTNGP10.phx.gbl...
> >I am getting the following error while attempting to install RS on a
Small
> > Business Server 2000 box that already contains the ReportServer DB from
a
> > previous setup where the Web portion of RS resided on another box.
> >
> > The error is:
> >
> > "A database with the specified name (ReportServer) already exists and is
> > not
> > a valid report server database. You must either remote the existing
> > database
> > or select a new database name."
> >
> > What may be wrong?
> >
> > Tx
> > Andy
> >
> >
>|||You can use rsconfig to point to the old database after you install to a new
database. Just make sure that both db schemas are the same. That is if the
original DB is SP1 make sure to upgrade the new one to SP1 before using
rsconfig. You will most likely then have issues with reading encrypted
data. If you saved off your symmetric key from the old installation, after
using rsconfig you can import the key using rskeymgmt. If you did not save
the old symmetric key, after running rsconfig, run rskeymgmt -d. This will
delete all encrypted data from RS. That means you will need to enter all
your report/data source credential again.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Schmidt" <andys@.minunteclinic.com> wrote in message
news:Ohy1KViAFHA.2316@.TK2MSFTNGP15.phx.gbl...
> Daniel,
> I don't want to re-create all of the folder structure, permissions, etc.
> If
> I create a new db is there a way to import from the old db's tables?
> Tx
> Andy
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:#6$JXoAAFHA.204@.TK2MSFTNGP10.phx.gbl...
>> RS won't allow you to install onto a DB that already exists locally. If
> the
>> RS that used this database is not needed anymore, then just delete it
>> (and
>> the temp database associated with it), then you can install. Or you can
> just
>> select a new name for the database when running setup.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Andy Schmidt" <andys@.minunteclinic.com> wrote in message
>> news:ub2%23zNz$EHA.1296@.TK2MSFTNGP10.phx.gbl...
>> >I am getting the following error while attempting to install RS on a
> Small
>> > Business Server 2000 box that already contains the ReportServer DB from
> a
>> > previous setup where the Web portion of RS resided on another box.
>> >
>> > The error is:
>> >
>> > "A database with the specified name (ReportServer) already exists and
>> > is
>> > not
>> > a valid report server database. You must either remote the existing
>> > database
>> > or select a new database name."
>> >
>> > What may be wrong?
>> >
>> > Tx
>> > Andy
>> >
>> >
>>
>sql