Reporting Services Setup Error 29528
Jan 18, 2006
Here€™s my situation. At what must have been the last dialog of setup I clicked
Finish, then got this message:
SQL Server Setup was unable to install on your computer. SQL Setup has encountered a problem and will end.
The summary log indicates that only the setup of Reporting Services failed. Here€™s the section of the log:
--------------------------------------------------------------------------------
Machine : HERE
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_HERE_RS.log
Last Action : InstallFinalize
Error String : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.
Error Number : 29528
--------------------------------------------------------------------------------
All other products seemed to install ok, appear on my menu, and start ok. My server is serving up SQL data to the website and various applications.
What should I do next?
View 3 Replies
ADVERTISEMENT
Sep 14, 2007
Yesterday, literally I was banging my head to the wall, kept getting this error:
A Connection could not be established with the information provided. Hit OK to change your connection settings.
Invalid object name 'sysdatabases'.
I uninstall and re-install back the reporting services couple times and I kept getting the same error.
I have 2 instances of SQL Server on the same Server:
SQL Server 2000
SQL Server 2005
The 2 instances work side by side, I was wondering if this causing the error.
Can anyone help out with this problem?
Thanks - John
View 9 Replies
View Related
Jun 12, 2007
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Any ideas?
View 3 Replies
View Related
Jul 31, 2004
I installed and started playing around with Reporting Services and realized that you are required to run IIS on your SQLserver in order to use RS. Is this 100% true?
Please tell me there is an alternative...this is huge roadblock due to company policy.
Thanks.
View 1 Replies
View Related
Sep 10, 2007
HI, this will prob be a stupid question but i have setup reporting services and am trying to use it, however, when creating a new project i only have Visual Studio Solution under other project Solutions and not any of the other types i.e. Visual Basic Solution etc. How do i get the other types? Do i need to install anything further?
Thanks David
View 2 Replies
View Related
Dec 15, 2006
Hello,
I am having problems installing the SP2 for SQL server 2005 on a W2000 Professional. It appears that the Database Services, Analysis Services, Reporting Services and Integration Services are not being updated. I would appreciate any help with this if anyone has seen or had experience with this issue.
Thanks, the basic log file is listed below.
SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
MSI (s) (68:1C) [11:12:10:812]: Invoking remote custom action. DLL: C:WINNTInstallerMSI867.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Fri Dec 15 11:12:11 2006
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Fri Dec 15 11:12:11 2006
MSI (s) (68:40) [11:12:11:125]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (68:40) [11:12:11:156]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=1 0 0 Renaming Files 200 C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAmssqlsystemresource1.mdf C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATA mssqlsystemresource.mdf 0 )
MSI (s) (68:40) [11:12:11:156]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (68:40) [11:12:11:312]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=1 1 0 Renaming Files 200 C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAmssqlsystemresource1.mdf C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATA mssqlsystemresource.mdf 0 )
MSI (s) (68:1C) [11:12:11:328]: Invoking remote custom action. DLL: C:WINNTInstallerMSI868.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Fri Dec 15 11:12:11 2006
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Fri Dec 15 11:12:11 2006
MSI (s) (68:40) [11:12:11:718]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (68:40) [11:12:11:734]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=1 0 0 Renaming Files 200 C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAdistmdl1.ldf C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATA distmdl.ldf 0 )
MSI (s) (68:40) [11:12:11:734]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (68:40) [11:12:11:812]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=1 1 0 Renaming Files 200 C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAdistmdl1.ldf C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATA distmdl.ldf 0 )
MSI (s) (68:1C) [11:12:11:812]: Invoking remote custom action. DLL: C:WINNTInstallerMSI869.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Fri Dec 15 11:12:12 2006
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Fri Dec 15 11:12:12 2006
MSI (s) (68:40) [11:12:12:343]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (68:40) [11:12:12:343]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=1 0 0 Renaming Files 200 C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAdistmdl1.mdf C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATA distmdl.mdf 0 )
MSI (s) (68:40) [11:12:12:359]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (68:40) [11:12:12:390]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=1 1 0 Renaming Files 200 C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAdistmdl1.mdf C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATA distmdl.mdf 0 )
MSI (s) (68:1C) [11:12:12:390]: Invoking remote custom action. DLL: C:WINNTInstallerMSI86A.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Fri Dec 15 11:12:12 2006
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Fri Dec 15 11:12:12 2006
MSI (s) (68:40) [11:12:12:531]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (68:40) [11:12:12:562]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=1 0 0 Removing performance counters 200000 MSSQLSERVER DTSPipeline D:Archivos de programaMicrosoft SQL Server90DTSBinnDTSPERF.INI )
MSI (s) (68:40) [11:12:12:562]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (68:40) [11:12:12:656]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=1 0 0 Installing performance counters 200000 MSSQLSERVER D:Archivos de programaMicrosoft SQL Server90DTSBinnDTSPERF.INI D:Archivos de programaMicrosoft SQL Server90DTSBinnDTSPERF.H D:Archivos de programaMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dll DTSPipeline 0 DTSPipeline PrfData_Open PrfData_Collect PrfData_Close )
MSI (s) (68:1C) [11:12:12:656]: Invoking remote custom action. DLL: C:WINNTInstallerMSI86B.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Fri Dec 15 11:12:12 2006
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='183' GetLastError='1502'>
PerfTime Stop: Do_sqlPerfmon2 : Fri Dec 15 11:12:13 2006
Gathering darwin properties for failure handling.
MSI (s) (68!20) [11:12:13:453]: Transforming table Error.
MSI (s) (68!20) [11:12:13:453]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (68!20) [11:12:13:484]: Transforming table Error.
MSI (s) (68!20) [11:12:13:484]: Transforming table Error.
MSI (s) (68!20) [11:12:13:484]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (68!20) [11:12:13:484]: Transforming table Error.
MSI (s) (68!20) [11:12:13:484]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (68!20) [11:12:13:484]: Transforming table Error.
MSI (s) (68!20) [11:12:13:484]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 183
MSI (s) (68!20) [11:12:13:718]: Transforming table Error.
MSI (s) (68!20) [11:12:13:718]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (68!20) [11:12:13:734]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (68!20) [11:12:13:750]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (68!20) [11:12:13:750]: Transforming table Error.
MSI (s) (68!20) [11:12:13:750]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (68!20) [11:12:13:750]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: No se puede crear un archivo que ya existe.
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: No se puede crear un archivo que ya existe.
<EndFunc Name='LaunchFunction' Return='183' GetLastError='203'>
MSI (s) (68:40) [11:12:13:828]: User policy value 'DisableRollback' is 0
MSI (s) (68:40) [11:12:13:828]: Machine policy value 'DisableRollback' is 0
Action ended 11:12:13: InstallFinalize. Return value 3.
MSI (s) (68:40) [11:12:15:218]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=898586856,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (68:40) [11:12:15:218]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (68:40) [11:12:15:218]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)
MSI (s) (68:40) [11:12:15:218]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (68:40) [11:12:15:234]: Executing op: RegisterBackupFile(File=C:Config.Msi51d0e9.rbf)
View 5 Replies
View Related
Oct 4, 2005
I need to install Reporting Services on a machine.
Wehe can I find it ? (I have SQLServer Entreprise and Dev).
Is it included in SQLserver Ent or should I get another CD ?
Thanks
View 1 Replies
View Related
Aug 15, 2006
I have posted this to the general SQL Server group but without any response. I have also searched all of the forums and have not found an answer. For some reason all of a sudden, my Reporting Services is failing with this message when trying to connect:
TITLE: Connect to Server
------------------------------
Cannot connect to UKCINTUKCAZOSQL.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00" target="_blank">Get Online Help</a></li><ul>
<li>Could not load type 'Microsoft.Web.Services.ScriptHandlerFactory'. (c:inetpubwwwrootweb.config line 45)</li><ul>
<li>Could not load type 'Microsoft.Web.Services.ScriptHandlerFactory'.</li>
</ul>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------
I have now uninstalled SQL Reporting Services, reinstalled it, but I am still getting the same error. From what I can infer, there is a problem with the httpHandler in the web.config file. It cannot load Microsoft.Web.Services.ScriptHandlerFactory.
Does anybody know anything about this or what else I might need to check? This has been going on for two days now and short of totally uninstalling all of SQL, I don't know what to do.
Thanks.
View 13 Replies
View Related
Feb 29, 2008
I have report server setup on the same machine where the sql server 2005 db is setup, as well as iis running the website. i simply need to get report server running to allow internet access. I have report server setup so that it is running locally (localhost), however, as soon as I change the iis site settings to a domain name, report server stops working properly. This looks like a permissions issue, Ive tried different combinations of settings, but nothing works. Any insight on how I can get report server setup for internet access (forms authentication), would be much appreciated.
thanks, lance
View 1 Replies
View Related
Apr 22, 2015
In an existing ssrs 2012 report, I want to basically add the following logic to a new dataset that will be used by a new parameter called 'Inventory'.
SELECT DISTINCT Inv_number as value, Inv_name as label
FROM s.dbo.fnUser( @endYear, 0, 0, 0)
WHERE (@report is not null)
order by label,value
In this ssrs report, there are 15 reports that can automatically be generated. I basically want this new parameter called 'Inventory' to only be active when the 4th report is selected to be generated. Thus in the query I listed above, how can I change the query to only be active when the 4th report is selected?
I tried to change the where clause to (@report(4) is not null), but that did not work.
View 5 Replies
View Related
Oct 30, 2007
I cannot get SQL Server 2005 Express installed on a 2003 Small Business Server. I am logged in as an admin.
The error:
Code Block
Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied.
I have uninstalled all instances of SQL Server. Rebooted server and tried again, but get same error.
Any ideas?
View 1 Replies
View Related
Dec 13, 2007
I'm working on a project that requires integration of SQL Server Reporting Services with ASP.NET 3.0 Web Applications.
I'm working on Visual Studio 2005, with SQL Server 2005 on an XP development workstation.
SQL Server, Reporting Services, and IIS are all running on my local machine.
I'm trying to prototype two approaches, one using the Report Viewer control, and the second using the Reporting Services Web Service. I have the two examples setup in projects in Visual Studio.
The sample reports and data sources work fine in Visual Studio. I can access the report using the Reporting Services URL like this: http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fBTT_BDS_DEV%2fCustomers; Report works fine.
My problem is, that when I try and access the report using the Report Viewer inside an ASP.NET page or from the Web Serivce hooked up inside an ASP.NET Page I get a security errors. I have chosen Windows Security for the Datasource, and ASP.NET pages. In the case of the Web Service, I'm passing in my local domain user name as the credentials.
I'm prototyping this on my local workstation, but I need to design this to be used on our corporate Intranet using Windows Security.
My questions are:
1. How do I need to setup users on my local development workstation to get this to work.
2. How should I plan for user security for enterprise deployment, i.e. using Reporting Services inside a large ASP.NET Web Application?
3. Can anybody give me some links to some good developer type working examples of doing this. I've looked but have not found the answers
to the "how do I setup users" part of the question specifcally related to ASP.NET apps?
Below is the code example of the Web Services example app I'm working with which came out of a book I have on
Reporting Services. This example compiles and seems like it would work but doesn't. Also following are a few of the
error messages I get when experimenting with the example apps:
Errors:
1. The permissions granted to user 'LocalMachineNameASPNET' are insufficient for performing this operation. (rsAccessDenied)
2. System.Web.Services.Protocols.SoapException was unhandled by user code
Message="System.Web.Services.Protocols.SoapException: The permissions granted to user 'LocalMachineName\ASPNET' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'WCRBUSCNC2830B\ASPNET' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save() at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)"
Source="System.Web.Services"
Actor="http://localhost/ReportServer/ReportExecution2005.asmx"
Lang=""
Node="http://localhost/ReportServer/ReportExecution2005.asmx"
Role=""
StackTrace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at WebReportTester.localhost.ReportExecutionService.LoadReport(String Report, String HistoryID) in C:Documents and SettingsconbcxMy DocumentsVisual Studio 2005ProjectsBTT_BDS_DEVWebReportTesterWeb ReferenceslocalhostReference.cs:line 242
at WebReportTester._Default.btnExecuteReport_Click(Object sender, EventArgs e) in C:Documents and SettingsconbcxMy DocumentsVisual Studio 2005ProjectsBTT_BDS_DEVWebReportTesterDefault.aspx.cs:line 82
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Web Service Code Example:
protected void btnExecuteReport_Click(object sender, EventArgs e)
{
byte[] report;
//Create an instance of the Reporting Services Web Reference
localhost.ReportExecutionService rsv = new localhost.ReportExecutionService();
//Create the credentials that will be used when accessing Reporting Services
//This must be a logon that has rights to the Customers Report
rsv.Credentials = System.Net.CredentialCache.DefaultCredentials;
rsv.PreAuthenticate = true;
//The Reporting Services virtual path to the report.
string reportPath = @"/ReportFolder/Customers";
//The rendering format for the report
string reportFormat = "HTML4.0";
//The devInfo string tells the report viewer how to display with the report
StringBuilder deviceInfoBuilder = new StringBuilder();
deviceInfoBuilder.Append(@"<DeviceInfo>");
deviceInfoBuilder.Append(@"<Toolbar>");
deviceInfoBuilder.Append(@"False");
deviceInfoBuilder.Append(@"</Toolbar>");
deviceInfoBuilder.Append(@"<Parameters>");
deviceInfoBuilder.Append(@"False");
deviceInfoBuilder.Append(@"</Parameters>");
deviceInfoBuilder.Append(@"<DocMap>");
deviceInfoBuilder.Append(@"True");
deviceInfoBuilder.Append(@"</DocMap>");
deviceInfoBuilder.Append(@"<Zoom>");
deviceInfoBuilder.Append(@"100");
deviceInfoBuilder.Append(@"</Zoom>");
deviceInfoBuilder.Append(@"</DeviceInfo>");
string deviceInfo = deviceInfoBuilder.ToString();
//Create an array of the values for the report parameters
localhost.ParameterValue[] parameters = new localhost.ParameterValue[1];
localhost.ParameterValue parameterValue = new localhost.ParameterValue();
parameterValue.Name = "@WTRKCustomerCode";
parameterValue.Value = "B34186";
parameters[0] = parameterValue;
//Create variables for the remainder of the parameters
string historyId = string.Empty;
string credentials = string.Empty;
string showHideToggle = string.Empty;
string extension = string.Empty;
string mimeType = string.Empty;
string encoding = string.Empty;
localhost.Warning[] warnings;
localhost.ParameterValue[] reportHistoryParameters;
string[] streamIds;
localhost.ExecutionInfo execInfo = new WebReportTester.localhost.ExecutionInfo();
localhost.ExecutionHeader execHeader = new WebReportTester.localhost.ExecutionHeader();
rsv.ExecutionHeaderValue = execHeader;
execInfo = rsv.LoadReport(reportPath, null);
rsv.SetExecutionParameters(parameters, "en-us");
try
{
//Execute the Report
report = rsv.Render(reportFormat, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIds);
//Flush the pending response
Response.Clear();
//Set the HTTP Headers for a PDF response.
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ContentType = "text/html";
//Filename is the default filename displayed
//if the user does a save as.
HttpContext.Current.Response.AppendHeader("Content-Disposition", "Customers.htm");
//Send the byte array containing the report as a binary response.
HttpContext.Current.Response.BinaryWrite(report);
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
if(ex.Message != "Thread was being aborted.")
{
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ContentType = "text/html";
StringBuilder errorMessageBuilder = new StringBuilder();
errorMessageBuilder.Append(@"<HTML>");
errorMessageBuilder.Append(@"<BODY>");
errorMessageBuilder.Append(@"<H1>");
errorMessageBuilder.Append(@"Error");
errorMessageBuilder.Append(@"</H1>");
errorMessageBuilder.Append(@"<BR>");
errorMessageBuilder.Append(@"<BR>");
errorMessageBuilder.Append(ex.Message);
errorMessageBuilder.Append(@"</BODY>");
errorMessageBuilder.Append(@"</HTML>");
string errorMessage = errorMessageBuilder.ToString();
HttpContext.Current.Response.Write(@errorMessage);
HttpContext.Current.Response.End();
}
}
}
Any direction here related to best practices on setting up users for code use with
ASP.NET applications would be greatly appreciated...
Thanks in advance...
View 8 Replies
View Related
Sep 22, 2015
I have a dashboard page that I would like to load fast. But I would also like the user to be able to run the report On-Demand. The report has start date and end date parameters which default to the first and last day of last month. If I use a Cache plan that loads at 6AM the report runs with the default parameters set in the report, the user has to wait until it completes before they can change the parameters.
If I uncheck "use default" parameters in the report I lose the ability to set a cache refresh plan with the default parameters because the option is greyed out. So is there anyway outside of creating a second copy of the report to allow a user to open a report, change the parameters and run it, but also have a way to schedule some sort of Cached report for the default parameters so I can put that on a WebPart page that would load instantly?
View 4 Replies
View Related
Jun 2, 2015
I want to create a datasource but the credentials I want to use will be based on the user running the report rater than hard coded.
I have tried using Windows Integrated Security but all i can is cant log in as NTAnonymous User?
View 8 Replies
View Related
Mar 30, 2007
Dear All,
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End upgraded with service pack 3 and analysis service.
Now I am trying to install sql server 2000 report services. But I run SQL2KRSSP1-ENG.EXE setup
Then following error occurs
The upgrade patch can not be installed by window installer because the program to be upgraded may be missing , or the upgrade patch may update a different version of the program Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.
I redownload the same exe to other location. And again run but getting same error
Please Guide me or atleast give some help full link.
thanks
View 1 Replies
View Related
Sep 11, 2015
We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A)
 at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
Â
[code]...
View 4 Replies
View Related
Mar 26, 2008
I have visual studio 2008 sql express, vista ultimate is on my computer however I have not installed sql express on my computer
I wish to install sql standard 2005 sp1 I have read microsoft's article 934164 before installing sql standard
I have a couple of questions installing sql server standard edition see sql-articles.com -installing
sql 2005
sql instances screen- can I choose default installation?
sql services screen do I need to choose domain name(I am a small business, I do not own a server, I wish to
use a third party to use sql reporting services . I have not registered my domain name
Windows authentication- I wish to use mixed mode.
I wish to configure user account later by stopping sql services and then installing sql sp2 (after windows
authentication screen)
described in microsoft article 934164
do I need to configure the server?(next screen after windows authentication)
I want to avoid a system reboot......
Is there anyway that I can make sure all the parts are installed on sql server and sql sp2?
Is it adviseable to configure my administrative account at the end of sql sp2?
How do this work? I just want to be prepared......
Thank you
View 1 Replies
View Related
Oct 22, 2006
I got this error message during SQL Server Express install with no error code on Server 2003 SP1. I'm installing on an older development machine and although I do have a very large log file somewhere I wanted to post before I even dug into it. I noticed in IIS under my Webs that the MSSQLExpress webs were there at first but when I clicked on them to get any info or Properties... they dissapeared. So they were almost installed but they no longer exist. Also I do not have a SQL Service Manager icon down near the clock.
I almost took a step to fix this. After reading a few posts about similar problems I thought maybe this happened because the Default Web Sites IP # was not set to (All Unassigned). I was going to try a repair install from Add/Remove Programs but the temporary setup files are already gone. I really dont want to uninstall all 5 SQL components from Add/Remove Programs and start from scratch.
As good security practice we usually remove the Default Web or as in this development servers case we changed the IP from (All Unassigned) to an IP that is only accessible from certain machines on the internal network. I obviously should have read more pre setup guides. Anyway how can I fix this without reinstalling everything?
View 2 Replies
View Related
Jul 23, 2010
We built our prod server [vm] with SQL Server 2008 R2 on Server 2008 R2. It works nicely. Then we made a copy of the VM and renamed it (so our test environment would be IDENTICAL to production). After that, SSRS was broken: I get "HTTP Error 503. The service is unavailable." I can't connect via http, or SSMS.
We have tried:
*Â Running SSRS config tool (several times)
* Running with/without the IIS Server Role
*Â Dropping & recreating the SSRS keys
*Â Recreating the ReportServer database, etc
*Â Checking all of the accounts, permissions, etc
*Â Running SQL Repair
*Â Going through the registry to fix any references to the machine's old name
*Â Uninstalling, reinstalling SSRS
* Completely uninstalling ALL of the parts of SQL Server 2008 R2, deleting all directories, removing references to SQL Server from the registry, rebooting, reinstalling everything.
None of this has worked. SSRS [R2] is still 503 on our test box.
the SSRS [NT] service seems to run, without error. The Event Viewer doesn't seem to be recording any errors. The SSRS logs say that the default URL is wrong, but we get the same error in Prod, and Prod works fine. The other SQL Logs say something about not being able to contact the service. However, as I said, the [NT] service seems to be working fine.
View 4 Replies
View Related
Dec 19, 2006
I'm using Reporting Services 2005 SP1 and wrote some code to render reports server-side.
My sample report has few parameters that must be passed so I pass these parameters with code.
<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;
ParameterValue[] parameters = new ParameterValue[2];
parameters[0] = new ParameterValue();
parameters[0].Name = "pID";
parameters[0].Value = "6548747";
parameters[1] = new ParameterValue();
parameters[1].Name = "pClass";
parameters[1].Value = "8";
ExecutionHeader header = new ExecutionHeader();
ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
rs.ExecutionHeaderValue = header;
rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;
byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);
</My code>
Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():
<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>
I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.
Any help would be much appreciated.
View 3 Replies
View Related
Apr 24, 2015
I am trying to configure the reporting for TFS using SQL Server. But I get following error when viewing any report:
So I try to manually process the cube to check if it works. I am following this article:Â [URL] ....
When I click on GetProcessingStatus and invoke it (with last field set as TRUE) I get following error:
How to resolve this issue and be able to see the reports.
View 5 Replies
View Related
May 9, 2008
I recently installed SQL Server 2005 Enterprise on a machine running Server 2003. I have successfully configured Reporting Services (see below for summary of settings)
- Used the defaults for the Repor tServer and Report Manager Virtual Directories
- Windows Service Identity set to domain user. The domain user is part of the administrator group on the machine and has sysadmin rights to the database
- Web Service Identity set to NT AuthorityNetworkService
When I open http://localhost/reports/, I get the following error:
I have check a bunch of forums, but have no success. Any advise would be greatly appreciated!!
Server Error in '/Reports' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3a890e9c0 068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl34a099978 068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3de5a2332 0958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3498aee86 042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3cd47089b 0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3f180608d 0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl323449648 068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 5 Replies
View Related
May 22, 2007
I am getting an error message when I try to print using reporting services: "an error occurred during printing (0x80004005)"
View 4 Replies
View Related
Jan 5, 2006
I have XP Pro SP2 with MDAC 2.8.1022. It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.
I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP. There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.
There's some other strange things, so I wonder if they are related.
1) I have Paul set up as an administrator account. Some folders like MSSQL show that account with no permissions. I grant all the permissions to Paul for that folder. I come back later and the permissions are gone.
2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared. I deleted those 7 again and then they finally went away.
3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.
View 12 Replies
View Related
Nov 15, 2004
I have installed SQL Reporting Services Developer Edition and when I try to open http://localhost/reports I get the below error. Does anyone have any suggestions as to how to fix this problem or what it stems from?
Security Exception
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the permission of type System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.]
Microsoft.Web.ValidatePathModule.System.Web.IHttpModule.Init(HttpApplication app) +0
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1295
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +392
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
View 3 Replies
View Related
Dec 27, 2004
I have installed SQL Server Reporting Services and I recieve the following error when I attempt to call the reportserver from the URL.
"Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the 'Refresh' button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. "
In the event log, the following error is recorded..."
"aspnet_wp.exe could not be started. The error code for the failure is 80004005. This error can be caused when the worker process account has insufficient rights to read the .NET Framework files. Please ensure that the .NET Framework is correctly installed and that the ACLs on the installation directory allow access to the configured account. "
I have ran "aspnet_regiis -i" after installing reporting services...
I have validated that ASPNET has the correct permissions...
I have validated that ASPNET user account has not been lockedout...
I have restarted the Report Server service...
I have restarted the IIS service...
I even have restarted the server...
Does anyone have any other ideas that may help! Thank you in advance.
View 6 Replies
View Related
Jul 29, 2007
while opening http://localhost/reportserver,prompted error below
The permissions granted to user 'COMPUTERNAMEIUSR_COMPUTERNAME' are insufficient for performing this operation. (rsAccessDenied)
I tried other users as anonymous account to access reportserver,all failed
however,http://localhost/reports can work
any advise on this?
ENV is WinXP sp2+IIS5.1,Katmai
thanks
View 1 Replies
View Related
Mar 14, 2008
I am trying to configure a Report Server for my Reporting Services database. They are located on two different machines. I have two different error message which are essentially the same thing. First, under Database Setup when Verifying Database Version I have the message "The database version (C.0.8.54) does not match your Reporting Services installation. This version of the database cannot be upgraded. You must use a different database.
Second, when clicking on the Initialization link I receive "There was an error while switching panels. The most likely cause is an error retrieving WMI properties. The exception details are: The version of the report server database is either in a format that is not valid, or cannot be read. The found version is 'C.0.8.54'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
Is is possible to have the Reporting services and Report Server on two separate machines? I thought at first that the reason we are having a problem is that the reporting services server is 32 bit and the report server is 64 bit but even when I try to connect to a 32 bit db server I receive the same error.
Thanks.
Emily
View 6 Replies
View Related
Mar 17, 2008
I have my report server instance on one server and the database on a different server. I've set up the config tool and have not red X's but receive the following error when attempting to connect to http://servername/reports.
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)
Any advice would be appreciated.
View 3 Replies
View Related
Jul 13, 2007
Hi there,
I am using Microsoft SQL Server Reporting Services to generate the business reports. For my project I need to create one report. For this, at first I have created the
stored procedure ( we have to pass the values for the parameters in Stored Procedure ) and calling the stored procedure from the reporting services. I have given a name for
the dataset and retrieved the result set on executing ( by clicking on the '!' icon on the toolbar ). I have added the required parameters in the parameter tab section of the
dataset. I have refreshed ( by clicking on the refresh icon on the tool bar) to pop up the database fields from the select query of the stored procedure. This is where I am
encountering the problem ie When I refresh the dataset, the fields are not generated for the dataset automatically and whatever the parameters I have given in the parameter
tab section of the dataset are missing. This has been bugging me for past 2 days. Could anyone please provide me the possible solution ASAP.
Thanks in Advance,
S.Priyadharshini
spriya@originwave.com
View 7 Replies
View Related
Oct 12, 2006
Hi to everybody,
I have installed on a windows server 2003 machine with all the last update until 12/10/06
sql server 2k analysis services with all the last update
the problem is that when I tray to export the report
I recieve this error
Reporting Services Error
--------------------------------------------------------------------------------
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
Cannot find font '?'.
--------------------------------------------------------------------------------
Microsoft Reporting Services
Any suggestion is apprecieted
View 1 Replies
View Related
Feb 7, 2006
Greetings,
Iam new to reporting services. When I try to launch http:\localhost
eports
I get the following error
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
Please help
Thanks/Regards
View 16 Replies
View Related
Oct 3, 2007
Hi,
I have recieve this error message all the time:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 10/3/2007
Time: 4:59:44 AM
User: N/A
Computer: HODB04
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/3/2007 4:59:44 AM
Event time (UTC): 10/3/2007 11:59:44 AM
Event ID: b7976e30b5684e87aab8400f3210e418
Event sequence: 178
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/ReportServer-1-128358856716820859
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
Machine name: HODB04
Process information:
Process ID: 3820
Process name: w3wp.exe
Account name: NT AUTHORITYNETWORK SERVICE
Exception information:
Exception type: ReportServerException
Exception message: Execution 'qec55gnjapsyl53e0fslju45' cannot be found (rsExecutionNotFound)
Request information:
Request URL: http://hodb04/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=qec55gnjapsyl53e0fslju45&ControlID=b85977e37c4745e89e7e95fe5297d1ed&Culture=127&UICulture=9&ReportStack=1&OpType=PrintHtml
Request path: /ReportServer/Reserved.ReportViewerWebControl.axd
User host address: 172.16.17.201
User: THRIFTYFOODSjkessler
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITYNETWORK SERVICE
Thread information:
Thread ID: 22
Thread account name: NT AUTHORITYNETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
How can I solve this problem?
Thanks,
View 1 Replies
View Related
