I tried removing and reinstalling SQL Server 2005 Developer Edition for three times, including "all-at-once" component installation and "component-by-component" and I just can't get Integration Services to install.
I am using Script component and trying to import the Microsoft.WindowsAzure.Storage package. i used Nuget within my application and it installed successfully. However, I dont see it in the assemblies as well. Also, when i open the project next time, it is not there and i need to re-install or restore it.
A first chance exception of type 'System.MissingMemberException' occurred in Microsoft.VisualBasic.dll Public member 'Variables' on type 'IDTSPackage90' not found.
Parameter passing in SSIS 2005 sometimes appears to be a cumbursome task. I have been digging into this topic for quite some time and here i note down some simple steps to demonstrate parameter passing at Package level.
(1) Create a SSIS project using Business Intelligence 2005 Or VS 2005.
(2) Create datasource (.ds) and Data Source View as required.
(3) A default SSIS Package by the name Package.dtsx is created. Double click this and you are shown tabs for Control Flow, Data Flow, Event Handlers, Package Explorer. On the Control Flow, drap and drop Execute SQL Task from Control Flow Items in the toolbar.
(4) Lets now create a variable at Package level. Right click anywhere in the control flow box (not on the Task created in Step 3 above). Click on the Variables on the context menu displayed. Variables window appears on the left of the screen. Click the Add Variable box in this window to create a variable. Name it var1 (or whatever you may like), Scope as Package, DataType as String and Value as MyValue. This is only the default value.
(5) Now let us edit the SQL Task created in Step 3. Double on it, on the General tab you can change its Name, Description. Set ResultSet as None. We shall proceed to execute a stored procedure by name MySPName and pass it a parameter. Set ConnectionType as OLE DB. Select the connection you creates in step 2. Set SQLSourceType as Direct input. SQLStatement as MySPName ? . Note the ? mark after the name of the stored procedure. This is important to accept the variable value (var1) created in Step 4.
(6) Select Parameter Mapping tab now. Click on Add button. Select the Variable Name as User::var1. This is the user created variable of Step 4. Select Direction as Input, DataType as Varchar and Parameter Name as @var1. Click on OK now.
(7) This sets up the basic of parameter passing. Compile the project to verify everything works. Right Click on the SQL Task and select Execute Task. This will execute the package taking default value of the variable. This can be used along with dtexec command with /set option to pass the parameter at command prompt.
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
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.
I can't seem to get all of the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log to post (too big), but I can post the SQL9_Hotfix_KB913090.log file...hope that helps and which seems to me might contain the clue as to what's going. Any ideas would be appreciated. This is happening on a fresh install of Win Server 2003 and SQL Server standard 2005.
Thanks,
Steve
04/09/2007 16:14:30.562 ================================================================================ 04/09/2007 16:14:30.578 Hotfix package launched 04/09/2007 16:14:33.312 Product discovery successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.328 SP Level check successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.359 Product language check successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.390 Product version check successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.421 Command-line instance name check completed during the install process 04/09/2007 16:14:33.437 Baseline build check completed during the install process 04/09/2007 16:16:52.828 Attempting to install instance: MSSQLSERVER 04/09/2007 16:16:52.875 Attempting to install target: TURBULENT2 04/09/2007 16:16:53.015 Attempting to stop service: SQLSERVERAGENT 04/09/2007 16:16:58.171 Successfully stopped service: SQLSERVERAGENT 04/09/2007 16:16:58.203 Attempting to stop service: MSSQLServer 04/09/2007 16:17:00.250 Successfully stopped service: MSSQLServer 04/09/2007 16:17:00.281 Attempting to check for locked files: sqlrun_sql.msp 04/09/2007 16:17:00.468 Attempting to check for locked files: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:17:00.500 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.out 04/09/2007 16:17:38.125 MSP returned 1602: The user cancels installation. 04/09/2007 16:17:38.328 Successfully checked file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:17:38.359 Successfully opened registry key: SystemCurrentControlSetControlSession Manager 04/09/2007 16:17:38.421 Failed to read registry key: PendingFileRenameOperations 04/09/2007 16:17:38.468 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll 04/09/2007 16:17:38.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll 04/09/2007 16:17:38.562 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll 04/09/2007 16:17:38.609 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll 04/09/2007 16:17:38.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnlhtml.dll 04/09/2007 16:17:38.734 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsir5jp.dll 04/09/2007 16:17:38.765 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftesql.exe 04/09/2007 16:17:38.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftepxy.dll 04/09/2007 16:17:38.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftefd.exe 04/09/2007 16:17:38.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsfte.dll 04/09/2007 16:17:38.890 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLangWrbk.dll 04/09/2007 16:17:38.921 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnkorwbrkr.dll 04/09/2007 16:17:38.937 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinninfosoft.dll 04/09/2007 16:17:38.968 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERefFTERef.dll 04/09/2007 16:17:39.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnCHTBRKR.DLL 04/09/2007 16:17:39.015 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnChsBrkr.dll 04/09/2007 16:17:39.046 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COMResources1033REPLRES.rll 04/09/2007 16:17:39.062 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COM eplrec.dll 04/09/2007 16:17:39.093 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COM plisapi.dll 04/09/2007 16:17:39.156 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:WINDOWSassemblyGAC_32Microsoft.SqlServer.Replication9.0.242.0__89845dcd8080cc91Repl.dll 04/09/2007 16:17:39.171 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll 04/09/2007 16:17:39.203 Failed to read version information for the following file: C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources10332005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall plhtfin.sql 04/09/2007 16:17:39.218 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall C:Program FilesMicrosoft SQL Server90COMqrdrsvc.exe 04/09/2007 16:17:39.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COMsnapshot.exe 04/09/2007 16:17:39.281 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COM eplmerg.exe 04/09/2007 16:17:39.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90COM ablediff.exe 04/09/2007 16:17:39.328 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COMDISTRIB.exe 04/09/2007 16:17:39.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnDatabaseMail90.exe 04/09/2007 16:17:39.390 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources30822005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources2052sqlevn70.rll 04/09/2007 16:17:39.406 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10422005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1041sqlevn70.rll 04/09/2007 16:17:39.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10402005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1036sqlevn70.rll 04/09/2007 16:17:39.453 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10332005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1031sqlevn70.rll 04/09/2007 16:17:39.484 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10282005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033XPStar90.RLL 04/09/2007 16:17:39.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll 04/09/2007 16:17:39.531 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll 04/09/2007 16:17:39.562 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll 04/09/2007 16:17:39.578 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn6.6.3.5 C:Program FilesMicrosoft SQL Server90Sharedmsxmlsql.dll 04/09/2007 16:17:39.609 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2.0.3609.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlrw.dll 04/09/2007 16:17:39.640 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll 04/09/2007 16:17:39.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll 04/09/2007 16:17:39.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll 04/09/2007 16:17:39.703 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLBOOT.dll 04/09/2007 16:17:39.734 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxplog70.dll 04/09/2007 16:17:39.765 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnatchp~1.dll 04/09/2007 16:17:39.796 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll 04/09/2007 16:17:39.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll 04/09/2007 16:17:39.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll 04/09/2007 16:17:39.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL 04/09/2007 16:17:39.906 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL 04/09/2007 16:17:39.921 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL 04/09/2007 16:17:39.953 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll 04/09/2007 16:17:39.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll 04/09/2007 16:17:40.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll 04/09/2007 16:17:40.031 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE 04/09/2007 16:17:40.062 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE 04/09/2007 16:17:40.078 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE 04/09/2007 16:17:40.140 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90SharedResources10339.0.2047.0 C:Program FilesMicrosoft SQL Server90Sharedmsmdrdir.dll 04/09/2007 16:17:40.156 Failed to read version information for the following file: C:Program FilesCommon FilesSystemole db2.0.3609.0 C:Program FilesCommon FilesSystemole dbxmlrw.dll 04/09/2007 16:17:40.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll 04/09/2007 16:17:40.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll 04/09/2007 16:17:40.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll 04/09/2007 16:17:40.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe 04/09/2007 16:17:40.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe 04/09/2007 16:17:40.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe 04/09/2007 16:17:40.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll 04/09/2007 16:17:40.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll 04/09/2007 16:17:40.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll 04/09/2007 16:17:40.375 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml 04/09/2007 16:17:40.390 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll 04/09/2007 16:17:40.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll 04/09/2007 16:17:40.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033 C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml 04/09/2007 16:17:40.453 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll 04/09/2007 16:17:40.484 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll 04/09/2007 16:17:40.500 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll 04/09/2007 16:17:40.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll 04/09/2007 16:17:40.531 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll 04/09/2007 16:17:40.546 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll 04/09/2007 16:17:40.578 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll 04/09/2007 16:17:40.593 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll 04/09/2007 16:17:40.609 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll 04/09/2007 16:17:40.625 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources10332005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql 04/09/2007 16:17:40.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL 04/09/2007 16:17:40.671 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL 04/09/2007 16:17:40.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL 04/09/2007 16:17:40.703 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2.0.3609.0 C:Program FilesMicrosoft SQL Server90ToolsBinnSQLdiag.exe 04/09/2007 16:17:40.718 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2005.90.2047.0 C:Program FilesMicrosoft SQL Server90Sharedsqlsvc~1.dll 04/09/2007 16:17:40.765 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll 04/09/2007 16:17:40.781 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll 04/09/2007 16:17:40.796 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll 04/09/2007 16:17:40.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll 04/09/2007 16:17:40.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll 04/09/2007 16:17:40.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll 04/09/2007 16:17:40.890 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll 04/09/2007 16:17:40.906 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll 04/09/2007 16:17:40.937 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll 04/09/2007 16:17:40.968 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll 04/09/2007 16:17:40.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll 04/09/2007 16:17:41.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll 04/09/2007 16:17:41.015 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0 C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe 04/09/2007 16:17:41.046 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0 C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll 04/09/2007 16:17:41.062 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe 04/09/2007 16:17:41.125 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe 04/09/2007 16:17:41.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe 04/09/2007 16:17:41.203 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Rmo.dll 04/09/2007 16:17:41.234 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL 04/09/2007 16:17:41.250 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL 04/09/2007 16:17:41.265 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll 04/09/2007 16:17:41.281 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 04/09/2007 16:17:41.312 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 04/09/2007 16:17:41.328 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 04/09/2007 16:17:41.359 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll 04/09/2007 16:17:41.375 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll 04/09/2007 16:17:41.406 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll 04/09/2007 16:17:41.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll 04/09/2007 16:17:41.453 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll 04/09/2007 16:17:41.484 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlSAC.exe 04/09/2007 16:17:41.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedMicrosoft.SqlSac.Public.dll 04/09/2007 16:17:41.687 Attempting to install file: sqlrun_sql.msp 04/09/2007 16:17:41.750 Attempting to install file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:17:41.765 Creating MSP install log file at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log 04/09/2007 16:17:41.796 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 04/09/2007 16:17:41.812 Failed to read registry key: Debug 04/09/2007 16:19:50.187 MSP returned 1603: A fatal error occurred during installation. 04/09/2007 16:19:50.250 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 04/09/2007 16:19:50.265 Failed to read registry key: Debug 04/09/2007 16:19:50.296 Unable to install MSP file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:19:50.312 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/09/2007 16:19:50.312 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856 04/09/2007 16:19:50.437 04/09/2007 16:19:50.468 Product Status Summary: 04/09/2007 16:19:50.500 Product: SQL Server Native Client 04/09/2007 16:19:50.546 SQL Server Native Client (RTM ) - Success 04/09/2007 16:19:50.578 04/09/2007 16:19:50.609 Product: Setup Support Files 04/09/2007 16:19:50.640 Setup Support Files (RTM ) - Success 04/09/2007 16:19:50.656 04/09/2007 16:19:50.687 Product: Database Services 04/09/2007 16:19:50.734 Database Services (SP1 2047 ENU) - Failure 04/09/2007 16:19:50.750 Details: Unable to install Windows Installer MSP file 04/09/2007 16:19:50.781 Reporting Services (SP1 2047 ENU) - Not Applied 04/09/2007 16:19:50.812 04/09/2007 16:19:50.843 Product: Client Components 04/09/2007 16:19:50.890 Client Components (SP1 2047 ENU) - Not Selected 04/09/2007 16:19:50.921 04/09/2007 16:19:50.953 Product: MSXML 6.0 Parser 04/09/2007 16:19:50.968 MSXML 6.0 Parser (RTM ) - Not Selected 04/09/2007 16:19:51.015 04/09/2007 16:19:51.046 Product: SQLXML4 04/09/2007 16:19:51.078 SQLXML4 (RTM ) - Not Selected 04/09/2007 16:19:51.109 04/09/2007 16:19:51.125 Product: Backward Compatibility 04/09/2007 16:19:51.140 Backward Compatibility (RTM ) - Not Selected 04/09/2007 16:19:51.171 04/09/2007 16:19:51.203 Product: Microsoft SQL Server VSS Writer 04/09/2007 16:19:51.265 Microsoft SQL Server VSS Writer (RTM ) - Not Selected 04/09/2007 16:19:51.296 04/09/2007 16:29:32.812 Hotfix package closed
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.
I was unable to install the CTP version of SS Express Edition SP1 with Advance Services. The installation failed with the following error message:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
------------------------------ However, I was able to install and run the standard CTP version of SS Express Edition SP1 without any problems, even though the above error message indicated I may have login problem. First let me confess that my computer does not have IIS installed, which as I understand is only needed for running the Report Services. Is it necessary for IIS to be up and running while installing SSEE with Advance Services?
The main reason I want to install SSEE with Advance Services is to use the full text search capability. I do not need the Report Services, and was hoping there is an option to turn it off and not require IIS. Is this possible?
Windows 2000 Professional (Build 2195: Service Pack 4)
Previous version of SQL Server 2005 Express Edition with Advanced Services CTP was removed using Add/Remove Programs
Visual Studio 2005 Professional is installed
WARNING MESSAGE (should it be an error message since what was requested did not take place?)
--------------------------- Microsoft SQL Server 2005 Setup --------------------------- Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. --------------------------- OK ---------------------------
FAILED WORKAROUND STEPS
1. Used Add/Remove Programs to remove Microsoft SQL Server 2005 (there was only a single instance).
2. Since Microsoft SQL Server 2005 still appeared in the list of programs to remove, decided to reboot.
3. After reboot, Microsoft SQL Server 2005 still appeared in Add/Remove Programs. Clicked the Remove button a second time and clicked the Yes button to remove it from the list.
4. Used Add/Remove Programs to remove Microsoft SQL Server Management Studio Express.
5. Used Add/Remove Programs to remove Microsoft SQL Server Native Client.
22. Selected Latin1_General under Collation designator and sort order.
23. Unchecked Enable User Instances.
24. Setup fails on product Workstation Components, Books Online and Development Tools with the dialog box shown near the top of this post.
Summary Log
-------------------------------------------------------------------------------- Machine : SomeComputerName Product : Workstation Components, Books Online and Development Tools Warning : Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. --------------------------------------------------------------------------------
Detailed Tools Log
=== Verbose logging started: 4/20/2006 10:55:39 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (04:B8) [10:55:39:234]: Resetting cached policy values MSI (c) (04:B8) [10:55:39:234]: Machine policy value 'Debug' is 0 MSI (c) (04:B8) [10:55:39:234]: ******* RunEngine: ******* Product: e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi ******* Action: ******* CommandLine: ********** MSI (c) (04:B8) [10:55:39:250]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (04:B8) [10:55:39:250]: Grabbed execution mutex. MSI (c) (04:B8) [10:55:39:250]: Cloaking enabled. MSI (c) (04:B8) [10:55:39:250]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (04:B8) [10:55:39:250]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (3C:88) [10:55:39:265]: Grabbed execution mutex. MSI (s) (3C:20) [10:55:39:265]: Resetting cached policy values MSI (s) (3C:20) [10:55:39:265]: Machine policy value 'Debug' is 0 MSI (s) (3C:20) [10:55:39:265]: ******* RunEngine: ******* Product: e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi ******* Action: ******* CommandLine: ********** MSI (s) (3C:20) [10:55:39:265]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (3C:20) [10:55:39:281]: File will have security applied from OpCode. MSI (s) (3C:20) [10:55:45:015]: End dialog not enabled MSI (s) (3C:20) [10:55:45:015]: Original package ==> e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi MSI (s) (3C:20) [10:55:45:015]: Package we're running from ==> C:WINNTInstaller19c5ce.msi MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: looking for appcompat database entry with ProductCode '{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (3C:20) [10:55:45:046]: MSCOREE already loaded, using loaded copy MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'TransformsSecure' is 0 MSI (s) (3C:20) [10:55:45:046]: User policy value 'TransformsAtSource' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'DisablePatch' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: looking for appcompat database entry with ProductCode '{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (3C:20) [10:55:45:046]: Transforms are not secure. MSI (s) (3C:20) [10:55:45:046]: Command Line: USERNAME=SomeCompanyName COMPANYNAME=SomeCompanyName INSTALLSQLSHAREDDIR=C:Program FilesMicrosoft SQL Server SAMPLEDATABASESERVER=SomeMachineName STPSETUPTHREADID=1740 STPSETUPPROCESSID=260 EXTERNALCONTROL=1 ADDLOCAL=Client_Components,Connectivity,SDK,SQL_SSMSEE REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=260 %HOMEPATH=Documents and SettingsSomeUserName %HOMEDRIVE=D: %HOMESHARE= MSI (s) (3C:20) [10:55:45:046]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{89DAFCFE-ED1B-4EC7-82EE-1D153F4C0980}'. MSI (s) (3C:20) [10:55:45:046]: Product Code passed to Engine.Initialize: '' MSI (s) (3C:20) [10:55:45:046]: Product Code from property table before transforms: '{58D379F7-62BC-4748-8237-FE071ECE797C}' MSI (s) (3C:20) [10:55:45:046]: Product Code from property table after transforms: '{58D379F7-62BC-4748-8237-FE071ECE797C}' MSI (s) (3C:20) [10:55:45:046]: Product not registered: beginning first-time install MSI (s) (3C:20) [10:55:45:046]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (3C:20) [10:55:45:046]: Entering CMsiConfigurationManager::SetLastUsedSource. MSI (s) (3C:20) [10:55:45:046]: User policy value 'SearchOrder' is 'nmu' MSI (s) (3C:20) [10:55:45:046]: Adding new sources is allowed. MSI (s) (3C:20) [10:55:45:046]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'. MSI (s) (3C:20) [10:55:45:046]: Package name extracted from package path: 'SqlRun_Tools.msi' MSI (s) (3C:20) [10:55:45:062]: Package to be registered: 'sqlrun_tools.msi' MSI (s) (3C:20) [10:55:45:062]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (3C:20) [10:55:45:062]: Machine policy value 'DisableMsi' is 0 MSI (s) (3C:20) [10:55:45:062]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (3C:20) [10:55:45:062]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (3C:20) [10:55:45:062]: Product installation will be elevated because user is admin and product is being installed per-machine. MSI (s) (3C:20) [10:55:45:062]: Running product '{58D379F7-62BC-4748-8237-FE071ECE797C}' with elevated privileges: Product is assigned. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'SomeCompanyName'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'SomeCompanyName'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding SAMPLEDATABASESERVER property. Its value is 'SomeMachineName'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '1740'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '260'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'Client_Components,Connectivity,SDK,SQL_SSMSEE'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '260'. MSI (s) (3C:20) [10:55:45:062]: TRANSFORMS property is now: MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '150'. MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameApplication Data MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameFavorites MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameNetHood MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameMy Documents MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNamePrintHood MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameRecent MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameSendTo MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameTemplates MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersApplication Data MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameLocal SettingsApplication Data MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameMy DocumentsMy Pictures MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart Menu MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersDesktop MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart MenuProgramsAdministrative Tools MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart MenuProgramsStartup MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart MenuPrograms MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart Menu MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameDesktop MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersTemplates MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: C:WINNTFonts MSI (s) (3C:20) [10:55:45:093]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINNTInstaller19c5ce.msi'. MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi'. MSI (s) (3C:20) [10:55:45:093]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (3C:20) [10:55:45:093]: Machine policy value 'DisableRollback' is 0 MSI (s) (3C:20) [10:55:45:093]: User policy value 'DisableRollback' is 0 MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 4/20/2006 10:55:45 === MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (3C:20) [10:55:45:093]: Doing action: INSTALL MSI (s) (3C:20) [10:55:45:109]: Running ExecuteSequence MSI (s) (3C:20) [10:55:45:109]: Doing action: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F Action start 10:55:45: INSTALL. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F. MSI (s) (3C:20) [10:55:45:109]: Doing action: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:109]: Doing action: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:109]: Doing action: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:109]: Doing action: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:156]: Doing action: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:156]: Doing action: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:156]: Doing action: ProgramMenuFolder.ConfigurationTools1033 Action ended 10:55:45: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding ProgramMenuFolder.ConfigurationTools1033 property. Its value is 'D:Documents and SettingsAll UsersStart MenuPrograms'. Action start 10:55:45: ProgramMenuFolder.ConfigurationTools1033. MSI (s) (3C:20) [10:55:45:156]: Doing action: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:45: ProgramMenuFolder.ConfigurationTools1033. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'C:Program Files'. Action start 10:55:45: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2. MSI (s) (3C:20) [10:55:45:156]: Skipping action: SetMDACSxS (condition is false) MSI (s) (3C:20) [10:55:45:156]: Doing action: LaunchConditions Action ended 10:55:45: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:20) [10:55:45:156]: Note: 1: 2205 2: 3: LaunchCondition MSI (s) (3C:20) [10:55:45:156]: Note: 1: 2228 2: 3: LaunchCondition 4: SELECT `Condition`, `Description` FROM `LaunchCondition` Action start 10:55:45: LaunchConditions. MSI (s) (3C:20) [10:55:45:156]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:45: LaunchConditions. Return value 0. MSI (s) (3C:BC) [10:55:45:171]: Invoking remote custom action. DLL: C:WINNTInstallerMSI299.tmp, Entrypoint: StreamSupportFiles MSI (s) (3C:D0) [10:55:45:171]: Generating random cookie. MSI (s) (3C:D0) [10:55:45:171]: Created Custom Action Server with PID 616 (0x268). MSI (s) (3C:70) [10:55:45:187]: Running as a service. MSI (s) (3C:70) [10:55:45:187]: Hello, I'm your 32bit Impersonated custom action server. Action start 10:55:45: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap 1: 0 2: Iterating through _sqlSupportFiles entries Streamed sqlca.D20239D7_E87C_40C9_9837_E70B8D4882C2 to C:Program FilesMicrosoft SQL Server90Setup Bootstrapin{58D379F7-62BC-4748-8237-FE071ECE797C}sqlca.dll MSI (s) (3C:20) [10:55:45:312]: Doing action: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:45: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:45:328]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29A.tmp, Entrypoint: Do_LogInstallStart Action start 10:55:45: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2. Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap Property(SQL): CA DLL Path = C:Program FilesMicrosoft SQL Server90Setup BootstrapBin{58D379F7-62BC-4748-8237-FE071ECE797C}sqlca.dll <Func Name='LaunchFunction'> Function=Do_LogInstallStart <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Do_LogInstallStart PerfTime Start: Do_LogInstallStart : Thu Apr 20 10:55:46 2006 <Func Name='Do_LogInstallStart'> <EndFunc Name='Do_LogInstallStart' Return='0' GetLastError='203'> PerfTime Stop: Do_LogInstallStart : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='203'> MSI (s) (3C:20) [10:55:46:625]: Doing action: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:625]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29B.tmp, Entrypoint: GetDefaultDomain Action start 10:55:46: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=GetDefaultDomain <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: GetDefaultDomain PerfTime Start: GetDefaultDomain : Thu Apr 20 10:55:46 2006 <Func Name='GetDefaultDomain'> MSI (s) (3C!38) [10:55:46:687]: PROPERTY CHANGE: Adding DefaultDomain property. Its value is 'SomeDomainName'. MSI (s) (3C!38) [10:55:46:687]: PROPERTY CHANGE: Adding QuotedDefaultDomain property. Its value is 'SomeDomainName'. MSI (s) (3C!38) [10:55:46:687]: PROPERTY CHANGE: Adding QuotedComputerName property. Its value is 'SomeMachineName'. PerfTime Stop: GetDefaultDomain : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='997'> MSI (s) (3C:20) [10:55:46:687]: Doing action: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:687]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29C.tmp, Entrypoint: RestoreSetupParams Action start 10:55:46: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=RestoreSetupParams Skipping Action: RestoreSetupParams (Condition is false) <EndFunc Name='LaunchFunction' Return='0' GetLastError='203'> MSI (s) (3C:20) [10:55:46:718]: Doing action: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:718]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29D.tmp, Entrypoint: ShutdownServiceManager Action start 10:55:46: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=ShutdownServiceManager <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: ShutdownServiceManager PerfTime Start: ShutdownServiceManager : Thu Apr 20 10:55:46 2006 <Func Name='ShutdownServiceManager'> <EndFunc Name='ShutdownServiceManager' Return='0' GetLastError='2'> PerfTime Stop: ShutdownServiceManager : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='2'> MSI (s) (3C:20) [10:55:46:750]: Doing action: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:765]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29E.tmp, Entrypoint: Write_sqlWellKnownAccountNames Action start 10:55:46: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=Write_sqlWellKnownAccountNames <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Write_sqlWellKnownAccountNames PerfTime Start: Write_sqlWellKnownAccountNames : Thu Apr 20 10:55:46 2006 <Func Name='Write_sqlWellKnownAccountNames'> MSI (s) (3C!38) [10:55:46:781]: PROPERTY CHANGE: Adding AdministratorsGroup property. Its value is 'BUILTINAdministrators'. MSI (s) (3C!38) [10:55:46:796]: PROPERTY CHANGE: Adding UsersGroup property. Its value is 'BUILTINUsers'. MSI (s) (3C!38) [10:55:46:812]: PROPERTY CHANGE: Adding LocalSystemAccount property. Its value is 'NT AUTHORITYSYSTEM'. <EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1332'> PerfTime Stop: Write_sqlWellKnownAccountNames : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='1332'> MSI (s) (3C:20) [10:55:46:843]: Skipping action: PropSetSQLAutoStart.D20239D7_E87C_40C9_9837_E70B8D4882C2 (condition is false) MSI (s) (3C:20) [10:55:46:843]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:843]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29F.tmp, Entrypoint: CheckIIS Action start 10:55:46: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=CheckIIS <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: CheckIIS PerfTime Start: CheckIIS : Thu Apr 20 10:55:46 2006 <Func Name='CheckIIS'> MSI (s) (3C!38) [10:55:46:906]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'. MSI (s) (3C!38) [10:55:46:921]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'. Skipping RS Feature Dependency Check <Func Name='GetXMLAttributeValue'> Error to find XML node /configuration/system.web/compilation <EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'> Failed to get ModuleID_RS_Server when getting the ASP Temp directory. MSI (s) (3C!38) [10:55:47:031]: PROPERTY CHANGE: Adding SqlCOMPlusInstalled property. Its value is '1'. Could not get the ASP temp directory. MSI (s) (3C!38) [10:55:47:031]: PROPERTY CHANGE: Adding RSPREREQUISITECHECKED property. Its value is '1'. MSI (s) (3C!38) [10:55:47:031]: PROPERTY CHANGE: Modifying IISCHECKED property. Its current value is '0'. Its new value: '1'. SqlCOMPlusInstalled value set to 1 <EndFunc Name='CheckIIS' Return='0' GetLastError='0'> PerfTime Stop: CheckIIS : Thu Apr 20 10:55:47 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (3C:20) [10:55:47:031]: Doing action: Create_RSGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:47: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:47:046]: Invoking remote custom action. DLL: C:WINNTInstallerMSI2A0.tmp, Entrypoint: Create_RSGUID Action start 10:55:47: Create_RSGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=Create_RSGUID <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Create_RSGUID PerfTime Start: Create_RSGUID : Thu Apr 20 10:55:47 2006 <Func Name='Create_RSGUID'> MSI (s) (3C!38) [10:55:47:156]: PROPERTY CHANGE: Adding RSGUIDVALUE property. Its value is '{91051fc0-581b-4a79-8672-9ae717477574}'. Starting Create_RSGUID Created new GUID: {91051fc0-581b-4a79-8672-9ae717477574} <EndFunc Name='Create_RSGUID' Return='0' GetLastError='0'> PerfTime Stop: Create_RSGUID : Thu Apr 20 10:55:47 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (3C:20) [10:55:47:171]: Doing action: CheckPassedPropertiesLength.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:47: Create_RSGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:47:171]: Invoking remote custom action. DLL: C:WINNTInstallerMSI2A1.tmp, Entrypoint: CheckPassedPropertiesLength Action start 10:55:47: CheckPassedPropertiesLength.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=CheckPassedPropertiesLength <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: CheckPassedPropertiesLength PerfTime Start: CheckPassedPropertiesLength : Thu Apr 20 10:55:47 2006 <Func Name='CheckPassedPropertiesLength'> CheckPassedPropertiesLength: Property USERNAME is of legal length. MSI (s) (3C!38) [10:55:47:203]: PROPERTY CHANGE: Adding RSSqlPoolLimit property. Its value is '100'. CheckPassedPropertiesLength: Property COMPANYNAME is of legal length. <EndFunc Name='CheckPassedPropertiesLength' Return='0' GetLastError='0'> PerfTime Stop: CheckPassedPropertiesLength : Thu Apr 20 10:55:47 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (3C:20) [10:55:47:203]: Skipping action: CheckForGDRPatch.D20239D7_E87C_40C9_9837_E70B8D4882C2 (condition is false) MSI (s) (3C:20) [10:55:47:203]: Doing action: FindRelatedProducts Action ended 10:55:47: CheckPassedPropertiesLength.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. Action start 10:55:47: FindRelatedProducts. MSI (s) (3C:20) [10:55:47:218]: PROPERTY CHANGE: Adding UPGRADETOOLS90 property. Its value is '{A30965BD-2D4D-45CE-8F04-6A6889818CF1}'. MSI (s) (3C:20) [10:55:47:218]: PROPERTY CHANGE: Adding PRODUCT_TOOLS property. Its value is '{A30965BD-2D4D-45CE-8F04-6A6889818CF1}'. MSI (s) (3C:20) [10:55:47:218]: Doing action: FindUpgradeableProduct Action ended 10:55:47: FindRelatedProducts. Return value 1. MSI (s) (3C:BC) [10:55:47:218]: Invoking remote custom action. DLL: C:WINNTInstallerMSI2A2.tmp, Entrypoint: FindUpgradeableProduct Action start 10:55:47: FindUpgradeableProduct. <Func Name='LaunchFunction'> Function=FindUpgradeableProduct <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: FindUpgradeableProduct PerfTime Start: FindUpgradeableProduct : Thu Apr 20 10:55:47 2006 <Func Name='FindUpgradeableProduct'> Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. <EndFunc Name='FindUpgradeableProduct' Return='259' GetLastError='0'> PerfTime Stop: FindUpgradeableProduct : Thu Apr 20 11:08:55 2006 Gathering darwin properties for failure handling. Loaded DLL: C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version: 2.0.3609.0
<EndFunc Name='LaunchFunction' Return='259' GetLastError='0'> Action ended 11:08:55: FindUpgradeableProduct. Return value 5. Action ended 11:08:55: INSTALL. Return value 1. Property(S): ProductCode = {58D379F7-62BC-4748-8237-FE071ECE797C} Property(S): ProductLanguage = 1033 Property(S): Manufacturer = Microsoft Corporation Property(S): ProductVersion = 9.1.2047.00 Property(S): MEDIAPACKAGEPATH = Setup Property(S): ALLUSERS = 1 Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000} Property(S): ASPNetVersion = 2.0.50727 Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152 Property(S): ARPPRODUCTICON = ARPIcon.ico Property(S): ARPNOREPAIR = 1 Property(S): ARPSYSTEMCOMPONENT = 1 Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2 Property(S): SecureCustomProperties = SQL_SHOWLIC;PRODUCT_TOOLS;UPGRADETOOLS90;PRODUCT_TOOLS_LCID Property(S): SqlServerBuild = 1 Property(S): SqlCluster = 0 Property(S): INSTALLLEVEL = 90 Property(S): FXAssemblyVersion = 2.0.0.0 Property(S): VSAssemblyVersion = 8.0.0.0 Property(S): SqlErrorReporting = #0 Property(S): SqlSqmReporting = #0 Property(S): SqlEnableRanu = 0 Property(S): SqlPatchLevel = 9.1.2047 Property(S): ReleaseProductVersion = 9.00.2047.00 Property(S): SpLevel = 1 Property(S): PIDTemplate = <````=````=````=````=`````>@@@@@ Property(S): UPGRADETOOLS90 = {A30965BD-2D4D-45CE-8F04-6A6889818CF1} Property(S): UpgradeCode = {FED8B2D9-159B-41B0-826C-E3E0F8ADE264} Property(S): PRODUCT_TOOLS = {A30965BD-2D4D-45CE-8F04-6A6889818CF1} Property(S): BOL_INSTALL = SQLServer90 Property(S): ProgramFilesFolder = C:Program Files Property(S): DefaultUIFont = Tahoma8 Property(S): VersionNT = 500 Property(S): INSTALLSQLSHAREDDIR = C:Program FilesMicrosoft SQL Server Property(S): LocalSystemAccount = NT AUTHORITYSYSTEM Property(S): DefaultBuiltInAccount = NetworkServiceAccount Property(S): SqlDisableNetworkProtocols = 1 Property(S): SimpleFeatureTitle_Feat6 = Client Components Property(S): SimpleFeature_Feat6_Expr = &Workstation components and development tools Property(S): Service_AGT = SQL Server Agent Property(S): Service_OLAP = SQL Server Analysis Services Property(S): Service_SQL = SQL Server Property(S): Service_RS = SQL Server Reporting Services Property(S): Service_Browse = SQL Server Browser Property(S): Service_DTS = SQL Server Integration Services Property(S): Service_ADHelper = SQL Server Active Directory Helper Property(S): Service_SQLWriter = SQL Server VSS Writer Property(S): Service_FTS = SQL Server FullText Search Property(S): ServiceDesc_RS = Manages, executes, renders, schedules and delivers reports. Property(S): ServiceDesc_AGT = Executes jobs, monitors SQL Server, and fires alerts, and allows automation of some administrative tasks. Property(S): ServiceDesc_SQL = Provides storage, processing and controlled access of data and rapid transaction processing. Property(S): ServiceDesc_Browse = Provides SQL Server connection information to client computers. Property(S): ServiceDesc_OLAP = Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications. Property(S): ServiceDesc_DTS = Provides management support for SSIS package storage and execution. Property(S): ServiceDesc_ADHelper = Enables integration with Active Directories. Property(S): ServiceDesc_SQLWriter = Provides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure. Property(S): ServiceDesc_FTS = Quickly creates full-text indexes on content and properties of structured and semi-structured data to allow fast linguistic searches on this data. Property(S): ServiceGroupDesc_ADHelper = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Active Directory Helper in SQL Server 2005. Property(S): ServiceGroupDesc_AGT = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Agent in SQL Server 2005. Property(S): ServiceGroupDesc_OLAP = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Analysis Services in SQL Server 2005. Property(S): ServiceGroupDesc_Browse = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Browser in SQL Server 2005. Property(S): ServiceGroupDesc_DTS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Integration Services in SQL Server 2005. Property(S): ServiceGroupDesc_FTS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server and SQL Server FullText Search in SQL Server 2005. Property(S): ServiceGroupDesc_NS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Notification Services in SQL Server 2005. Property(S): ServiceGroupDesc_RS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Reporting Services in SQL Server 2005. Property(S): ServiceGroupDesc_RSWeb = Members in the group have the required access to be assigned as the log on account for the associated instance of SQL Server Reporting Services in SQL Server 2005 Property(S): ServiceGroupDesc_SQL = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server and SQL Server FullText Search in SQL Server 2005. Property(S): ServiceGroupDesc_SQL_NEW = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server in SQL Server 2005. Property(S): ServiceGroupDesc_FTS_NEW = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Full Text Search in SQL Server 2005. Property(S): DlgService_AGT = SQL Server Agent Property(S): DlgService_OLAP = Analysis Services Property(S): DlgService_SQL = SQL Server Property(S): DlgService_RS = Reporting Services Property(S): DlgService_Browse = SQL Browser Property(S): AutoStart_AGT = SQL Server A&gent Property(S): AutoStart_OLAP = &Analysis Services Property(S): AutoStart_SQL = &SQL Server Property(S): AutoStart_RS = Rep&orting Services Property(S): AutoStart_Browse = SQL Bro&wser Property(S): AutoStart_FTS = SQL Server &FullText Search Property(S): _AuthenticationType = Windows Property(S): SQL_rgCollation = 1 Property(S): OLAP_rgCollation = 0 Property(S): _InstanceType = Default Property(S): _LicensingMode = PerSeat Property(S): AGTLogin = DomainAccount Property(S): ASLogin = DomainAccount Property(S): SingleLogin = DomainAccount Property(S): SQLLogin = DomainAccount Property(S): RSLogin = DomainAccount Property(S): SQLBROWSERLogin = DomainAccount Property(S): _UpgradeLogon = Windows Property(S): _SampleDBMode = InstallSD Property(S): ButtonTextStyle = {ButtonTextStyle} Property(S): DlgTextStyle = {DlgTextStyle} Property(S): DlgTextStyleB = {DlgTextStyleB} Property(S): DlgTitleStyle = {DlgTitleStyle} Property(S): DlgTitleStyleB = {DlgTitleStyleB} Property(S): FixedStyle = {FixedStyle} Property(S): T_DataFree = T_DataFree Property(S): T_DataReq = T_DataReq Property(S): T_ProgramFree = T_ProgramFree Property(S): T_ProgramReq = T_ProgramReq Property(S): T_IPVal = T_IPVal Property(S): T_Subnet = T_Subnet Property(S): ErrorDialog = ErrorDlg Property(S): ENABLERANU = 1 Property(S): AccountForAllNodesDlg_Desc = Account for remote setup. Property(S): AccountForAllNodesDlg_Text = Enter a user name and password that is a valid administrator account for all nodes in the cluster system. This will be used during setup only. Property(S): AccountForAllNodesDlg_Title = Remote Account Information Property(S): Authentication_ConfirmPWText = Confirm &password: Property(S): Authentication_DlgDesc = The authentication mode specifies the security used when connecting to SQL Server. Property(S): Authentication_DlgText = Select the authentication mode to use for this installation. Property(S): Authentication_DlgTitle = Authentication Mode Property(S): Authentication_EnterPWText = &Enter password: Property(S): Authentication_saPasswordText = Specify the sa logon password below: Property(S): Authentication_SQL = &Mixed Mode (Windows Authentication and SQL Server Authentication) Property(S): Authentication_Windows = &Windows Authentication Mode Property(S): BrowseFolder_ComboText = &Install in: Property(S): BrowseFolder_DlgDesc = You can select a different folder for installation. Property(S): BrowseFolder_DlgTitle = Change Folders Property(S): BrowseFolder_TailText = Installation &path: Property(S): BrowseFolder_TailTextShared = The SQL Server shared path has already been configured. Property(S): ButtonText_Abort = &Abort Property(S): ButtonText_Add = &Add Property(S): ButtonText_Back = < &Back Property(S): ButtonText_Browse = B&rowse... Property(S): ButtonText_Cancel = Cancel Property(S): ButtonText_Close = &Close Property(S): ButtonText_Complete = &Complete Property(S): ButtonText_ContinueLater = &Continue Later Property(S): ButtonText_DiskCost = &Disk Cost... Property(S): ButtonText_Exit = &Exit Property(S): ButtonText_Finish = &Finish Property(S): ButtonText_Help = &Help Property(S): ButtonText_Ignore = &Ignore Property(S): ButtonText_Install = &Install Property(S): ButtonText_Minimal = &Minimal Property(S): ButtonText_New = &New Property(S): ButtonText_Next = &Next > Property(S): ButtonText_No = &No Property(S): ButtonText_Normal = &Normal Property(S): ButtonText_OK = OK Property(S): ButtonText_Open = &Open Property(S): ButtonText_Reinstall = &Reinstall Property(S): ButtonText_ReinstallMode = &Select the reinstall mode Property(S): ButtonText_Remove = &Remove Property(S): ButtonText_Remove2 = &Remove Property(S): ButtonText_Report = &Report Property(S): ButtonText_Reset = &Reset Property(S): ButtonText_Restore = &Restore Property(S): ButtonText_Resume = &Resume Property(S): ButtonText_Retry = &Retry Property(S): ButtonText_Up = &Up Property(S): ButtonText_Yes = &Yes Property(S): Cancel_DlgDesc = Are you sure you want to cancel the installation? Property(S): Cancel_DlgText = The installation is not complete. If you exit the wizard now, Microsoft SQL Server will not be installed. Property(S): ClusterGroup_DlgDesc = Select the cluster group where the virtual server resources will be installed. Property(S): ClusterGroup_DlgStaticTextAvailable = Available cluster groups: Property(S): ClusterGroup_DlgStaticTextUnavailable = Unavailable cluster groups: Property(S): ClusterGroup_DlgTitle = Cluster Group Selection Property(S): ClusterNodeDlg_ButtonTextAdd = &Add -> Property(S): ClusterNodeDlg_ButtonTextRemove = <- &Remove Property(S): ClusterNodeDlg_StaticTextAvailableNode = Available nodes: Property(S): ClusterNodeDlg_StaticTextRequiredNode = Required node: Property(S): ClusterNodeDlg_StaticTextSelectedNode = Selected nodes: Property(S): ClusterNodeDlg_StaticTextUnavailableNode = Unavailable nodes: Property(S): ClusterNodeDlg_Text = Select the nodes to include in the virtual server. Property(S): ClusterNodeDlg_Title = Cluster Node Configuration Property(S): Collation_Service = S&ervice: Property(S): Collation_Service1 = Collation settings for service: Property(S): Collation_AS_Collation = Analysis Services Collation: Property(S): Collation_ChkBinary = Binary Property(S): Collation_ChkBinary2 = Binary - code point Property(S): Collation_ChkCase = Case - sensitive Property(S): Collation_ChkAccent = Accent - sensitive Property(S): Collation_ChkKana = Kana - sensitive Property(S): Collation_ChkWidth = Width - sensitive Property(S): Collation_Designator = Collation &designator and sort order: Property(S): Collation_DlgDesc = Collation settings define the sorting behavior for your server. Property(S): Collation_DlgCusomizeText = &Customize for each service account Property(S): Collation_DlgTitle = Collation Settings Property(S): Collation_SQL = &SQL collations (used for compatibility with previous versions of SQL Server) Property(S): DiskPrompt = Please insert next disk Property(S): DiskSpace_DlgDesc = Disk space required for the installation exceeds available disk space. Property(S): DiskSpace_DlgDesc1 = The available disk space and the space required for installation are shown below. Property(S): DiskSpace_DlgText = The highlighted volumes, if any, do not have enough disk space available for the currently selected features. Click Disk Cleanup to free disk space and then click Resume to continue the installation, or click Exit to exit the wizard. Property(S): DiskSpace_DlgTitle = Out of Disk Space Property(S): DiskSpace_DlgTitle1 = Disk Cost Property(S): DiskSpace_LBDiskCleanup = Use disk cleanup to free more disk space by removing unneeded files. Property(S): REASON_ADMIN_DISABLED = Administrative shares must be enabled in order to let Setup access remote nodes Property(S): REASON_DARWIN_VER = Windows installer is not present or has not the required version Property(S): REASON_DUP_INSTANCE_NAME_CLST = An instance with the same name is already installed in one or more nodes of the cluster. Property(S): REASON_GROUP_HOSTS_VS = Already contains a SQL Virtual Server Property(S): REASON_GROUP_NO_DISK = Does not contain any valid cluster disk Property(S): ERROR_INVALID_PID = This is an invalid Product Key value. Please check the number located on your Product Key sticker. Property(S): ERROR_INVALID_USERNAME = The Name is required for the installation. Property(S): REASON_NODE_DOWN = The node is down or unavailable Property(S): REASON_NOT_KNOWN = Unknown Property(S): REASON_PENDING_REBOOT = The node must be rebooted before running setup Property(S): REASON_SCC_CHECK_FAILED = A SCC check failed on the node Property(S): ERROR_UNKNOWN = Installation error. Install it by running setup.exe. Property(S): REASON_VERSION_ADDNODE = Adding nodes to the Virtual Server definition using a newer version of Setup is not allowed. Property(S): REASON_OS_VER = SQL Server requires Windows 2000 Service Pack 4, or Windows XP Service Pack 1 or later for installation. Property(S): REASON_OS_TYPE = This version of SQL Server is not supported on this version of Windows. Property(S): Exit_DlgDesc1 = Setup has installed Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc2 = Setup has removed Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc3 = Setup has updated Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc4 = Setup has reinstalled Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc5 = Setup has upgraded Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgTitle = Completing Microsoft SQL Server Setup Property(S): SimpleFeature_DlgDesc = Select the components to install or upgrade. Property(S): SimpleFeature_DlgTitle = Components to Install Property(S): SimpleFeature_Feat1 = &SQL Server Database Services Property(S): SimpleFeature_SQLEngineVS = Create a SQL Server failover cluster Property(S): SimpleFeature_Feat2 = &Analysis Services Property(S): SimpleFeature_AnalysisServerVS = Create an Analysis Server failover cluster Property(S): SimpleFeature_Feat3 = &Reporting Services Property(S): SimpleFeature_Feat4 = N&otification Services Property(S): SimpleFeature_Feat5 = &Integration Services Property(S): SimpleFeature_Feat6 = &Workstation components, Books Online and development tools Property(S): SimpleFeatureTitle_Feat1 = SQL Server Database Services Property(S): SimpleFeatureTitle_Feat2 = Analysis Services Property(S): SimpleFeatureTitle_Feat3 = Reporting Services Property(S): SimpleFeatureTitle_Feat4 = Notification Services Property(S): SimpleFeatureTitle_Feat5 = Integration Services Property(S): SimpleFeature_Advanced = A&dvanced Property(S): SimpleFeature_AdvancedText = For more options, click Advanced. Property(S): SimpleFeature_Components = Components to be installed Property(S): SimpleFeature_OutOfSpace = There is not enough disk space to install the selected components. Click Advanced for more options. Property(S): Feature_DlgDesc = Select the program features you want installed. Property(S): Feature_DlgText = Click an icon in the following list to change how a feature is installed. Property(S): Feature_DlgTitle = Feature Selection Property(S): Feature_FeatureFrame = Feature description Property(S): Feature_GroupBox1 = Installation path Property(S): FileInUse_DlgDesc = Some files that need to be updated are currently in use. Property(S): FileInUse_DlgText = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue. Property(S): FileInUse_DlgTitle = Files in Use Property(S): InitDlg_Title = Microsoft SQL Server Installation Property(S): InitDlg_Desc = Setup is preparing to continue with the installation. Property(S): InitDlg_Text = Please wait while setup prepares to continue with the installation. Property(S): Instance_Default = &Default instance Property(S): Instance_DlgDesc = You can install a default instance or you can specify a named instance. Property(S): Instance_DlgText = Provide a name for the instance. For a default installation, click Default instance and click Next. To upgrade an existing default instance, click Default instance. To upgrade an existing named instance select Named instance and specify the instance name. Property(S): Instance_DlgText1 = To view a list of existing instances and components click on Installed instances. Property(S): Instance_DlgTitle = Instance Name Property(S): Instance_Named = N&amed instance Property(S): IPAddress_DlgDesc = Enter virtual server information. Property(S): IPAddress_DlgStaticTextClusterIP = Network address: Property(S): IPAddress_DlgStaticTextIPAddress = &IP address: Property(S): IPAddress_DlgStaticTextIPSel = &Selected networks and IP addresses: Property(S): IPAddress_DlgStaticTextNetToUse = N&etwork to use: Property(S): IPAddress_DlgStaticTextSubnet = Network subnet: Property(S): IPAddress_DlgStaticTextVSName = Virtual server name: Property(S): IPAddress_DlgText = Enter an IP address for the virtual server. To add IP addreses for additional networks, click Add. Property(S): IPAddress_DlgTitle = Virtual Server Configuration Property(S): License_Devices = devices Property(S): License_Processors = processors Property(S): LicenseModeDlg_DlgDesc = SQL server supports two client licensing modes: per seat licensing and processor licensing. Property(S): LicenseModeDlg_DlgText = Choose the appropriate licensing modes. Property(S): LicenseModeDlg_DlgText1 = Per seat license: each device that accesses Microsoft SQL Server requires a separate license. Property(S): LicenseModeDlg_DlgText2 = Processor license: each processor on this server requires a separate license. Property(S): LicenseModeDlg_DlgTitle = Licensing Mode Property(S): LicenseModeDlg_Processor = &Processor license for Property(S): LicenseModeDlg_RadioButtonGroup = Licensing mode Property(S): LicenseModeDlg_Seat = Per &seat license for Property(S): Maintenance_ChgLabel = Ch&ange Installed Components Property(S): Maintenance_ChgLabelCl = &Maintain the Virtual Server Property(S): Maintenance_ChgText = Maintain features of this instance. Property(S): Maintenance_ChgTextCl = Add or remove nodes to the virtual server. Property(S): Maintenance_DlgDesc = You can change or remove this instance of SQL Server. Property(S): Maintenance_DlgTitle = Change or Remove Instance Property(S): Maintenance_RmvLabel = R&emove Microsoft SQL Server Property(S): Maintenance_RmvText = Remove all features of this existing installation from your computer. Property(S): Maintenance_RmvTextCl = Remove the virtual server from your cluster. Property(S): Maintenance_ChgLabelResume = Complete the &suspended installation Property(S): Maintenance_ChgTextResume = Complete the suspended installation of Microsoft SQL Server on your computer. Property(S): Progress_DlgDesc1 = The program features you selected are being installed. Property(S): Progress_DlgDesc2 = The Microsoft SQL Server is being removed. Property(S): Progress_DlgDesc3 = Setup is installing the components you selected. Property(S): Progress_DlgDesc4 = The Microsoft SQL Server is being reinstalled. Property(S): Progress_DlgText1 = Please wait while Setup installs Microsoft SQL Server. Installation may take several minutes. Property(S): Progress_DlgText2 = Please wait while Setup removes Microsoft SQL Server. This may take several minutes. Property(S): Progress_DlgText3 = Please wait while Setup updates Microsoft SQL Server. This may take several minutes. Property(S): Progress_DlgText4 = Please wait while Setup reinstalls Microsoft SQL Server. Installation may take several minutes. Property(S): Progress_DlgTitle1 = Installing Microsoft SQL Server Property(S): Progress_DlgTitle2 = Removing Microsoft SQL Server Property(S): Progress_DlgTitle3 = Configuring Microsoft SQL Server Property(S): Progress_DlgTitle4 = Reinstalling Microsoft SQL Server Property(S): Progress_lbStatus = Status: Property(S): Register_CompLabel = C&ompany: Property(S): Register_DlgSpec = The following information will personalize your installation. Property(S): Register_DlgText = The Name field must be filled in prior to proceeding. The Company field is optional. Property(S): Register_DlgText1 = Please enter your 25 character Product Key. You can find this number on the yellow sticker in the CD liner notes or the CD sleeve. Property(S): Register_DlgTitle = Registration Information Property(S): Register_NameLabel = N&ame: Property(S): Resume_ResumeText = Setup will complete the suspended installation of Microsoft SQL Server on your computer. To continue, click Next. Property(S): Resume_TextLine1 = Microsoft SQL Server Installation Wizard Property(S): ServiceAccountDlg_Advanced = &Customize for each service account Property(S): ServiceAccountDlg_Autostart = Start services at the end of setup Property(S): ServiceAccountDlg_AutostartServices = Start services at the end of setup Property(S): ServiceAccountDlg_DlgDesc = Service accounts define which accounts to log in. Property(S): ServiceAccountDlg_DlgTitle = Service Account Property(S): ServiceAccountDlg_Domain = Use a domain use&r account Property(S): ServiceAccountDlg_DomainLabel = &Domain: Property(S): ServiceAccountDlg_BuiltIn = Use the built-in S&ystem account Property(S): ServiceAccountDlg_PasswordLabel = &Password: Property(S): ServiceAccountDlg_Service = S&ervice: Property(S): ServiceAccountDlg_Service1 = Service: Property(S): ServiceAccountDlg_UsernameLabel = &Username: Property(S): Setup = Setup Property(S): StartCopy_DlgDesc = Setup is ready to begin installation. Property(S): StartCopy_DlgDescReinst = Setup is ready to begin reinstallation. Property(S): StartCopy_DlgDescRemove = You have chosen to remove the program from your system. Property(S): StartCopy_DlgDescRemoveCl = You have chosen to remove the program from your cluster. Property(S): StartCopy_DlgDescVSConfig = Setup is ready to begin updating your virtual server. Property(S): StartCopy_DlgText = Setup has enough information to start copying the program files. To proceed, click Install. To change any of your installation settings, click Back. To exit setup, click Cancel. Property(S): StartCopy_DlgText2 = Click Cancel to exit setup. Property(S): StartCopy_DlgTextConfig = Setup has enough information to start installation. Click Install to proceed. Property(S): StartCopy_DlgTextReinstData = You have chosen to re-install all features of existing installation including data files, and therefore overwrite the system database. Click Reinstall to proceed. Property(S): StartCopy_DlgTextReinst = You have chosen to re-install all features of existing installation. Click Reinstall to proceed. Property(S): StartCopy_DlgTextRemove = Click Remove to remove Microsoft SQL Server from your computer. After removal, this program will no longer be available for use. Property(S): StartCopy_DlgTextRemoveCl = Click Remove to remove Microsoft SQL Server from your cluster. After removal, this program will no longer be available for use. Property(S): StartCopy_DlgTextUnchanged = You did not change your virtual server configuration. Property(S): StartCopy_DlgTitle = Ready to Install Property(S): StartCopy_DlgTitleConfig = Ready to Update Property(S): StartCopy_DlgTitleReinst = Ready to Reinstall Property(S): StartCopy_DlgTitleRemove = Remove Microsoft SQL Server Property(S): StaticUserName = Account: Property(S): StaticUserPassword = &Password: Property(S): TextDataDir = &Data files: Property(S): TextProgramFileDir = Program files
I installed Sql Server Express 2005 with Advanced Services on a PC.
Several critical items failed to install including: Sql Native Client Sql Server Database Services
The installer Summary Log says: 1) the system does not meet the hardware requirements. (I do not know why... see below) 2) SQL Native Client Error: An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
This is a WinXP SP2 PC with 1.67 ghz processor & 512Meg ram with 12 Gig of Hard disk space remaining unused.
The web site said to install .Net Framework 2.0. I did not see that listed on the links provided so I installed .Net Framework 3.5 instead. That installed fine, althought I get a message that .Net Framework 3.0 failed to install.
When I downloaded Sql Server Express 2005 with Advanced Services, from this web site http://msdn2.microsoft.com/en-us/express/bb410792.aspx, I thought it was unusual... but the download screen said "Publisher Unknown" instead of the usual "Microsoft".
This installation went normally but failed to install those critical items. Can someone tell me what I did wrong, and how to get it installed from here?
I'm trying to install SQL Server 2005 on a server 2000 machine, everything is working with the exception of the Web Service Identity. It is putting machinenameASPNET, and I don't know where to go to make it use something else. I've look around but I have really seen any answers that have worked for me.
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.
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.
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.
Has i install SQL Server 2005 Express Edition with Advanced Services but why that Report Manager it was not installed. To me will not address under the reference http: // localhost/reports$SQLExpress since such catalogue is not present in IIS. In what there can be a problem?
I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service (? spelling). After the failure the installation continued, but marked both the db engine and the management studio failed. Despite this, management studio was installed and later I have removed it with the control panel applet.
I have found a service (executable: aspnet_state.exe), started it and retried the installation. It failed again so I have removed everything installed except the VSS writer and started it again. This time the installation completed (and finally got BIDS).
Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...
I'm trying to install the common components for SQL 2005 on a server that already has Reporting Services 2005 installed on it. It keeps comng up with an error: "To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."
The Reporting Services install has had SP2 applied to it, would that be what is messing up the install?
I have very little experience with SQL so any info would be helpful.
When I install SQL server 2005 and select the option to have Integration Services installed, I cannot see the templates in VS 2005. Is there a way to tell if they have been installed on the harddrive? Is there any way to install them manually?
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?
Would please any here give me any advices for where can I find the SQL Server 2005 Integration Services Installation Guide? The one I found online (http://msdn2.microsoft.com/en-us/library/ms143506.aspx) is just confused me, which is just about the installation of SQL Server 2005 different version.
i have 4 different databases, in each one i have a table of customers i want to combine the 4 tables of customers from the 4 databases in a new table with eliminating similar records
Hello - We have been unable to successfully install Integration Services with an instance of SQL 2005 running on a Windows Small Business Server 2003. Installation proceeds with no errors, but when you attempt to connect to the Integrations Services and browse to where it apparently exists, the SQL Server Managment Studio returns the following error:
TITLE: Connect to Server ------------------------------
I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services. I have been following these 2 websites down to the letter in trying to configure everything:
2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspx <---SharePoint Blog Group
Basically my setup is as follows:
Server 1 = SharePoint 2007
Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007 services
Server 3 = Database
Server1 is setup and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2, SharePoint 2007 is installed again, also under the complete complete option, and configured to join Server1's server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are using 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm.
This is where the headache begins....the SharePoint install is successful on Server2 and the services are started as evident through the Central Administration page. The next task is to install SQL Server 2005 Reporting Services and then the SQL Server 2005 SP2 patch.
After installing SQL Server and the SP2 patch, you go into the SQL Reporting Services Configuration Manager and setup the Report Server, Database, and SharePoint integration. I configure everything to run under the "DefaultAppPool" under IIS, and I get green accepted checkboxes on everything.
Finally, the last step is to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies on Server1. This add-in actually allows the connection between SharePoint on Server1 to the Reporting Services on Server2. The install is successful and the extra options for reporting pop up under Central Administration page. When configuring the final connection under the Central Admin I referred to the following Microsoft Page:
For the "manage integration settings", I set the report server to Server2 and use Windows Authentication. Then for the "grant database access" I use Server2 and login with my credentials...
PROBLEM: Then for the final step of setting the server defaults, I click on the link and get 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. "
I have googled and tried installing/uninstalling several times, but it seems that I keep getting hung up here. When trying to access reports on the ReportServer, the same error message comes up.
If anyone is familiar with integration between SharePoint and SQL Reporting Services, and may have any ideas/comments/advice, I would greatly appreciate it. Thanks in advance! =)
I created an SSIS package for a client that does data importing. When I run the pacakge from Visual Studio there is an error window showing all the errors and warnings. A good example of an error is if the import file is in the wrong format.When there is a error or warning can I write the error log to a file OR notify someone of the errors so they can make corrections and rerun the package OR any ideas that the client can find out what went wrong and then make corrections accordingly? Thanks
I have added reffrence for DTS Run time (using Microsoft.SqlServer.Dts.Runtime;)
But I am getting an Error like this
Error 1 'Application' is an ambiguous reference between 'System.Windows.Forms.Application' and 'Microsoft.SqlServer.Dts.Runtime.Application' C:Documents and Settingsvahqmd10My DocumentsVisual Studio 2005ProjectsWindowsApplication1WindowsApplication1Form1.cs 23 17 WindowsApplication1
Error 2 'Application' is an ambiguous reference between 'System.Windows.Forms.Application' and 'Microsoft.SqlServer.Dts.Runtime.Application' C:Documents and Settingsvahqmd10My DocumentsVisual Studio 2005ProjectsWindowsApplication1WindowsApplication1Form1.cs 23 39 WindowsApplication1
Error 3 The type 'System.Windows.Forms.Application' has no constructors defined C:Documents and Settingsvahqmd10My DocumentsVisual Studio 2005ProjectsWindowsApplication1WindowsApplication1Form1.cs 23 35 WindowsApplication1
Hello, I would love to know where people are discussing the book Microsoft SQL Server 2005 Integration Services book by Kirk Hasleden.
I'm on page 41 and I'm getting an error with the example in the "SELECT "2004" FROM Sales.vSalesPersonSalesByFiscalYears" part because there is not a table called Sales.vSalesPersonSalesByFiscalYears in the AdventureWorks database.
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
My situation:
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
The server is not connected to any network or the internet.
My Question:
Is their any way to fix this? and if yes could anyone tell me where to start
Thanks in Advance!
ps if their is information or logs that u need in order to help me just say so :-)
I have a package that uses a connection defined in the package designer.I also hve some connections defined in the data sources with the same name.How can I change the connections in the package designer to use the connections in the datasources and make all processes use this data sources connection?Thanks
Hi, I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services. In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found" Does anyone have any ideas? Thanks
Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task. I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes. When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:
"Error: Memory Error: Allocation failure. Not enough storage is available to process this command""Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \?D:Program FilesMicrosoft SQL ServerMSSQL.2OLAPDataMyWarehouse<cube file>.xml"
The cube name is not specific, it will fail and any of my cubes could be in the error log
If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine. The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.
I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.
When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.
I've done the following with no effect.
" Have run via AS and works fine " No specific cube it fails on " Have created a Dimension only package, same problem " Changed the maxmemorylimit " Changed the connections to localhost " Memory DOES NOT max out on server
Server Specs: Windows Server 2003 Standard + Service Pack 2 4GM ram, 2GB paging file
Getting error in my log file on Server 2003, SQL Server 2005 install.
MSI (s) (7C:54) [13:11:39:113]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (7C:54) [13:11:39:113]: Warning: Local cached package 'C:WINDOWSInstallerc783219a.msi' is missing. MSI (s) (7C:54) [13:11:39:113]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (7C:54) [13:11:39:113]: User policy value 'DisableMedia' is 0
MSI (s) (7C:54) [13:11:39:113]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (7C:54) [13:11:39:113]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (7C:54) [13:11:39:130]: SOURCEMGMT: Looking for sourcelist for product {5A710547-B58E-488B-828D-CA9A25A0533C}
MSI (s) (7C:54) [13:11:39:130]: SOURCEMGMT: Adding {5A710547-B58E-488B-828D-CA9A25A0533C}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (7C:54) [13:11:39:130]: SOURCEMGMT: Now checking product {5A710547-B58E-488B-828D-CA9A25A0533C}
MSI (s) (7C:54) [13:11:39:146]: SOURCEMGMT: Media is enabled for product.
MSI (s) (7C:54) [13:11:39:146]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (7C:54) [13:11:39:146]: SOURCEMGMT: Trying source d:86b3b0220464711095abf4b4e77e46.
I presume the error is the file it can not file in WindowsInstaller.
Everything in this log has to deal with msxml6, so I am presuming that was the product where a file was removed somehow.
I have done a search on the registry entries mentioned, and those bring me back to the msxml6 package KB927977.
Does anyone know how I can uninstall msxml6 completely and re-install? I have done the Control Panel -> Add Remove Programs -> and removed all MS SQL 2005. I have also gone out to the install location and removed all files under c:program filesmicrosoft sql server