SQL Server 2005 Reporting Services Error, Hotfix Download?
Hello I am attempting install CRM Server 3.0 R2 using SQL Server 2005 SP2.
On install of CRM Server 3.0 R2 I receive a SQL Server reporting services error:
Setup failed to validate specified Reporting Services Report Server http://jupiter/reportserver. Error: The feature: "Customizing security roles" is not supported in this edition of Reporting Services.
There is a hotfix available here: 935922
But how can I get the hotfix and why is this hotfix not simply available for download as per other bug fixes?
Now stcuk with no way to move forward.
BTW anyone who has SBS2003 R2 and wants to get CRM server/client setup to work with Outlook 2003 and Vista read here 935922
But how can I get the hotfix and why is this hotfix not simply available for download as per other bug fixes?
Now stcuk with no way to move forward.
BTW anyone who has SBS2003 R2 and wants to get CRM server/client setup to work with Outlook 2003 and Vista read here http://www.teknobot.co.uk/archives/category/tech. Its better than any other MS article Ive found so far. Why MS realease action pack software that simply do not work with each other is beyond me, SBS always gets the dirty end of the stick.
Any help would be greatly appreciated.
View Complete Forum Thread with Replies
Related Forum Messages:
Error : SQL Server 2005 Reporting Services
While creating Ad-Hoc reports in SSRS 2005 I hit an error: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method Any help is greatly appreciated. Thanks, Kalia
View Replies !
Error Starting Reporting Services In SQL Server 2005
Hi , I am trying to connect to Reporting Services through SSMS using the following parameters: Server_Type: Reporting Services Server Name : <Server_Name> Authentication: Windows Authentication Got the following error message: TITLE: Connect to Server ------------------------------ Cannot connect to <Server_Name> ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html', but expected 'text/xml'. The request failed with the error message: -- <html><head><title>Server Application Error</title></head> <body> <h1>Server Application Error</h1>The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance.</body></html> --. (Microsoft.SqlServer.Management.UI.RSClient) Any help would be deeply appreciated, Thanks a lot for your Time, Regards, Sundar
View Replies !
Reporting Services Error After Installing Sql Server 2005 Sp2
Please help! I have an asp.net 2.0 web app that integrates with reporting services. Since installing sql server 2005 sp2 I get the following error when trying to access reports: An error has occurred during report processing. (rsProcessingAborted) This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled) I've checked the directory security for the report server website in IIS and integrated windows authentication is checked. I can't understand what has caused the problem, before sp2 the reports were working fine. Thanks in advance for any help, Andy
View Replies !
Microsoft SQL Server 2005 Reporting Services -- Error 1303
I am trying to install Microsoft SQL Server 2005 Reporting Services, Receiving the following error Microsoft SQL Server 2005 Reporting Services -- Error 1303. The installer has insufficient privileges to access this directory: C:Config.Msi. The installation cannot continue. Log on as administrator or contact your system administrator. I am already logged in as Administrator and should have all the necessary permissions to install software Please help me.
View Replies !
Trying To Install SQL Server 2005 And Reporting Services. Having Issues. Error Message Below
Any help will be appreciated. Code error is below. Cannot get by the errors. Thanks! Terry Help, Had configuration error trying to set up reporting services. Uninstalled SQL Server and Reinstalled, but not all files were removed. How many files and directories do I have to remove to get Reporting Services to work? Thanks! Terry <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product> <Locale>en-US</Locale> <TimeZone>Central Standard Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerService__main_01_31_2008_16_16_12.log</Path> <SystemName>JPADESKTOP1</SystemName> <OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName> <OSVersion>5.1.2600.131072</OSVersion> </Header> ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. ReportingServicesService!configmanager!4!1/31/2008-16:16:12:: w WARN: WebServiceAccount is not specified in the config file. Using default: JPADESKTOP1ASPNET ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. ReportingServicesService!library!4!1/31/2008-16:16:12:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!servicecontroller!9!1/31/2008-16:16:13:: Total Physical memory: 1055309824 Terry B
View Replies !
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 FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesReportManagerBinReportingServicesWebUserInterface.dll,,Existing=1) MSI (s) (7C:38) [13:43:05:433]: Note: 1: 2318 2: C:WINDOWSInstaller$PatchCache$ManagedE281BDB31738DB64CA931CA4195DEE8F9.0.1399RSWebUserInterface.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 FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesReportManagerBinReportingServicesWebUserInterface.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.Msi73537e.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.Msi73537e.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.Msi73537e.rbf. System error 5. Verify that you have access to that directory. Error 1310. Error writing to file: C:Config.Msi73537e.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.Msi73536e.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi73536f.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735370.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735371.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735372.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735373.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735374.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735375.rbf) MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:Config.Msi735376.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.
View Replies !
Error During First Configuration After Installing Reporting Services (SQL Server 2005 Express)
Hi, I have problem during first configuration of Reporting Services from MS SQL 2005 Server Express with Advanced Services SP2. The error occurs when configuring virtual directory (Reporting Services Configuration Manager -> Report Server Virtual Directory). When I try to create new virtual directory I can see following messages: Number of errors: 0 Create Virtual Directory The virtual directory was created and assigned. Changing Secure Connection Level After last message Windows reports that SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close (and I can send report to Microsoft). IIS shows that virtual directory under default web site was created. Evenet viewer (application log) shows .NET Framework 2.0 error: EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.3042.0, P3 45cd6ee2, P4 rsconfigtool, P5 9.0.242.0, P6 45cd6ee2, P7 15a, P8 5, P9 system.nullreferenceexception, P10 NIL My environment: MS SQL Reporting Services Version 9.00.3042.00 Windows XP Proffessional SP2 IIS 5.1 all components are fresh new installations. The only additional configuration I've made was adding IWAM_<hostname> as WebServiceAccount, all other configuration is default. Any help would be appreciated. Best regards Slawomir Nasiadka
View Replies !
Reporting Services 2005 And SQL Server Management Studio Connection Error
I have installed multiple instances of SSRS on same server with different database. I can go to the report server URL for both SSRS and run reports. But I cannot connect to the 2nd instance through "SQL Server Management Studio". Also I am getting following error when I try to connect to the "Reporting services configuration" tool from a remote machine Code Block See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Management.ManagementException: Not found at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.PropertyData.RefreshPropertyInfo() at System.Management.PropertyDataCollection.get_Item(String propertyName) at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName) at System.Management.ManagementBaseObject.get_Item(String propertyName) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.get_IsSharePointIntegrated() at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus() at ReportServicesConfigUI.ConfigurationManager.ChangeMachine() at ReportServicesConfigUI.ConfigurationManager.LaunchDialog() at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e) at System.Windows.Forms.Form.set_Active(Boolean value) at System.Windows.Forms.Form.WmActivate(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- RSConfigTool Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Management Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll ---------------------------------------- System.ServiceProcess Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
View Replies !
Ajax Error After Installing Reporting Services On SQL Server 2005 Default Instance
I recently installed reporting services on a Windows 2003 server running SQL 2005 Developer's edition with SP2. I reapplied SP2 after installing Reporting Services. According to the Reporting Services Configuration Tool the report server is up and running. It's a clean install so there are no reports, but when I attempt to go to http://localhost/reportserver or the named instance http://<computer_name>/reportserver I get the following error. An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Could not load file or assembly 'Ajax' or one of its dependencies. The system cannot find the file specified. (X:YZwwwweb.config line 85) Could not load file or assembly 'Ajax' or one of its dependencies. The system cannot find the file specified. I looked at line 85 in the web.config file: <add verb="POST,GET" path="ajax/*.ashx" type="Ajax.PageHandlerFactory, Ajax" /> The ajax.dll file resides in X:YZwwwin I have copied the ajax.dll to the system32 directory as a quick fix, but I continue to receive the same error. Any suggestions?
View Replies !
Visual Studio 2005 - Reporting Services 2005 Access Import Error
I am trying to import Access reports using Visual Studio 2005 and Access 2007. SQL Server 2005 with Reporting Services is also installed. I select Reports in the Solution Explorer and then Import Reports... Microsoft Access and browse to my Access database. After I select the database I see it open briefly as if it is trying to import the reports but then Access quickly closes and a error pops up: "You already have the database open." I have checked and double checked and the database is not open. I have even tried several different databases and the same errror occurs. Any help would be greatly appreciated.
View Replies !
Error With Reporting Services 2005
Hi, I'm working with Vista + IIS7 + SQL Server 2005 SP2 (trial version entreprise) . When I try to access on this url : http://localhost/Reports/Pages/Folder.aspx, I have the error : "The reports server is not responding. Make sure it is operational and accessible from that computer.", and when I try to access on the other url : http://localhost/ReportServer/, the error is : "Erreur HTTP 500.0 - Internal Server Error". Virtuals Folders "Reports" and "ReportServer" have been correctly created in IIS7 and services of MSSQLSERVER have been correctly launched. Do you have any idea? Thanks in advance, Michael Pailloncy
View Replies !
Where To Download SQL 2005 Reporting Service?
Hi all, Can someone tell me where to download the SQL 2005 Reporting Service? I looked all over the MSDN subscriber download site and could not find it. And I have the SQL 2005 developer edition DVD, could not find the reporting service in there either. Is the SQL 2005 Reporting Service now available only in the SQL 2005 enterprise DVD or something? Thanks
View Replies !
SQL 2005 - Reporting Services Configuration Error.. Pls Help..
Hi, I've installed SQL 2005 on a Windows 2003 R2 Server, I also installed another Web Server (Another Windows 2003 R2 Server) on a different machine. I've installed the Reporting Services on the Web Server. When I am trying to configure the report server, I successfully created the Virtual Directories, but when trying to do the "Database Setup" step, I am getting an error on the "Create a Grants Rights Script", with this message: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementScope.InitializeGuts(Object o) at System.Management.ManagementScope.Initialize() at System.Management.ManagementObjectSearcher.Initialize() at System.Management.ManagementObjectSearcher.Get() at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion) As a result, I cannot run the reports nor get to the folder.aspx page on the manager side of the application. I am getting this HTML msg: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help When installing the Reporing Server on the SQL Server machine, it works with no problems, and I am doing everything the same. Would appreciate your help, I've been working on this for few days with no luck. Thank you! Yaniv.
View Replies !
Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services
Hello, I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified. Restored my Reportserver and ReportserverTempDB databases Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script) It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'? Is it possible to migrate from 32bit to 64bit? Any help is appreciated
View Replies !
Reporting Services 2005 Semantic Query Error
I recently changed my datasource in our Reporting Service Model. We changed to a quicker SQL server with disk capacity. I am able to run new reports but when I try to run old ones that were on the old datasource, I get an error. The datasource has been changed to point to the new server (datasource). The error is: An error has occurred during report processing. (rsProcessingAborted) Semantic query compilation failed: e EmptySemanticQuery The SemanticQuery does not contain any Groupings or MeasureGroups. SemanticQuery must contain at least one of these elements. (SemanticQuery ''). (rsSemanticQueryEngineError) I will appreciate any help. Nick
View Replies !
SQL 2005 Reporting Services SP2 Integration With MOSS 2007 SSL Error
Hi, I have just installed RS and SP2 on a server running a MOSS 2007 (with SSL using an internal certificate) and configured RS to work on Sharepoint Integrated Mode. Then I went to Sharepoint to configure RS options, but when I tried to set up the Set Servers Defaults I receive the following error: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure. Also, when I try to deploy a report from SQL BI Development Studio to Sharepoint, I receive the error: A connection could not be made to the report server https://myserver.mycompany.com.br/Reports/Site. (Microsoft Report Designer) Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure. (System.Web.Services) Can anyone help me?
View Replies !
Error Opening Reporting Services Site --- Server Error In '/Reports' Application
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 Replies !
Reporting Services - SQL Server 2005
We are in the process of doing a side by side installation of the SQLserver 2000 and SQL server 2005 on the same server. To install theReporting services feature of SQL server 2005 requires IIS. We have aseperate web server running IIS that connects to the database server.My question is : can we still install Reporting services on thedatabase server without the IIS?Thank you
View Replies !
SQL Server Reporting Services 2005
hi, i am using SQL server reporting services 2005. but when i tried to deply onto the report server, i am getting error "rsReportServerServiceUnavailable". can anybody tell me what is the problem. manytimes i m getting this error. thanks and regards, vishruti.
View Replies !
SQL Server 2005 Reporting Services
I need to know how to do a comparison chart in SSRS. For example in the table I am working with I have a column which contains a number and a column which contains a year I need to show a comparison from last year to this year. What is the best way to do this?
View Replies !
SQL Server 2005 Reporting Services
Dear Friends When try to Install SQL Server 2005 Dev. Edition in Windows Vista Home Premium Reporting Services Option Found Disabled. As per Requirment IIS 7 (all options) Enabled and having IE 7.0 Expecting Favour from all friends. Thanks
View Replies !
SQL Server 2005 Reporting Services
Does anyone know how to beautify the parameter control layouts on a report header? For example I have a drop down multi selection control for a parameter for a report. I'd like it to be three times as wide. I could just add spaces to the labels but I'd prefer a more elegant solution. SQ
View Replies !
SQL Server 2005 Reporting Services And ASP .NET 1.1
Hi, Our team is developing an ASP.NET 1.1 Application that is written using VS2003 but using SQL Server 2005 as database. Can we use a Report Viewer Control that comes with SQL Server 2005 in our ASP.NET 1.1 application? If not, Can some one suggest some alternative way of showing SQL Server 2005 Reports in ASP.NET 1.1 application? Thanks, CodeKracker
View Replies !
SQL Server Reporting Services Error
Hello, I get this error, if any one can help me An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get For more information about this error navigate to the report server on the local server machine, or enable remote errors
View Replies !
SQL Server Reporting Services - Error
Hi, I got the below error while trying to generate model in sql server reporting services. An error occurred while generating model. (rsModelGenerationError) An error occurred during the generation of semantic model : [Create perspectives from cubes]Either the user, AVINAYA7ArulMani, does not have access to the AdventureWorksDW database, or the database does not exist.. [Create perspectives from cubes]Either the user, AVINAYA7ArulMani, does not have access to the AdventureWorksDW database, or the database does not exist. Either the user, AVINAYA7ArulMani, does not have access to the AdventureWorksDW database, or the database does not exist. Please help me to resolve this error. M.ArulMani
View Replies !
SQL Server 2005 Reporting Services Problem
Hi there,I have a problem that's beginning to do my head in and hope someonecan help!!!I've got a SQL Server 2005 database which is partly encrypted(certaincolumns per table are encrypted).I have two different passwords for two different symmetric keys andthese passwords are in turn stored encrypted in the registry, to beretrieved by an app, decrypted and then passed to the relevantsymmetric key to decrypt the relevant data in a table.I've written an application that's allows certain admins to changethese encrypted registry passwords and symmetric key passwords attheir will.The SQL Server 2005 Reporting Services is all set up with certainreports (one of the symmetric keys locks down a column that says whocan access reports, whilst the other protects the actual data thatthereports show) and all works fine until I change the symmetric keythatprotects the reports access list.I then get an error saying it can't establish a connection to thedatabase. (I know it's actually getting into the table to see I havereporting access though as I've stepped through all the code)I've tried a dummy test by encrypting a column, changing thesymmetrickey and then retrieving the data and I get back the plain text Iexpect.The error suggests that changing the symmetric key password blocksaccess to the data, but my dummy tests have proved otherwise.I'm new to reporting services.......is there something containedwithin a reporting solution or the reports themselves that wouldrelate to the symmetric key? Am I being daft? Am I overlookingsomething stupid?To change the password I open the existing symmetric key, addencryption with a new password, drop encryption with the existingpassword and then close the key.Sorry if some of this doesn't make sense - it's quite complicated.Feel free to ask any more questions if you don't understandsomething.I've spent 1.5 days on this now and I'm at the end of my tether!Thanks in advance,Michael.
View Replies !
SQL Server 2005 Reporting Services Designer
Is there a control in SQL Server 2005 Reporting Services similar to Crystal reports Designer control that can be embedded in third party applications that allows their user to design their own reports through the application. Basically we are using the crystal control in our current software and are looking to move Microsoft reporting services Your comments would be greatly appreciated. Thanks
View Replies !
SQL Server 2005 Reporting Services On Vista
I have installed the reporting services and followed KB934164 without any issues. Everthing is running fine. The question I have is on security on vista. I am running my vista machine a non-admin. I gave myself the neccessary permissions to administrate the report server so that that Site settings link appears in the upper right corner. However, if I run the browser locally from my vista maching the link does not appear. If I run it from another machine ( my XP machine connecting to the vista machine) it appears like it is suppose to. Also, when I connect the the reportserver from the Vista machine is states I do not have permission to access but if I browse to the vista machine from my XP machine I do have permisission. Would this be related to trusted sites? The KB stated I needed to add my vista machine to the trusted site but it is controled with group policy and I do not have access to do that. Thanks for your comments.
View Replies !
Reporting Services On SQL SERVER 2005 DW/OLAP
Hello, I would like to know if Reporting Services 2005 is a good tool for making reporting activities on SQL Server 2005 DW and also using OLAP (Analysis Services 2005). There are any limitations or bugs to using it. This is good for trends. Thank, any help will very appreciated.
View Replies !
64 Bit SQL Server 2005 Database, 32 Bit Reporting Services
Is it possible to connect a 32bit RS 2005 to a 64bit SQL Server 2005 DB? I am able to connect a 32bit RS 2005 to a 32bit Server or a 64bit RS 2005 to a 64bit Server but not a 32bit RS 2005 to a 64bit Server. I have not seen anything that says that this will not work but I have not seen anything that says that it will work. If there is a How To or some extra configuration steps that are needed to allow this to work can you please point me to where they live? Components: Win2k3 STD x64 R2 SP2 and Win2k3 STD SP1 SQL Server 2005 Enterprise SP2 and SQL Server 2005 Development SP 2
View Replies !
SQL Server 2005 Reporting Services Integration
How can we Integrate SQL server 2005 Report builder, Report designer in a custom .Net Application ? . Please Help me. I want to provide Report Designer, Report builder and Query builder functionalities to my .Net application. How can I Integrate them in my application?
View Replies !
Adding SQL Reporting Services To SQL Server 2005 SP1
I'm using Reporting Services Configuration tool to add the Reporting and ReportingTemb databases. Once the have been created, the tool attempts to upgrade the databases and can not create a script. This are the errors I see from the from the Reporting Services Configuration Tool after creating the databases: ! Verifing Database Version The Database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database. ! Creating upgrade script for database version C.0.8.40 ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script) I've reinstalled the entire SQL Server 2005 installation. As part of company installation precodure, SQL 2005 w/o Reporting Services is installed first, followed by SP1. I then perform the SQL Reporting Services installation add-on. Thanks, Mark
View Replies !
Sql Server Reporting Services 2005 Limitations
Hi, Apologies for the generic subject heading but I have a client who at my suggestion has implemented a reporting solution using SSRS. However, we are now finding serious limitations with this solution, primarily regarding exporting matrix data to Excel. The major concern is that after exporting matrix data you cannot sort, filter or format properly as we cannot repeat the group data, merged cells is also another big problem. They are now seriously looking at bringing in different technology to address these problems and I was wondering if anybody had any positive ideas, as to how I can provide a way forward and overcome our issues? Can I easily add an add-in to the existing export options, does SQL 2008 offer any improvements, are there any 3rd party offerings out there? Grateful for any advice.
View Replies !
Repairing SQL Server 2005 And Reporting Services
I accidentally removed the VS2005 component of SQL Server 2005 Reporting Services. Now, I cannot figure out how to reinstall that component. The SQL Server Business Intelligence Development Studio is no longer an option from the Programs menu so I cannot get to Reporting Services at all, but when I try to repair SQL Server, it thinks Report Services is already installed. Is there a way to reinstall other than removing and reinstalling SQL Server? If I have to reinstall, is there a way to remove it without losing my existing databases and report files? The OS is XP Pro. Many thanks, W. A.
View Replies !
SQL Server 2005 Reporting Services Not Starting
Service cannot be started. System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.Library.Global' threw an exception. ---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowOverride="false"> from an inherited configuration file. (C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinReportingServicesService.exe.config line 5) at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors) at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey) --- End of inner exception stack trace --- at System.Configuration.ClientConfigurationSystem.EnsureInit(String con... For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Any tips would hugely help. I checked this config file and have not seen this info in the file.
View Replies !
Installing Reporting Services For SQL SERVER 2005
kalaiselvi writes "Hi, I have installed sql server express edition with client components - analysis services,Reporting services. There is an Business intelligent Studio, Report Server for creating Reports but In object Browser of sql server management studio express there is no reporting services or analysis services icon How to solve this isssue? Any comments or suggestions are welcome Thanks in advance"
View Replies !
Reporting Services [Reports Server Error]
Hello, I've installed Reporting Services for my job and when I try to access the homepage of my reports server I've got this error message : Erreur du serveur dans l'application '/Reports'. -------------------------------------------------------------------------------- L'accès au chemin d'accès "C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportManagerin" est refusé. Description : Une exception non gérée s'est produite au moment de l'exécution de la demande Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code. Détails de l'exception: System.UnauthorizedAccessException: L'accès au chemin d'accès "C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportManagerin" est refusé. It is in french cause I'm a french student. I think it is a problem of user, the user that I use to access this page seems to be machinename_IWAM and I attribute all the rights (like administrator) to this user but the access to the directory is denied. I 'm searching for some help, thanks a lot
View Replies !
Reporting Services [Reports Server Error]
Hello, I've installed Reporting Services for my job and when I try to access the homepage of my reports server I've got this error message : Erreur du serveur dans l'application '/Reports'. -------------------------------------------------------------------------------- L'accès au chemin d'accès "C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportManagerin" est refusé. Description : Une exception non gérée s'est produite au moment de l'exécution de la demande Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code. Détails de l'exception: System.UnauthorizedAccessException: L'accès au chemin d'accès "C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportManagerin" est refusé. It is in french cause I'm a french student. I think it is a problem of user, the user that I use to access this page seems to be machinename_IWAM and I attribute all the rights (like administrator) to this user but the access to the directory is denied. I 'm searching for some help, thanks a lot
View Replies !
Error In Shared SQL Server Reporting Services
I can run a report successfully through the report manager, but when I click on a prompt in order to change it am getting the error. i.e,Validation of view state mac failed. if this application is hosted by a web Farm or cluster,ensure that <machine key> configuration specifies the same validation key and algorithm. Autogenerate cannot b used in a cluster.
View Replies !
Need A Quick Answer About Reporting Services In SQL Server 2005?
Hi all, I apologize in advance for the lack of homework before posting, but I am just looking for a quick answer, or a quick point in the right direction to figure this out. I have a developer from an adjacent team that wants to use Reporting Services in a SQL Server 2005 installation. From what I found online during what I thought was a definitive search yesterday, I gave him the MSDN SQL Server 2005 DVD and told him that Reporting Services is now part of the standard installation. Which is what my brief search yesterday indicated to me. He did the installation (full, according to him) and said he could not find Reporting Services. So, the quick question is... Where is Reporting Services in SQL Server 2005? I don't have a separate MSDN DVD that contains it as was the case on SQL Server 2000. This further supports my (wavering) position that it is part of the standard installation. Thoughts? Direction? Collective kicks in the posterior? Thanks!
View Replies !
Installing Sql 2005 Server And Reporting Services Problem
I am installing sql 2005 server and report services and receive an error "The setup has encountered an expected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation." Then sql server get installed but not reporting services. Please help. Thanks.
View Replies !
Installing Sql 2005 Server And Reporting Services Problem
I am installing sql 2005 server and report services and receive an error "The setup has encountered an expected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation." Then sql server get installed but not reporting services. Please help. Thanks.
View Replies !
Problems Installing SQL Server 2005 SP2 (Reporting Services)
Everything installed fine except for the Reporting Services portion of the service pack... Time: 04/25/2007 16:01:51.575 KB Number: KB921896 Machine: OIGASRVSQL001 OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: Yes Log Location on Passive Nodes: (OIGASRVSQL001) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix (OIGASRVSQL002) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.2.3042 x86 Database Services (OMNIDB1) ENU RTM 2005.090.1399.00 x86 ENTERPRISE Reporting Services (OMNIDB1) ENU RTM 9.00.1399.00 x86 ENTERPRISE Notification Services ENU SP2 9.00.3042.00 x86 ENTERPRISE Integration Services ENU SP2 9.00.3042.00 x86 ENTERPRISE SQL Server Native Client ENU 9.00.3042.00 x86 Client Components ENU SP2 9.2.3042 x86 ENTERPRISE MSXML 6.0 Parser ENU 6.10.1129.0 x86 SQLXML4 ENU 9.00.3042.00 x86 Backward Compatibility ENU 8.05.2004 x86 Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86 ********************************************************************************** Products Disqualified & Reason Product Reason Database Services (OMNIDB1) This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node. ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID wmiprvse.exe Reporting Services Application 3224 ********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Database Services (OMNIDB1) Product Version (Previous): 1399 Product Version (Final) : Status : NA Log File : Error Description : This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node. ---------------------------------------------------------------------------------- Product : Reporting Services (OMNIDB1) Product Version (Previous): 1399 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log Error Number : 2228 Error Description : MSP Error: 2228 The installer has encountered an unexpected error. The error code is 2228. Database: . Unknown table '_sqlDomainGroup' in SQL query: SELECT `Property`, `Component_`, `RestoreProperty`, `Service`, `ServiceName` FROM `_sqlDomainGroup` ORDER BY `Order`. ---------------------------------------------------------------------------------- Product : Notification Services Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : MSXML 6.0 Parser Product Version (Previous): 1129 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 2004 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- ********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 2228
View Replies !
SQL Server 2005 Express && Windows Reporting Services
Hi, I've just installed SQL Server Express 2005 on our shiny new Windows Server 2003 R x64 server. It has an Intel 830 D chip that uses x86 and 64EMT. Problem is that I get the message "64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit)." Is there any way that I can remedy this? Thanks in advance Robert
View Replies !
SQL Server 2005 Reporting Services On Windows Vista
Hello out there! I've tried to install all features in the SQL Server 2005 to run on Windows Vista. The Reporting Services failed to install. I think it is because of the IIS 7.0 that 's not recognised by SQL Server. Is there anyone who have had the same problem and is there anyone who have a suggestion to solve this problem?
View Replies !
|
TRACKER
