Showing posts with label services. Show all posts
Showing posts with label services. 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!!! :)

Tuesday, March 27, 2012

Error installing SQL Server 2005 SP1 - Reporting Services - log excerpt included

Hello, any information about this issue would certainly be appreciated! I've been trying to install SP1 for my SQL Server 2005. There is a failure for the reporting services which appears in the following text from the log:

--

MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Executing op: CacheBaselineFile(Baseline=0,FileKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,FilePath=C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\Bin\ReportingServicesWebUserInterface.dll,,Existing=1)
MSI (s) (7C:38) [13:43:05:433]: Note: 1: 2318 2: C:\WINDOWS\Installer\$PatchCache$\Managed\E281BDB31738DB64CA931CA4195DEE8F\9.0.1399\RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587
MSI (s) (7C:38) [13:43:05:621]: Executing op: FileCopy(SourceName=WebUse~1.dll|ReportingServicesWebUserInterface.dll,SourceCabKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,DestName=ReportingServicesWebUserInterface.dll,Attributes=20992,FileSize=1235744,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=9.0.2047.0,Language=0,InstallMode=58982400,,,,,,,)
MSI (s) (7C:38) [13:43:05:621]: File: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\Bin\ReportingServicesWebUserInterface.dll; Overwrite; Won't patch; Existing file is a lower version
MSI (s) (7C:38) [13:43:05:621]: Source for file 'RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587' is compressed
MSI (s) (7C:38) [13:43:05:636]: Re-applying security from existing file.
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2318 2: C:\Config.Msi\73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Using source file security for destination.
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 1310 2: 5 3: C:\Config.Msi\73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Product: Microsoft SQL Server 2005 Reporting Services -- Error 1310. Error writing to file: C:\Config.Msi\73537e.rbf. System error 5. Verify that you have access to that directory.

Error 1310. Error writing to file: C:\Config.Msi\73537e.rbf. System error 5. Verify that you have access to that directory.
MSI (s) (7C:38) [13:43:05:730]: User policy value 'DisableRollback' is 0
MSI (s) (7C:38) [13:43:05:730]: Machine policy value 'DisableRollback' is 0
Action ended 13:43:05: InstallFinalize. Return value 3.
MSI (s) (7C:38) [13:43:05:746]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=892169565,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005 Reporting Services)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\73536e.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\73536f.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735370.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735371.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735372.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735373.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735374.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735375.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735376.rbf)

--

Please note that I develop reports locally against a database on another server; would this be part of the problem? Let me know if you need more info, too. Thanks.

Hi !

Did you check the following ones:

You receive an "Error 1303. The installer has insufficient privileges to
access this directory" error message when you
http://support.microsoft.com/default.aspx?scid=kb;en-us;228658


You receive the "Error 1303" error message when you try to install
http://support.microsoft.com/default.aspx?scid=kb;en-us;836194


HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||Hi Jens, the first link was the problem! The install completed successfully now. Thank you for your help!

Error installing SQL 2005 Reporting Services September CTP

When installing the September SQL 2005 CTP, the installation of
Reporting Services fails with the message: "The setup has encountered
an unexpected error while Setting reporting service and share point
exclusion path. The error is: Fatal error during installation."
Here's the section from the log:
---
<Func Name='LaunchFunction'>
Function=Do_RSSetSharePointExclusionPath
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_RSSetSharePointExclusionPath
PerfTime Start: Do_RSSetSharePointExclusionPath : Thu Oct 06 12:48:54
2005
<Func Name='Do_RSSetSharePointExclusionPath'>
Error Code: 0x80077374 (29556)
Windows Error Text: Source File Name: sqlca\sqliisca.cpp
Compiler Timestamp: Tue Aug 30 21:43:12 2005
Function Name: Do_RSSetSharePointExclusionPath
Source Line Number: 840
Error Code: 29556
MSI (s) (88!68) [12:57:42:934]: Product: Microsoft SQL Server 2005
Reporting Services CTP -- Error 29528. The setup has encountered an
unexpected error while Setting reporting service and share point
exclusion path. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while
Setting reporting service and share point exclusion path. The error is:
Fatal error during installation.
--
Sharepoint (not sure if that's what is referred to by "share point" up
above) is installed and working on the box in question. Any thoughts?
KenWell, I appear to have worked around it by uninstalling SharePoint
(both the "portal" and the "services" flavors). I reran setup, and it
worked that time. Luckily I didn't need SP on this box (yeah, yeah,
and it's still beta . . . )
Ken|||On 6 Oct 2005 13:11:22 -0700, smithkl42@.hotmail.com wrote:
>When installing the September SQL 2005 CTP, the installation of
>Reporting Services fails with the message: "The setup has encountered
>an unexpected error while Setting reporting service and share point
>exclusion path. The error is: Fatal error during installation."
>Here's the section from the log:
>---
><Func Name='LaunchFunction'>
>Function=Do_RSSetSharePointExclusionPath
><Func Name='GetCAContext'>
><EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
>Doing Action: Do_RSSetSharePointExclusionPath
>PerfTime Start: Do_RSSetSharePointExclusionPath : Thu Oct 06 12:48:54
>2005
><Func Name='Do_RSSetSharePointExclusionPath'>
> Error Code: 0x80077374 (29556)
>Windows Error Text: Source File Name: sqlca\sqliisca.cpp
>Compiler Timestamp: Tue Aug 30 21:43:12 2005
> Function Name: Do_RSSetSharePointExclusionPath
>Source Line Number: 840
>
>Error Code: 29556
>MSI (s) (88!68) [12:57:42:934]: Product: Microsoft SQL Server 2005
>Reporting Services CTP -- Error 29528. The setup has encountered an
>unexpected error while Setting reporting service and share point
>exclusion path. The error is: Fatal error during installation.
>
>Error 29528. The setup has encountered an unexpected error while
>Setting reporting service and share point exclusion path. The error is:
>Fatal error during installation.
>--
>Sharepoint (not sure if that's what is referred to by "share point" up
>above) is installed and working on the box in question. Any thoughts?
>Ken
Ken,
I tried a few times to get Reporting Services 2005 and Windows
SharePoint Services 2 working on the same box and failed with earlier
builds.
The specific problem you are seeing, I guess, is that say
http://localhost/reports and http://localhost/reportserver need to be
excluded paths (if I remember the terminology correctly in WSS2) on a
SharePoint server.
You need to find the Managed Paths screen to create the excluded
paths.
That's the first step, I think.
Andrew Watt
MVP - InfoPath

Monday, March 26, 2012

error installing RS

I try sql setup newsgroup but nobody answer.
Hi,
I have a SQL server dev edition in windows XP pro, I wan to install
Reporting Services but I have an error at the end "error code 25619".
It creates two databases--> ReportServer and ReportServerTempDB.
How can I pass this error? Any ideas?
Tks in advance
JohnnyEnable IWAM_ComputerName account if it is disabled. Also, if Distributed
Transaction Coordinator service is not running, start it. Then rerun Setup.
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JFB" <jfb@.newSQL.com> wrote in message
news:%23IYqsSHWEHA.4024@.TK2MSFTNGP09.phx.gbl...
> I try sql setup newsgroup but nobody answer.
> Hi,
> I have a SQL server dev edition in windows XP pro, I wan to install
> Reporting Services but I have an error at the end "error code 25619".
> It creates two databases--> ReportServer and ReportServerTempDB.
> How can I pass this error? Any ideas?
> Tks in advance
> Johnny
>|||Tks for reply Ravi... I got it, the DTC was off.
Johnny
"Ravi Mumulla (Microsoft)" <ravimu@.microsoft.com> wrote in message
news:%231aZ6NJWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> Enable IWAM_ComputerName account if it is disabled. Also, if Distributed
> Transaction Coordinator service is not running, start it. Then rerun
Setup.
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "JFB" <jfb@.newSQL.com> wrote in message
> news:%23IYqsSHWEHA.4024@.TK2MSFTNGP09.phx.gbl...
> > I try sql setup newsgroup but nobody answer.
> >
> > Hi,
> > I have a SQL server dev edition in windows XP pro, I wan to install
> > Reporting Services but I have an error at the end "error code 25619".
> > It creates two databases--> ReportServer and ReportServerTempDB.
> > How can I pass this error? Any ideas?
> > Tks in advance
> > Johnny
> >
> >
>

Error installing Reporting Services

Hi,
Trying to install the developer's version of Reporting Services on Windows
2003 Server with SQL Server 2000 SP3.
I click on SETUP.EXE and the very first dialog box comes up and says:
Software components to install:
>Microsoft SQL Server Reporting Services Setup Support Files
Error!
Cancel is the only option.
Any ideas?
Thx.
Andy JacobsTry copying the install Dir to the local machine and running from there.
"Andy Jacobs" <Andy Jacobs@.discussions.microsoft.com> wrote in message
news:0F5ABAE6-C353-4C14-951C-1E577F73B814@.microsoft.com...
> Hi,
> Trying to install the developer's version of Reporting Services on Windows
> 2003 Server with SQL Server 2000 SP3.
> I click on SETUP.EXE and the very first dialog box comes up and says:
> Software components to install:
> >Microsoft SQL Server Reporting Services Setup Support Files
> Error!
> Cancel is the only option.
> Any ideas?
> Thx.
> Andy Jacobs
>
>|||I don't know why, but this is very slooooooooooow. As you say, the install
form displays only a cancel button. Wait... Go get a cup of coffee... Tell
the joke of the day to the guy in the next cube... The continue button will
be displayed in a Microsoft second. I think this bad design by Bill's boys.
The cancel button should not be enabled until the install software figures
out what it's going to allow. A lot of folks probably hit Cancel
prematurely.
"Andy Jacobs" <Andy Jacobs@.discussions.microsoft.com> wrote in message
news:0F5ABAE6-C353-4C14-951C-1E577F73B814@.microsoft.com...
> Hi,
> Trying to install the developer's version of Reporting Services on Windows
> 2003 Server with SQL Server 2000 SP3.
> I click on SETUP.EXE and the very first dialog box comes up and says:
> Software components to install:
> >Microsoft SQL Server Reporting Services Setup Support Files
> Error!
> Cancel is the only option.
> Any ideas?
> Thx.
> Andy Jacobs
>
>

Error Installing Reporting Services

Hi all,
I'm currently installing Reporting Services Enterprise Edition in one
computer that use :
- Windows 2000 Server+SP4
- SQL Server Standard Edition
And I've got errors during installation :
Package 'VsRptDesigner Package' has failed to load properly ( GUID = ...
Package 'ACT Project Package' has failed to load properly ( GUID = ...
Package 'ReportDesignerPackage' has failed to load properly ( GUID = ...
Package 'DataWarehouse VSIntegration layer' has failed to load properly
( GUID = ...
Now, I cannot load Ms. Visual Studio.NET at all. My question is :
1. How to solve this problem?
2. Is it wrong to install Report Server, Report Manager & Report
Designer in one computer?
Please help,
ThanksLook here:
http://support.microsoft.com/?id=823245
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Resant" <resant_v@.yahoo.com> schrieb im Newsbeitrag
news:1113891129.326782.188330@.l41g2000cwc.googlegroups.com...
> Hi all,
> I'm currently installing Reporting Services Enterprise Edition in one
> computer that use :
> - Windows 2000 Server+SP4
> - SQL Server Standard Edition
> And I've got errors during installation :
> Package 'VsRptDesigner Package' has failed to load properly ( GUID => ...
> Package 'ACT Project Package' has failed to load properly ( GUID = ...
> Package 'ReportDesignerPackage' has failed to load properly ( GUID => ...
> Package 'DataWarehouse VSIntegration layer' has failed to load properly
> ( GUID = ...
> Now, I cannot load Ms. Visual Studio.NET at all. My question is :
> 1. How to solve this problem?
> 2. Is it wrong to install Report Server, Report Manager & Report
> Designer in one computer?
> Please help,
> Thanks
>|||Thanks for your answer.
I've tried that suggested solution before I post this question and
still doesn't work.
But the Protected Storage have ran already after VS.NET installation
but I restart it as wanted and nothing changed.
I forgot to mention that I've install VS.NET successfully at WinXP at
the same computer, but failed at Win 2000+SP4.
Any other suggestion?
Thanks|||Thanks for your answer.
I've tried that suggested solution before I post this question and
still doesn't work.
But the Protected Storage have ran already after VS.NET installation
but I restart it as wanted and nothing changed.
I forgot to mention that I've install VS.NET successfully at WinXP at
the same computer, but failed at Win 2000+SP4.
Any other suggestion?
Thanks

Error Installing Reporting Services

I attempt to run the Reporting Services installation and
get and on the screen right after the license agreement, I
get a message that says just "Error!" and I cannot
continue. Is there a log file somewhere I can look at -
nothing was installed so no directory exists on the hard
disk. I am running Windows 2000, .NET 1.1 framework, and
SQL Server 2000 Development with latest service pack.Here is the contents of a file I found in the temp
directory that appears to have an error at the bottom:
Microsoft SQL Server 2000 Reporting Services Setup
beginning at Mon Sep 13 09:50:33 2004
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
.
.
.
QuietMode=false
Unattended=false
WorkDir=H:
}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:
292}
<Func Name='SqlSetupFilesComp::Install'>
SqlSetupFilesComp WNetGetUniversalName() returned : (1201)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:
449}
SCU_SetupMgr::svc() caught exception: SqlSetupFilesComp
WNetGetUniversalName() returned : (1201)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:
449}. SetupMgr: state=ERROR, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=H:
QuietMode=false
Unattended=false
WorkDir=H:
}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:
428}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting
for setup mgr
<EndFunc Name='UpdateComponents' Return='1602'
GetLastError='1400'>

Monday, March 19, 2012

Error in Reporting Services Configuration Manager

Hello

I've got an error when I want to initialize the Report Server by means of RS Configuration Manager.

All points are check in green except "Encryption Keys" that is in "Optionnal configuration" and "Initialization" that is in "Not Configured".

When I click on "Initialization" an error occured :

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

When I want to browse the report this error occured:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError). Cannot generate SSPI context.

Someone can help me ?

Thanks

Arnaud

I am having the same problem.

|||First make sure you have correctly entered and apply the information on the "database setup" panel. I think the "Cannot generate SSPI context" error may contain a clue. A quick search found the following kb: http://support.microsoft.com/?id=811889. Let us know if it helps.

Error in Reporting Services Configuration Manager

Hello

I've got an error when I want to initialize the Report Server by means of RS Configuration Manager.

All points are check in green except "Encryption Keys" that is in "Optionnal configuration" and "Initialization" that is in "Not Configured".

When I click on "Initialization" an error occured :

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

When I want to browse the report this error occured:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError). Cannot generate SSPI context.

Someone can help me ?

Thanks

Arnaud

I am having the same problem.

|||First make sure you have correctly entered and apply the information on the "database setup" panel. I think the "Cannot generate SSPI context" error may contain a clue. A quick search found the following kb: http://support.microsoft.com/?id=811889. Let us know if it helps.

Error in reporting services

hi,

i am facing a problem in reporting services of Sql server 2005

i am trying to run the "third party tool"(Reports of proclarity) in sql server 2005

and i am getting the following error

An error has occurred during report processing.
Cannot create a connection to data source 'Employees_'.
Cannot connect to the server 'SYSTEM100'. The server is either not started or too busy.
Property name was not recognized, 'MDX Missing Member Mode'

regards

lalitha

This is a bit of a guess, since I don't really know much about how Proclarity works with Reporting Services, but given that 'MDX Missing Member Mode' is a valid connection string property that only appeared with AS2005 are you perhaps trying to connect to Analysis Services using an older version of the OLEDB for OLAP Provider? You should be using MSOLAP.3; if you don't have it installed, you can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Chris

|||

Hi Lalitha,

Check the connection string of your report (click the "Properties" tab and then select "Data Source" from the list on the left). Your connection string probably looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP;MDX Compatibility=2;MDX Missing Member Mode=Error

You need to change the "Provider" portion of the connection string from "MSOLAP" to "MSOLAP.3" so your connection string now looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP.3;MDX Compatibility=2;MDX Missing Member Mode=Error

Hope this helps,

Joe Hayes

Error in reporting services

hi,

i am facing a problem in reporting services of Sql server 2005

i am trying to run the "third party tool"(Reports of proclarity) in sql server 2005

and i am getting the following error

An error has occurred during report processing.
Cannot create a connection to data source 'Employees_'.
Cannot connect to the server 'SYSTEM100'. The server is either not started or too busy.
Property name was not recognized, 'MDX Missing Member Mode'

regards

lalitha

This is a bit of a guess, since I don't really know much about how Proclarity works with Reporting Services, but given that 'MDX Missing Member Mode' is a valid connection string property that only appeared with AS2005 are you perhaps trying to connect to Analysis Services using an older version of the OLEDB for OLAP Provider? You should be using MSOLAP.3; if you don't have it installed, you can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Chris

|||

Hi Lalitha,

Check the connection string of your report (click the "Properties" tab and then select "Data Source" from the list on the left). Your connection string probably looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP;MDX Compatibility=2;MDX Missing Member Mode=Error

You need to change the "Provider" portion of the connection string from "MSOLAP" to "MSOLAP.3" so your connection string now looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP.3;MDX Compatibility=2;MDX Missing Member Mode=Error

Hope this helps,

Joe Hayes

Error in report services

Hi all,

I am getting the following error when iam trying to deploy my reports on a remote report server (remote machine).can anyone help me in this regard?its very urgent.

The permissions granted to user 'domainname\userid' are insufficient for performing this operation.

Thanks in advance.

Hi,

the user has to be at miminum in the publisher role. Otherwise he won′t be able to make a call to the webservice.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

error in report builder

I am trying to create a filter in the report builder on reporting services. When I try to filter I get a yellow triangle with an exclamation point and cannot get a list. When i put my cursor over the yellow triangle, I get the error "the requested list could not be retrived because the query is not valid or a connection could not be made to the data source. Any idea how this can be fixed so I can get a list of values?

This usually means you have something wrong with the data source connection behind the report model. Check that your model has a data source specified, and that the data source has a valid connection string and appropriate credentials.

Hope that helps!

|||I am not sure if you found a solution to this problem, but I also ran into the same problem recently.

Currently, I am using a folder structure like:
Home>Dept>App>(Model, Datasource, Reports)

I found that by granting "View folders" at the home level to the group/user resolved the issue. I created a custom Item-Level role with just this task to restrict access, but either the Browser or Report Builder roles would work as well as they have the "View folders" task associted with them.

However, if at all possible I would like to avoid giving users access to the Home folder so if someone could explain where and why this dependency exists it would be much appericated.

error in report builder

I am trying to create a filter in the report builder on reporting services. When I try to filter I get a yellow triangle with an exclamation point and cannot get a list. When i put my cursor over the yellow triangle, I get the error "the requested list could not be retrived because the query is not valid or a connection could not be made to the data source. Any idea how this can be fixed so I can get a list of values?

This usually means you have something wrong with the data source connection behind the report model. Check that your model has a data source specified, and that the data source has a valid connection string and appropriate credentials.

Hope that helps!

|||I am not sure if you found a solution to this problem, but I also ran into the same problem recently.

Currently, I am using a folder structure like:
Home>Dept>App>(Model, Datasource, Reports)

I found that by granting "View folders" at the home level to the group/user resolved the issue. I created a custom Item-Level role with just this task to restrict access, but either the Browser or Report Builder roles would work as well as they have the "View folders" task associted with them.

However, if at all possible I would like to avoid giving users access to the Home folder so if someone could explain where and why this dependency exists it would be much appericated.

Sunday, March 11, 2012

error in report builder

I am trying to create a filter in the report builder on reporting services. When I try to filter I get a yellow triangle with an exclamation point and cannot get a list. When i put my cursor over the yellow triangle, I get the error "the requested list could not be retrived because the query is not valid or a connection could not be made to the data source. Any idea how this can be fixed so I can get a list of values?

This usually means you have something wrong with the data source connection behind the report model. Check that your model has a data source specified, and that the data source has a valid connection string and appropriate credentials.

Hope that helps!

|||I am not sure if you found a solution to this problem, but I also ran into the same problem recently.

Currently, I am using a folder structure like:
Home>Dept>App>(Model, Datasource, Reports)

I found that by granting "View folders" at the home level to the group/user resolved the issue. I created a custom Item-Level role with just this task to restrict access, but either the Browser or Report Builder roles would work as well as they have the "View folders" task associted with them.

However, if at all possible I would like to avoid giving users access to the Home folder so if someone could explain where and why this dependency exists it would be much appericated.

Error in Processing Cube (Microsoft Analysis Services)

Hi,
I am processing one cube using Full Process option and it's giving
following error.

Analysis Server Error: Internal error [Object does not exist] '11948' ;
Time:1/8/2004 6:11:11 PM

Error(-2147221421): Internal error (Internal error [Object does not
exist] '11948' ); Time:1/8/2004 6:11:11 PM

Can anyone help me on this.If you are using shared dims, process your dimensions, then the cube and see if that fixes it.

GO COLTS!!

HTH

Error in olap report

I am trying to write an olap report using RS2005. I created a datasource
with type "Microsoft Analysis Services" then added a report and defined
measures and dimensions in the query builder. Report is working fine but if
I make any modification, I will not be able to save the report and as soon
as I switch to any other tab (for example click on Preview tab or Data tab)
I will get the error "Microsoft Visual Studio has encountered a problem and
needs to close." I tried same senario by using "Analysis Services Toturial"
cube and I got same result.
Any idea?
Thanks.Actually, I'm used to getting this if I stress my development computer too
much... For bigger reports based on OLAP cubes, I just don't use the preview
function. I tweak my MDX query to just return enough data for the fields to
fill up right, and then I just save as quickly as possible. If you just add
a =" to the beginning of your query and a " at the end and make it be one
long string (no new lines), you will be able to save without the report
going to pieces. Remeber to use the "Save all" button after having added a
new report to your solution, or it will not be saved with your solution.
(But it will be available through "Add existing item".)
Not sure if this is what you wanted to hear, but it might save you from some
frustration.
Kaisa
"Tooraj" <abc@.abc.com> wrote in message
news:uEmibczBGHA.984@.tk2msftngp13.phx.gbl...
>I am trying to write an olap report using RS2005. I created a datasource
>with type "Microsoft Analysis Services" then added a report and defined
>measures and dimensions in the query builder. Report is working fine but if
>I make any modification, I will not be able to save the report and as soon
>as I switch to any other tab (for example click on Preview tab or Data tab)
>I will get the error "Microsoft Visual Studio has encountered a problem and
>needs to close." I tried same senario by using "Analysis Services Toturial"
>cube and I got same result.
> Any idea?
> Thanks.
>

Error in migrating from AS2000 to 2005

Hi all,

I have an analysis server database in AS2000. I want to migrate the same to 2005 analysis services.while doing that I am getting an error of following.

"Source server: No error message available, result code: E_FAIL(0x80004005)."

My AS2000 is in windows server 2000 with SP4 of SQL server.

My client is in windows XP and having SQL server 2005 with SP1.

Can anybody has suggestion on it?

Thanks in advance,

Vinod

It it is possible your AS 2000 server is not setup to be administered remotely. Books online should provide sufficient information on how to setup your machine to enable remote administration for AS2000.

Alternatively, try installing AS2005 as named instance on your AS2000 box. Or you can install AS2000 on AS2005 box and then migrate you databases.

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

Error in metadata manager processing sample database/cubes

I've just installed SQL Server 2005 with Analysis Services and the sample AdventureWorks databases. When I try to process the database via SQL Server Management Studio, I get the following error - see below. I did check the xml file referenced by the name of the error and I do see the dimension listed Order Date key but not any attribute called Name of Date. Is there any workaround to enable processing of the database and cubes?

I did bump up to Sp1 and this did not fix my problem. I also tried installing the samples from the downloads section of microsoft.com. Alas, no success.

Any help appreciated,

Mairead

Errors in the metadata manager. The dimension with ID of 'Order Date Key - Dim Time', Name of 'Date' referenced by the 'Adventure Works' cube, does not exist.
Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'.
(Microsoft.AnalysisServices)


Program Location:

at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc, IServiceProvider site)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDataContainer(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

Here is simple way out of your situation

1. Stop Analysis Service.
2. Delete everything in your D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db folder.
3. Start the service
4. Re-deploy your sample project.

Hope that helps

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

|||

Thanks Edward, I finally did get everything working again by completely uninstalling/reinstalling and redeploying the samples again. I did try your workaround but still could not get the samples processed successfully.

Mairead