Skocz do zawartości


Zdjęcie

Microsoft SQL 2005 - błąd przy instalacji


  • Zamknięty Temat jest zamknięty
3 odpowiedzi w tym temacie

#1 Raikom

Raikom

    Obserwator

  • 6 postów

Napisano 21 08 2010 - 01:07

Witam.

Chciałbym prosić was o pomoc. Nie mogę zainstalować MSSQL 2005. Podczas instalacji wyskakuje coś takiego
“The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

A potem wyskakuje "Setup failed. Refer to setup log for details" przy "SQL Server Database Services" i "Workstation Components". Jest to o tyle dziwne że kilka dni temu program zainstalował się bezproblemowo. Przy próbie ponownej instalacji zaczęły się kłopoty.

Co robić? Próbowałem już chyba wszystkiego co nasunęło mi się z googli, łącznie z sugestiami z supportu microsoftu. Różne registry cleanery czy usuwacze śmieci po instalacjach nie pomogły. Nawet usunięcie zdechłych kluczy z rejestru nic nie dało. Ten program jest mi diabelnie potrzebny i kompletnie nie mam pojęcia co może być przyczyną sypania się. Czy ktoś spotkał się już z tym?

Setup odsyła do logów. Oto logi które znalazłem:
Microsoft SQL Server 2005 Setup beginning at Sat Aug 21 01:12:51 2010
Process ID      : 936
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.4035.0
Running: LoadResourcesAction at: 2010/7/21 1:12:50
Complete: LoadResourcesAction at: 2010/7/21 1:12:50, returned true
Running: ParseBootstrapOptionsAction at: 2010/7/21 1:12:50
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2010/7/21 1:12:51, returned true
Running: ValidateWinNTAction at: 2010/7/21 1:12:51
Complete: ValidateWinNTAction at: 2010/7/21 1:12:51, returned true
Running: ValidateMinOSAction at: 2010/7/21 1:12:51
Complete: ValidateMinOSAction at: 2010/7/21 1:12:51, returned true
Running: PerformSCCAction at: 2010/7/21 1:12:51
Complete: PerformSCCAction at: 2010/7/21 1:12:51, returned true
Running: ActivateLoggingAction at: 2010/7/21 1:12:51
Complete: ActivateLoggingAction at: 2010/7/21 1:12:51, returned true
Running: DetectPatchedBootstrapAction at: 2010/7/21 1:12:51
Complete: DetectPatchedBootstrapAction at: 2010/7/21 1:12:51, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: 
Condition "EventCondition: __STP_LaunchPatchedBootstrap__936" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: 
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2010/7/21 1:12:51
Complete: PerformDotNetCheck2 at: 2010/7/21 1:12:52, returned true
Running: InvokeSqlSetupDllAction at: 2010/7/21 1:12:52
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlspars.dll Version:2005.90.4035.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [TRAKTOR]
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 = TRAKTOR, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = TRAKTOR, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = TRAKTOR, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = TRAKTOR, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = TRAKTOR, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = TRAKTOR, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = TRAKTOR, Article = XMLDomDocument, Result = 0 (0x0)
Machine = TRAKTOR, Article = Processor, Result = 0 (0x0)
Machine = TRAKTOR, Article = PhysicalMemory, Result = 0 (0x0)
Machine = TRAKTOR, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = TRAKTOR, Article = OSVersion, Result = 0 (0x0)
Machine = TRAKTOR, Article = OSServicePack, Result = 0 (0x0)
Machine = TRAKTOR, Article = OSType, Result = 0 (0x0)
Machine = TRAKTOR, Article = iisDep, Result = 70348 (0x112cc)
Machine = TRAKTOR, Article = AdminShare, Result = 0 (0x0)
Machine = TRAKTOR, Article = PendingReboot, Result = 0 (0x0)
Machine = TRAKTOR, Article = PerfMon, Result = 0 (0x0)
Machine = TRAKTOR, Article = IEVersion, Result = 0 (0x0)
Machine = TRAKTOR, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = TRAKTOR, Article = COMPlus, Result = 0 (0x0)
Machine = TRAKTOR, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = TRAKTOR, Article = MDAC25Version, Result = 0 (0x0)
Machine = TRAKTOR, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: TRAKTOR
*******************************************
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: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
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
Article: Edition Upgrade Check, 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 :1045
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.4035.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2010/7/21 1:14:23, returned true
Running: SetPackageInstallStateAction at: 2010/7/21 1:14:23
Complete: SetPackageInstallStateAction at: 2010/7/21 1:14:23, returned true
Running: DeterminePackageTransformsAction at: 2010/7/21 1:14:23
Complete: DeterminePackageTransformsAction at: 2010/7/21 1:14:24, returned true
Running: ValidateSetupPropertiesAction at: 2010/7/21 1:14:24
Complete: ValidateSetupPropertiesAction at: 2010/7/21 1:14:24, returned true
Running: OpenPipeAction at: 2010/7/21 1:14:24
Complete: OpenPipeAction at: 2010/7/21 1:14:24, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2010/7/21 1:14:24
Complete: CreatePipeAction at: 2010/7/21 1:14:24, 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: 2010/7/21 1:14:24
Complete: PopulateMutatorDbAction at: 2010/7/21 1:14:25, returned true
Running: GenerateRequestsAction at: 2010/7/21 1:14:25
	SQL_Engine = 3
	SQL_Data_Files = 3
	SQL_Replication = -1
	SQL_FullText = -1
	SQL_SharedTools = 3
	SQL_BC_DEP = -1
	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 = -1
	SQL_Tools90 = -1
	SQL_WarehouseDevWorkbench = -1
	SDK = -1
	SQLXML = -1
	Tools_Legacy = -1
	TOOLS_BC_DEP = -1
	SQL_SSMSEE = 3
	SQL_Documentation = -1
	SQL_BooksOnline = -1
	SQL_DatabaseSamples = -1
	SQL_AdventureWorksSamples = -1
	SQL_AdventureWorksDWSamples = -1
	SQL_AdventureWorksASSamples = -1
	SQL_Samples = -1
Complete: GenerateRequestsAction at: 2010/7/21 1:14:26, returned true
Running: CreateProgressWindowAction at: 2010/7/21 1:14:26
Complete: CreateProgressWindowAction at: 2010/7/21 1:14:26, returned true
Running: ScheduleActionAction at: 2010/7/21 1:14:26
Complete: ScheduleActionAction at: 2010/7/21 1:14:27, 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: 2010/7/21 1:14:27
Installing: sqlsupport on target: TRAKTOR
Complete: InstallSqlAction.11 at: 2010/7/21 1:15:12, returned true
Running: InstallSqlAction.12 at: 2010/7/21 1:15:12
Installing: sqlncli on target: TRAKTOR
Complete: InstallSqlAction.12 at: 2010/7/21 1:15:17, returned true
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "sql", install will be skipped as a result.
Running: InstallSqlAction.21 at: 2010/7/21 1:15:17
Installing: sqlwriter on target: TRAKTOR
Complete: InstallSqlAction.21 at: 2010/7/21 1:15:22, returned true
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "sql", install will be skipped as a result.
Running: InstallSqlAction.9 at: 2010/7/21 1:15:22
Installing: msxml6 on target: TRAKTOR
Complete: InstallSqlAction.9 at: 2010/7/21 1:15:25, returned true
Running: InstallToolsAction.11 at: 2010/7/21 1:15:25
Installing: sqlsupport on target: TRAKTOR
Complete: InstallToolsAction.11 at: 2010/7/21 1:16:12, returned true
Running: InstallToolsAction.12 at: 2010/7/21 1:16:12
Installing: sqlncli on target: TRAKTOR
Complete: InstallToolsAction.12 at: 2010/7/21 1:16:53, 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.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run.  Information reported during analysis:
No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.9 at: 2010/7/21 1:16:53
Installing: msxml6 on target: TRAKTOR
Complete: InstallToolsAction.9 at: 2010/7/21 1:16:54, 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: 2010/7/21 1:16:54
Installing: sql on target: TRAKTOR
Failed to install package
Błąd krytyczny podczas instalacji.
Setting package return code to: 29503
Complete: InstallSqlAction at: 2010/7/21 1:17:35, returned false
Error: Action "InstallSqlAction" failed during execution.  Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.23 at: 2010/7/21 1:17:35
Installing: ssmsee on target: TRAKTOR
Complete: InstallToolsAction.23 at: 2010/7/21 1:20:8, returned true
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.
Error: Action "InstallToolsAction" failed during execution.  Error information reported during run:
Action: "InstallToolsAction" will be marked as failed due to the following condition:
Condition "The SQL Server instance that hosts tools is installed." returned false. Condition context: 
tools will be failed due to the hosting instance of SQL Server failing to install.
Installation of package: "tools"  failed due to a precondition.
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.
Error: Action "ExposeVistaClusteredResources" failed during execution.  Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts  is installed." returned false.
Running: ReportChainingResults at: 2010/7/21 1:20:8
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1058
        Error Code: 0x80070422 (1058)
Windows Error Text: Nie można uruchomić określonej usługi, ponieważ jest ona wyłączona lub ponieważ nie są włączone skojarzone z nią urządzenia.

  Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Sat Oct 25 08:47:07 2008
     Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3521

---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0006_TRAKTOR_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0006.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2010/7/21 1:22:33
Message pump returning: 1058


  • 0

#2 Macsch15

Macsch15

    Profesjonalista

  • 3 705 postów

Napisano 21 08 2010 - 05:32

A to
http://bmanmedia.com/2008/04/09/the-sql-server-service-failed-to-start-for-more-information-see-the-sql-server-books-online-topics-how-to-view-sql-server-2005-setup-log-files-and-starting-sql-server-manually/
?

  • 0

#3 Raikom

Raikom

    Obserwator

  • 6 postów

Napisano 21 08 2010 - 14:37

Nie działa. W ogóle u mnie w tych plikach instalacyjnych nie ma \redist\2.0\dotnetfx.exe, już pomijając że one się kasują zaraz po zakończeniu instalacji. Próbowałem też przy instalacji wszystkich trzech opcji “Local System” “Network Service” i “Local Service” - przy każdym to samo.
  • 0

#4 Raikom

Raikom

    Obserwator

  • 6 postów

Napisano 25 08 2010 - 14:51

Ok udało mi się naprawić. Zainstalowałem ;]

Problem był wywoływany przez pozostałości usług po poprzedniej instalacji w rejestrze. W razie gdyby ktoś trafił na taki sam problem, poniżej piszę jak to naprawiłem:
-Otworzyć edytor rejestru (start>uruchom>regedit) i przejść do HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services
-Tam należy pousuwać wszystkie wpisy które mają MSSQL w nazwie. Powinno być ich cztery.
-Zrestartować komputer.

Po restarcie MSSQL zainstalowało się bezproblemowo. Problem zatem rozwiązany.


[uwaga=sebastian10394]
Problem został rozwiązany. Temat zamykam . ;]
[/uwaga]

Użytkownik sebastian10394 edytował ten post 02 12 2010 - 18:10

  • 0




Użytkownicy przeglądający ten temat: 1

0 użytkowników, 1 gości, 0 anonimowych