I made an analysis services project but I can't deploy it because it can't find the server
I search for the analysis service in the Service Control Manager but I can't find it.
Is it possible to download and install it with this version of sql server (workgroup) ?
I am trying to install the SQL Sever 2005 Workgroup Edition software that came with our Small Business Server 2003 R2 system. I would like to install to the d: drive because space on the c: drive is limited. Can I do that? If so, how?
View 1 Replies View Related
Hey,
I have a 3 node cluster running 6 instances of SQL Server, I want to install Analysis Services along side of one of the SQL 2005 instances. Thus one of the cluster instances would host SQL Server DB, Analysis Services and SQL Agent. Is this possible or does Analysis Services need it's own Cluster Instance.
Thanks!
I have a VERY Legitmate use to install sql 4 workgroups on a pc without licensing it. I am making a disk image for MANY pcs to be imaged and load licensing after the imaging is completed.
I have been able to do this with Windows XP Professional, MS Office 2003 and a couple non-Ms programs. The information for MS software even came from their KB, so I know what I am doing is legit. I just can't find any information on doing this for my sql app.
Any suggestions??
Respectfully,
Frustrated
"Frustrated"
I am currently running Windows XP Professional Service Pack2. It already has MSDE & SQL Server 2000 installed (although I just uninstalled MSDE in the vain hope that it might present the installer with a more straightforward upgrade).
I have tried installing with the default instance & a new instance (I don't really care - I just need to install the darn thing). I just want the basic database & Books On-line, nothing fancy.
Here is the Summary log, for what it's worth:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Feb 06 16:45:14 2007
Machine : ANTHONYY1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BOL_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : SQLXML4
Error : Setup is preparing to continue with the installation.
--------------------------------------------------------------------------------
Here is the SQLSetup0011_ANTHONYY1_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Tue Feb 06 16:45:14 2007
Process ID : 2560
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/1/6 16:45:14
Complete: LoadResourcesAction at: 2007/1/6 16:45:14, returned true
Running: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14, returned true
Running: ValidateWinNTAction at: 2007/1/6 16:45:14
Complete: ValidateWinNTAction at: 2007/1/6 16:45:14, returned true
Running: ValidateMinOSAction at: 2007/1/6 16:45:14
Complete: ValidateMinOSAction at: 2007/1/6 16:45:14, returned true
Running: PerformSCCAction at: 2007/1/6 16:45:14
Complete: PerformSCCAction at: 2007/1/6 16:45:14, returned true
Running: ActivateLoggingAction at: 2007/1/6 16:45:14
Complete: ActivateLoggingAction at: 2007/1/6 16:45:14, returned true
Running: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14
Complete: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2560" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2007/1/6 16:45:14
Complete: PerformDotNetCheck2 at: 2007/1/6 16:45:14, returned true
Running: InvokeSqlSetupDllAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [ANTHONYY1]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = ANTHONYY1, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = XMLDomDocument, Result = 0 (0x0)
Machine = ANTHONYY1, Article = Processor, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PhysicalMemory, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSServicePack, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSType, Result = 0 (0x0)
Machine = ANTHONYY1, Article = iisDep, Result = 0 (0x0)
Machine = ANTHONYY1, Article = AdminShare, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PendingReboot, Result = 70011 (0x1117b)
Machine = ANTHONYY1, Article = PerfMon, Result = 0 (0x0)
Machine = ANTHONYY1, Article = IEVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = ANTHONYY1, Article = COMPlus, Result = 0 (0x0)
Machine = ANTHONYY1, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = ANTHONYY1, Article = MDAC25Version, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: ANTHONYY1
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Failed to find help file for LCID :2057
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/1/6 16:49:35, returned true
Running: SetPackageInstallStateAction at: 2007/1/6 16:49:35
Complete: SetPackageInstallStateAction at: 2007/1/6 16:49:36, returned true
Running: DeterminePackageTransformsAction at: 2007/1/6 16:49:36
Complete: DeterminePackageTransformsAction at: 2007/1/6 16:49:47, returned true
Running: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47
Complete: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47, returned true
Running: OpenPipeAction at: 2007/1/6 16:49:47
Complete: OpenPipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/1/6 16:49:47
Complete: CreatePipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2007/1/6 16:49:47
Complete: PopulateMutatorDbAction at: 2007/1/6 16:49:47, returned true
Running: GenerateRequestsAction at: 2007/1/6 16:49:47
SQL_Engine = 3
SQL_Data_Files = 3
SQL_Replication = 3
SQL_FullText = 3
SQL_SharedTools = 3
SQL_BC_DEP = 3
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = -1
NS_Engine = -1
NS_Client = -1
SQL_DTS = -1
Client_Components = 3
Connectivity = 3
SQL_Tools90 = 3
SQL_WarehouseDevWorkbench = 3
SDK = 3
SQLXML = 3
Tools_Legacy = 3
TOOLS_BC_DEP = 3
SQL_Documentation = 3
SQL_BooksOnline = 3
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/1/6 16:49:48, returned true
Running: CreateProgressWindowAction at: 2007/1/6 16:49:48
Complete: CreateProgressWindowAction at: 2007/1/6 16:49:48, returned true
Running: ScheduleActionAction at: 2007/1/6 16:49:48
Complete: ScheduleActionAction at: 2007/1/6 16:49:48, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run. Information reported during analysis:
No install request found for package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run. Information reported during analysis:
No install request found for package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2007/1/6 16:49:48
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallSqlAction.11 at: 2007/1/6 16:49:51, returned true
Running: InstallSqlAction.12 at: 2007/1/6 16:49:51
Installing: sqlncli on target: ANTHONYY1
Complete: InstallSqlAction.12 at: 2007/1/6 16:49:55, returned true
Running: InstallSqlAction.18 at: 2007/1/6 16:49:55
Installing: owc11 on target: ANTHONYY1
Complete: InstallSqlAction.18 at: 2007/1/6 16:49:56, returned true
Running: InstallSqlAction.21 at: 2007/1/6 16:49:56
Installing: sqlwriter on target: ANTHONYY1
Complete: InstallSqlAction.21 at: 2007/1/6 16:49:58, returned true
Running: InstallSqlAction.22 at: 2007/1/6 16:49:58
Installing: bcRedist on target: ANTHONYY1
Complete: InstallSqlAction.22 at: 2007/1/6 16:50:0, returned true
Running: InstallSqlAction.9 at: 2007/1/6 16:50:0
Installing: msxml6 on target: ANTHONYY1
Complete: InstallSqlAction.9 at: 2007/1/6 16:50:2, returned true
Running: InstallToolsAction.11 at: 2007/1/6 16:50:2
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallToolsAction.11 at: 2007/1/6 16:50:5, returned true
Running: InstallToolsAction.12 at: 2007/1/6 16:50:5
Installing: sqlncli on target: ANTHONYY1
Complete: InstallToolsAction.12 at: 2007/1/6 16:50:8, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.18 at: 2007/1/6 16:50:8
Installing: owc11 on target: ANTHONYY1
Complete: InstallToolsAction.18 at: 2007/1/6 16:50:10, returned true
Running: InstallToolsAction.20 at: 2007/1/6 16:50:10
Installing: BOL on target: ANTHONYY1
Complete: InstallToolsAction.20 at: 2007/1/6 16:52:2, returned true
Running: InstallToolsAction.22 at: 2007/1/6 16:52:2
Installing: bcRedist on target: ANTHONYY1
Complete: InstallToolsAction.22 at: 2007/1/6 16:52:4, returned true
Running: InstallToolsAction.9 at: 2007/1/6 16:52:4
Installing: msxml6 on target: ANTHONYY1
Complete: InstallToolsAction.9 at: 2007/1/6 16:52:6, returned true
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Running: InstallSqlAction at: 2007/1/6 16:52:7
Installing: sql on target: ANTHONYY1
Error: MsiOpenDatabase failed with 110
Failed to install package
This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Error: MsiOpenDatabase failed with 110 for MSI D:ServersSetupSqlRun_SQL.msi
Setting package return code to: 1620
Complete: InstallSqlAction at: 2007/1/6 16:52:27, returned false
Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Running: InstallToolsAction.10 at: 2007/1/6 16:52:27
Installing: sqlxml4 on target: ANTHONYY1
Error Code: 0x8007006e (110)
Windows Error Text: The system cannot open the device or file specified.
Source File Name: sqlchainingminorbuildactionbehavior.cpp
Compiler Timestamp: Mon Jun 13 14:30:04 2005
Function Name: sqls::MinorBuildActionBehavior::modifyRequest
Source Line Number: 65
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
Complete: InstallToolsAction.10 at: 2007/1/6 16:55:59, returned false
Error: Action "InstallToolsAction.10" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Action "InstallToolsAction" will return false due to the following preconditions:
Condition "Action: InstallToolsAction.10 has finished and failed." returned true.
Installation of package: "tools" failed due to a precondition.
Step "InstallToolsAction" was not able to run.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2007/1/6 16:55:59
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1620
Error Code: 0x80070654 (1620)
Windows Error Text: This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
led due to cancel code received from cancel source: 29539
...and here is the SQLSetup0011_ANTHONYY1_SQL.log:
=== Verbose logging started: 06/02/2007 16:52:14 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (00:54) [16:52:14:284]: Resetting cached policy values
MSI (c) (00:54) [16:52:14:284]: Machine policy value 'Debug' is 0
MSI (c) (00:54) [16:52:14:284]: ******* RunEngine:
******* Product: D:ServersSetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (c) (00:54) [16:52:14:284]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (00:54) [16:52:14:284]: Grabbed execution mutex.
MSI (c) (00:54) [16:52:14:299]: Cloaking enabled.
MSI (c) (00:54) [16:52:14:299]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (00:54) [16:52:14:299]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A4:98) [16:52:14:299]: Grabbed execution mutex.
MSI (s) (A4:00) [16:52:14:299]: Resetting cached policy values
MSI (s) (A4:00) [16:52:14:299]: Machine policy value 'Debug' is 0
MSI (s) (A4:00) [16:52:14:299]: ******* RunEngine:
******* Product: D:ServersSetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (s) (A4:00) [16:52:21:080]: Note: 1: 2203 2: D:ServersSetupSqlRun_SQL.msi 3: -2147024873
MSI (s) (A4:00) [16:52:21:080]: MainEngineThread is returning 1620
MSI (c) (00:54) [16:52:21:080]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (00:54) [16:52:21:080]: MainEngineThread is returning 1620
=== Verbose logging stopped: 06/02/2007 16:52:21 ===
I suppose an error dialog (or log message) that actually told you what is wrong and then what to do is too much to ask for. (Or an installer than just copied all the files into place). :(
The error I got is:
Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.
EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@sysdbupg.sql@3 P4 : 0x7361
P5 : lib_odbc_statement.h@91 P6 : unknown P7 : sql9 P8 : hotfix@
P9 : x86 P10 : 3042
Log Location: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
I tried to search internet, however, I couldn't get solution.
My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.
Thanks a lot,
Rex
Hi,
I have some questions about SQL Servers 2000 and 2005 compatibility.
In my configuration I have to use both servers.
The cubes are stocked in 2005 server.
May I transfer from 2005 to 2000 Analysis Services the cubes?
If yes, what is the procedure? The result of migration is the same in the two different versions?
If not, how can I solve this problem?
Thanks in advance.
hii
what is SQL Server Analysis Services 2005 ??
thank you
Hi,
With SQL Server 2000, the Enterprise Edition was required to access
Analysis Services across domains.
Is this also the case in SQL Server 2005, that the Enterprise Edition
is needed?
Thanks, S
Hi to all
I have a complex scenario , so first I want to ask out the feasibility of it . I think its better if I state the scenario and some one on this forum reply to it , I need to build an application (e.g credit card application , Loan Application etc ) that requires some approval from expert , what I firstly want is that I apply datamining on this data so that next time when I enter the data the result (approval or reject ) should be given by datamining tool , this I gather is poosible by using Analysis Services in SQL 2005 , but I also want the bases of that decision ( I mean the rules/some thing else that the Datamining created agaisnt the data entered ) , So can any one do any help on this , you can also reach me at razi_rais@yahoo.com . its preety much urgent so your prompt response is higly appreciated.
Thanks and Regards
Razi Bin Rais
Hi,
Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?
Thanks
I Have Sql Server 2005 Enterprises Edition. I Could'nt able to install database services as the all check boxes above
Reporting Service
Integretion Service
Database Service are disabled. so i could not able to install database and services.
Please figure me out.
Hi all,
Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.
So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.
Is it possible to keep data engine as standard version and install a enterprise version of analysis service?
Thank you very much
Tony
Hi, all here,
Would please anyone here give me any idea about how can I connect to SQL Server 2005 analysis services server and send XML request to it programmatically (with Business intelligence development studio in SQL Server 2005)? Thanks a lot.
With best regards,
Yours sincerely,
Does anyone have instructions on how to configure http access to SQL Server 2005 Analysis Services on Vista?
View 5 Replies View RelatedI'm looking for a new way to publish reports based on OLAP data and was very disappointed to find that Reporting Services does not natively support displaying MDX query results in a matrix. While it is possible to assign an MDX query to the matrix control in Reporting Services, the two main problems are that the columns of the query must be measures (not dimensions), and it does not support display of server based formatting (fore color, back color, and font flags).
Does anyone know of any custom control that properly deals with Analysis Services data?
Thanks for any info you have!
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
------------------------------
Cannot connect to ABDI04.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Connect to SSIS Service on machine "ABDI04" failed:
The specified service does not exist as an installed service.
.
------------------------------
Connect to SSIS Service on machine "ABDI04" failed:
The specified service does not exist as an installed service.
.
------------------------------
BUTTONS:
OK
------------------------------
We have tried uninstalling the Integration Services, then reinstalling it and again applying SP2 with the same results.
Thank you.
I tried to install 'SQL Server 2005 Express Edition with Advanced Services'. First, I uninstalled the old version thru Add/Delete Programs in the Control Panel.
My first problem was I didn't have IIS installed on my computer, but, I could not find it in the downloads section.
Then the installation aborted because old version databases were in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. But, it would not let me delete them, saying that they were being used, even though nothing was running at the time that I tried to delete them.
I get the following error message each time I try to install SQL Server 2005 Express Edition with Advanced Services SP2:
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
This problem is described in:
http://support.microsoft.com/kb/920201
and each of the IIS 7 components specified in this article have been installed.
When I continue with:
http://support.microsoft.com/kb/934162,
the script 'adsutil.vbs' cannot be executed because it does not exist anywhere on my drive.
My question is, what is the 'adsutil.vbs' script and how do I get a hold of it? Are these contortions really necessary to get SQL server working or has MS provided a patch for this nasty problem?
My system:
VISTA Home Premium, x64
Intel Quad CPU, 2.4GHz
4Gig RAM
500Gig hard disk
Thanks,
Ian
I have, a SSAS 2012 tabular instance with SP2, there is a database on the instance with a read role with everyone assigned permissions. When configuring the Power BI analysis services connector, at the point where you enter Friendly Name, Description and Friendly error message, when you click next I receive the error "The remote server returned an error (403)." I've tested connecting to the database from Excel on a desktop and connect fine.I don't use a "onmicrosoft" account so don't have that problem to deal with.
We use Power BI Pro with our Office 365. As far as I can tell that part is working ok as I pass that stage of the configuration with a message saying connected to Power BI.The connector is installed on the same server as tabular services, its a Win2012 Standard server. The tabular instance is running a domain account that is the admin account for the instance (this is a dev environment) that account is what I've used in the connector configuration. It's also a local admin account. There is no gateway installed on the server.
Hi,
I am having an existing sql 2005 cluster on an active passive cluster. I need to add analysis service to this as a new component. I am having enough space available in the cluster disks. Following are my queries,
1) do i need a new virtual ip and virtual server name for the analysis services ?
2) do i need a seperate cluster resource group for analysis services with an additional disk added ?
Regards
Nimesh
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
SQL Server 2005 + Service Pack 2
Can anyone help?
Andy
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'.
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8
Action ended 8:03:54: AppSearch. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'.
Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is '
- MSXML6'.
Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583'.
Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs
Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
Action start 8:03:54: CA_ErrorMissingPreReqs.
MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3.
Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks,
---
Barry Roskuski barry.roskuski@esko.com
EskoArtwork
Ludlow, MA
I originally posted this on the SQL Server Setup and Upgrade forum, but then I found this forum and though it might be more appropriate...
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'.
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8
Action ended 8:03:54: AppSearch. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'.
Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is '
- MSXML6'.
Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583'.
Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs
Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
Action start 8:03:54: CA_ErrorMissingPreReqs.
MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3.
Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks,
---
Barry Roskuski barry.roskuski@esko.com
EskoArtwork
Ludlow, MA
i've tried to install sql server 2005 express edition several times but when it get to the 'database services' it gives the following error:
SQL Server Setup could not connect to the database service configuration. The error was:
[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
please help
Hi All,
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
Regards,
Joseph
Hi all,
How can I Import a database from Analysis Services database to SQL SERVER using SQL SERVER 2005.
forexample the Adventure Works DW database from Analysis Services to SQL SERVER database.
Any ideas will be higly appreciated.
Thanx
Hello,
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
thank you
regards
Andreas
I have SQL Express 2005 with Advanced Services on a development box that I also want to have installed side-by-side with SQL Server 2005 Standard Edition so I can develop apps using either edition based on the features I need (or don't need). From what I understand from sifting through other posts is that side-by-side installs of these two editions is supported and I should setup a named instance for each edition (SQLEXPRESS for the express edition and MSSQLSERVER for the standard edition). Is this setup accurate or is there another/better way?
Also, does anybody know if side-by-side installations of Reporting Services is also supported? If I install SQL Server 2005 Standard Edition with Reporting Services, will there be two different report servers running in IIS? Since there are different features in Reporting Services between the two editions, I'm not sure how side-by-side installations will effect one another.
Thanks in advance for any help,
Tony
I am installing SQL Server 2005 Express Edition with Advanced Services on Windows XP Home Edition SP2 and received error 29521. I am installing with an account that has administrator rights.
The summary.txt file contains:
Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. Refer to the server error logs and Setup logs for detailed error information.
Error Number : 29521
Does anyone have suggestions as to the problem?
HI All,
After i installed SQL Server 2005 workgroups edition to my Laptop, P4 and 1 Giga memory. I had a problem.
my problem is: when i start my laptop need 4 minutes to start the windows xp pro edition.
then I format my laptop and install the windows again, and every thing works fine, but I installed the SQL again and i had same problem with windows startup, there is nothing related to SQL in ;msconfig utilities.
do you have any tip about this problem ?
Thank You
Good day,
We have developed an application using VS 2005 and SQL Server 2005 Developer Edition.
Currently, our client is asking if they could buy the SQL Server 2005 Workgroup Edition.
Is it ok? I'm afraid that the SP we made using CLR and any other functionality might not work.
We are suggesting our client to use the SQL Server 2005 Standard Edition instead. But for them to save money, can they use the Workgroup Edition instead?
I would really appreciate your help.
Thanks and more power,
Arthur
Hi all,
I am trying to install the workgroup edition on Windows SBS 2003 R2. After the removal of an unwanted
SQL Express Edition installation - the standard install of SQL 2005 from CD hangs during setup.
In the log file _WI.log is:
...
MSI (s) (B0:2C) [23:01:14:968]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (B0:2C) [23:01:14:968]: MsiProvideAssembly is returning: 1607
MSI (s) (B0:2C) [23:01:14:968]: No System Restore sequence number for this installation.
MSI (s) (B0:2C) [23:01:14:968]: Unlocking Server
MSI (s) (B0:2C) [23:01:14:968]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
MSI (s) (B0:2C) [23:01:15:015]: MainEngineThread is returning 1603
MSI (s) (B0:A0) [23:01:15:109]: Destroying RemoteAPI object.
MSI (s) (B0:80) [23:01:15:109]: Custom Action Manager thread ending.
MSI (c) (B4:54) [23:01:15:125]: Back from server. Return value: 1603
MSI (c) (B4:54) [23:01:15:125]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B4:54) [23:01:15:125]: PROPERTY CHANGE: Deleting SECONDSEQUENCE property. Its current value is '1'.
Aktion beendet um 23:01:15: ExecuteAction. Rückgabewert 3.
MSI (c) (B4:54) [23:01:15:125]: Skipping action: FatalError (condition is false)
Aktion beendet um 23:01:15: INSTALL. Rückgabewert 3.
Any advice would be great!
THufschmidt