Kako unistiti prethodnu verziju SQL Servera?

Pokusavam da instaliram SQL Server 2008 na lap topu.

Pre ove verzije sto hocu da instaliram sam imao SQL Server 2005.
Unistio sam ga preko Add/Remove, obrisao njegov folder u C:/ ali dzaba, instalcija SQL Servera 2008 mi na kraju u logu kaze ovo:


Overall summary:
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Start time: 2012-06-07 18:25:48
End time: 2012-06-07 19:56:41
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt
Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1442.32%26EvtType%3dMicrosoft.SqlServer.Configuration.Sco.Service.StartService%40System.ComponentModel.Win32Exception

Machine Properties:
Machine name: NATASA
Machine processor count: 1
OS version: Windows XP
OS service pack: Service Pack 3
OS region: Srbija
OS language: English (United States)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered

Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: C:\x86\setup\
Installation edition: EVAL

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTDOMAINGROUP: <empty>
AGTSVCACCOUNT: NT AUTHORITY\SYSTEM
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Automatic
ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS10.SQLSERVER\OLAP\Backup
ASCOLLATION: Cyrillic_General_CI_AS
ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS10.SQLSERVER\OLAP\Config
ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS10.SQLSERVER\OLAP\Data
ASDOMAINGROUP: <empty>
ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS10.SQLSERVER\OLAP\Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: NT AUTHORITY\SYSTEM
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: NATASA\Srdjan
ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS10.SQLSERVER\OLAP\Temp
BROWSERSVCSTARTUPTYPE: Automatic
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: True
FAILOVERCLUSTERDISKS: <empty>
FAILOVERCLUSTERGROUP: <empty>
FAILOVERCLUSTERIPADDRESSES: <empty>
FAILOVERCLUSTERNETWORKNAME: <empty>
FAILOVERCLUSTERROLLOWNERSHIP: 2
FEATURES: SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
FTUPGRADEOPTION: Import
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: SQLSERVER
INSTANCENAME: SQLSERVER
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: C:\
NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSCATALOGSERVERINSTANCENAME: Unknown
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: NT AUTHORITY\SYSTEM
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD: *****
RULES: <empty>
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Cyrillic_General_CI_AS
SQLDOMAINGROUP: <empty>
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: NATASA\Srdjan
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: True
TCPENABLED: 0
X86: False

Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\ConfigurationFile.ini

Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: SQL Client Connectivity SDK
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Analysis Services
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Reporting Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Integration Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: System.ComponentModel.Win32Exception
Configuration error description: The service did not respond to the start or control request in a timely fashion.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt

Feature: Client Tools Connectivity
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: System.ComponentModel.Win32Exception
Configuration error description: The service did not respond to the start or control request in a timely fashion.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt

Feature: Management Tools - Complete
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: System.ComponentModel.Win32Exception
Configuration error description: The service did not respond to the start or control request in a timely fashion.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt

Feature: Management Tools - Basic
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: System.ComponentModel.Win32Exception
Configuration error description: The service did not respond to the start or control request in a timely fashion.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt

Feature: Client Tools SDK
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: System.ComponentModel.Win32Exception
Configuration error description: The service did not respond to the start or control request in a timely fashion.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt

Feature: Client Tools Backwards Compatibility
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: System.ComponentModel.Win32Exception
Configuration error description: The service did not respond to the start or control request in a timely fashion.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt

Feature: Business Intelligence Development Studio
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: System.ComponentModel.Win32Exception
Configuration error description: The service did not respond to the start or control request in a timely fashion.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt

Feature: SQL Server Books Online
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Microsoft Sync Framework
Status: Passed
MSI status: Passed
Configuration status: Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\SystemConfigurationCheck_Report.htm



Sta da radim?

Pokušaj da deinstaliraš SQL Server Native Client pa probaj ponovo.

Ma unistim ja sve sto ima veze sa SQL-om, ali opet ista stvar.

Koliko vidim iz ovoga što je postovano, rekao bih da se radi o (kompletnoj) instalaciji SQL Server Standard ili Enterprise. Nisam 100% siguran, ali mislim da na Windows XP ne može da ide puna verzija SQL Servera. Neka me ispravi neko ko to bolje zna.

Jedini ovde vidljivi razlog za neuspešno instaliranje pojedinih komponenata je "The service did not respond to the start or control request in a timely fashion.", što znači da SQL servis nije uspešno startovan u toku instalacije. Ako to već nije urađeno, instalaciju je neophodno pokrenuti sa punim administratorskim pravima (Run as Administrator).

Ne bi bilo loše da vidimo log fajl koji je instaler napravio (C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120607_181839\Detail.txt). Neka ga OP zakači uz prvi post.

Potpis

"There is a theory which states that if ever anybody discovers exactly what the
Universe is for and why it is here, it will instantly disappear and be replaced by
something even more bizarre and inexplicable. There is another theory which states
that this has already happened."
-- Douglas Adams

Okacicu kasnije, sad sam na drugom kompjuteru jer mi je lap top zauzet, a sa lap topa sam poslao poruku.

Na ovom kompjuteru imam Windows 7 OS.
E sad pazi ovo sta je ovde problem. Svaki put kada pokrenem instalaciju SQL Servera 2008R2 on pukne, bez ikakvog errora, ali posle 4-5 instalacija on svaki put pukne sa bilo kojom verzijom SQL Servera 2008 R2. U pocetku nije bio taj problem, tad sam imao drugi problem koji sad znam da resim. Pa sam onda pokusao sa SQL Serverom 2005, i on ne moze da instalira Management Studio zbog COM+ Cataloga, a njega nemam u Programs and Features. Pa sam pokusao sa 2012 verzijom, i ona mi prijavi problem da moj Visual Studio 2010 treba update na SP1, ja krenem update kad ono ne moze naci Runtime. Pokrenem 2005 na lap topu IIS mu fali i ne moze instalirati Analyses Service i Database Service.

Tako da sam totalno zamrzeo ceo SQL Server i okrenuo se MySQL-u. Ne bih ga nikad instalirao da ne moram poloziti baze podataka. Kako negde tamo u nekom dalekom kodu tog glupog SQL-a i Visual Studia nisu stavili operaciju:

IF(FILE.EXIST)
{
uradi instalaciju;
}
else
{
download sta mu treba;
}

Generalno pravilo: pre instalacije bilo kog Microsoft proizvoda, obavezno uraditi update Windowsa. To obično rešava sve probleme koji mogu da se jave prilikom instalacije istih.

Drugo pravilo: obavezno pokrenuti Windows Update (Check for Updates) više puta jer postoje neophodni (prerequisites) apdejtovi bez kojih se sledeći neće instalirati.

Što se tiče instalacije SQL Servera, nije to tako jednostavno kao što misliš. Ono što je tebi bitno, postoji mogućnost da ti imaš problem zbog nekog Anti-Virus programa, pa se generalno preporučuje zatvaranje svih aktivnih programa, uključujući bilo kakve pozadinske programe koji bi mogli da utiču na instaliranje (najčešće Anti-Virusi i bilo koji drugi zaštitni programi).

Potpis

"There is a theory which states that if ever anybody discovers exactly what the
Universe is for and why it is here, it will instantly disappear and be replaced by
something even more bizarre and inexplicable. There is another theory which states
that this has already happened."
-- Douglas Adams

SQL Server 2008 R2 Enterprise i Datacentar nisu podržane na Windows 7 platformi a ni ove niže sve nisu podržane na SVIM windows 7 edicijama.

Mislim da to nije tacno jer su nam na faksu svi sistemi Windows 7 i na njima SQL Serveri 2008 R2. :)

rambo poslusacu tvoj savet, probacu jos jednom pa nek' ide zivot. :)

Problem na Windows 7 je taj sto mi je na tom kompjuteru Visual Studio 2010 Professional, a instalacija SQL Servera 2012 zahteva SP1, pokusao sam update Visual Studia, ali bezuspesno jer mi instalacija ne moze naci neki Runtime?

Jedna stvar je jedino moguca, da unistim Visual Studio 2010 i instaliram 2010sp1, pa tek onda SQL 2012?

Ali ako ikako moze da se zaobidje to, bilo bi savrseno jer instalacija Visual Studija traje duze nego instalacija celog sistema. :)

http://technet.microsoft.com/e...brary/ms143506(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms143506.aspx

Pozdrav.

Zašto ne instaliraš SQL Server 2008 R2 Express? Ako se ne varam, isti dolazi uz Visual Studio 2010 Professional ili bolji. Postoji mogućnost da je već instaliran pa ti možda on pravi problem oko instalacije "pune" verzije.

Visual Studio 2010 SP1 možeš da instaliraš preko njega (upgrade) tako da ne moraš da ga kompletno reinstaliraš.

Microsoft Visual Studio 2010 Service Pack 1 (Installer)
http://www.microsoft.com/en-us/download/details.aspx?id=23691
(Ovo je online installer (treba ti internet konekcija) a ima i ISO download odmah ispod "Instructions" sekcije)

Ako sve ovo radiš zbog fakulteta, tj. da bi uradio neki projekat kući, stvarno ti nije potrebno ništa jače od Express verzije. U njoj imaš sve što ti treba za to. Imaš čak i "Express with Management Tools" i "Express with Advanced Services" verzije koje imaju sve dodatne alate koji ti trebaju. Evo ti linkova ka svim verzijama, pa ti biraj šta ti treba.

Microsoft® SQL Server® 2008 R2 SP1 - Express Edition
http://www.microsoft.com/en-us/download/details.aspx?id=26729

Microsoft SQL Server 2008 R2 RTM - Express with Management Tools
http://www.microsoft.com/en-us/download/details.aspx?id=23650

Microsoft SQL Server2008 R2 RTM - Express with Advanced Services
http://www.microsoft.com/en-us/download/details.aspx?id=25174

Potpis

"There is a theory which states that if ever anybody discovers exactly what the
Universe is for and why it is here, it will instantly disappear and be replaced by
something even more bizarre and inexplicable. There is another theory which states
that this has already happened."
-- Douglas Adams