SQL Server Express R2

needforspeed · 17 Jan 2011 at 21:14

Can't install SQL Server Express R2

Hi, I can't install Visual Web Developer 2010 Express because SQL Server Express 2008 R2 is a dependency, which does not install properly as well. I need SQL Server for databases, so it needs to be installed. I use Windows 7. Thanks.

needforspeed · 17 Jan 2011 at 21:19

SQL summary

Code:

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):           -1706970590
  Exit facility code:            577
  Exit error code:               45602
  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:                    2011-01-16 21:58:18
  End time:                      2011-01-16 22:01:32
  Requested action:              Install
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_215704\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.50.1600.1%26EvtType%3d0x7590AFD6%400x9A41B222

Machine Properties:
  Machine name:                  KENNY
  Machine processor count:       8
  OS version:                    Windows 7
  OS service pack:               
  OS region:                     United Kingdom
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

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

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         c:\a0c10882d1c144e6b5\x64\setup\
  Installation edition:          EXPRESS

User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      True
  AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Disabled
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASDOMAINGROUP:                 <empty>
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_215704\ConfigurationFile.ini
  CUSOURCE:                      
  ENABLERANU:                    True
  ENU:                           True
  ERRORREPORTING:                False
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      SQLENGINE,REPLICATION
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 *****
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  True
  INDICATEPROGRESS:              False
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <empty>
  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
  INSTANCEID:                    SQLEXPRESS
  INSTANCENAME:                  SQLEXPRESS
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  NPENABLED:                     0
  PASSPHRASE:                    *****
  PCUSOURCE:                     
  PID:                           *****
  QUIET:                         True
  QUIETSIMPLE:                   False
  ROLE:                          AllFeatures_WithDefaults
  RSINSTALLMODE:                 FilesOnlyMode
  RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
  RSSVCPASSWORD:                 *****
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  Latin1_General_CI_AS
  SQLSVCACCOUNT:                 NT AUTHORITY\Network Service
  SQLSVCPASSWORD:                *****
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           <empty>
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBLOGDIR:               <empty>
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  False
  TCPENABLED:                    0
  UIMODE:                        AutoAdvance
  X86:                           False

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

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0x9A41B222
  Configuration error description: '' is not a valid login or you do not have permission.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_215704\Detail.txt

  Feature:                       SQL Server Replication
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0x9A41B222
  Configuration error description: '' is not a valid login or you do not have permission.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_215704\Detail.txt

Rules with failures:

Global rules:

Scenario specific rules:

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

Microsoft Web Platform Installer

Code:

DownloadManager Information: 0 : Loading product xml from: https://go.microsoft.com/?linkid=9741476
DownloadManager Information: 0 : https://go.microsoft.com/?linkid=9741476 responded with 302
DownloadManager Information: 0 : Response headers:
HTTP/1.1 302 Found
Cache-Control: private
Content-Length: 175
Content-Type: text/html; charset=utf-8
Expires: Sun, 16 Jan 2011 21:49:29 GMT
Location: https://www.microsoft.com/web/webpi/3.0/webproductlist.xml
Server: Microsoft-IIS/7.5
X-AspNet-Version: 2.0.50727
Set-Cookie: MC1=GUID=303129c0d229004ab4310a4af28d4070&HASH=c029&LV=20111&V=3; domain=microsoft.com; expires=Sun, 03-Oct-2010 07:00:00 GMT; path=/
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:50:29 GMT


DownloadManager Information: 0 : https://www.microsoft.com/web/webpi/3.0/webproductlist.xml responded with 304
DownloadManager Information: 0 : Response headers:
HTTP/1.1 304 Not Modified
Cache-Control: max-age=900
Last-Modified: Fri, 14 Jan 2011 22:17:31 GMT
Accept-Ranges: bytes
ETag: "9615fdd538b4cb1:0"
Server: Microsoft-IIS/7.5
VTag: 279845842500000000
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:50:30 GMT


DownloadManager Information: 0 : Remote file has not changed, using local cached file: C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\1055808507.xml.temp
DownloadManager Information: 0 : Filtering by majorOS: 6, minorOS: 1, majorSP: 0, minorSP: 0, productType: 3, architecture: x64
DownloadManager Information: 0 : Loading product xml from: https://www.microsoft.com/web/webpi/3.0/webapplicationlist.xml
DownloadManager Information: 0 : https://www.microsoft.com/web/webpi/3.0/webapplicationlist.xml responded with 304
DownloadManager Information: 0 : Response headers:
HTTP/1.1 304 Not Modified
Cache-Control: max-age=900
Last-Modified: Fri, 14 Jan 2011 22:24:41 GMT
Accept-Ranges: bytes
ETag: "e51e7bd639b4cb1:0"
Server: Microsoft-IIS/7.5
VTag: 79158243000000000
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:50:31 GMT


DownloadManager Information: 0 : Remote file has not changed, using local cached file: C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\-1338951197.xml.temp
DownloadManager Warning: 0 : Could not resolve keyword ID Orchard
DownloadManager Information: 0 : Filtering by majorOS: 6, minorOS: 1, majorSP: 0, minorSP: 0, productType: 3, architecture: x64
DownloadManager Information: 0 : Loading product xml from: https://www.microsoft.com/web/webpi/3.0/mediaproductlist.xml
DownloadManager Information: 0 : https://www.microsoft.com/web/webpi/3.0/mediaproductlist.xml responded with 304
DownloadManager Information: 0 : Response headers:
HTTP/1.1 304 Not Modified
Cache-Control: max-age=900
Last-Modified: Mon, 06 Dec 2010 20:57:55 GMT
Accept-Ranges: bytes
ETag: "a64816418895cb1:0"
Server: Microsoft-IIS/7.5
VTag: 438954842500000000
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:50:31 GMT


DownloadManager Information: 0 : Remote file has not changed, using local cached file: C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\664384761.xml.temp
DownloadManager Information: 0 : Filtering by majorOS: 6, minorOS: 1, majorSP: 0, minorSP: 0, productType: 3, architecture: x64
DownloadManager Information: 0 : Loading product xml from: https://www.microsoft.com/web/webpi/3.0/toolsproductlist.xml
DownloadManager Information: 0 : https://www.microsoft.com/web/webpi/3.0/toolsproductlist.xml responded with 304
DownloadManager Information: 0 : Response headers:
HTTP/1.1 304 Not Modified
Cache-Control: max-age=900
Last-Modified: Thu, 06 Jan 2011 18:54:54 GMT
Accept-Ranges: bytes
ETag: "63ece34d3adcb1:0"
Server: Microsoft-IIS/7.5
VTag: 438324142000000000
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:50:31 GMT


DownloadManager Information: 0 : Remote file has not changed, using local cached file: C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\1956869252.xml.temp
DownloadManager Information: 0 : Filtering by majorOS: 6, minorOS: 1, majorSP: 0, minorSP: 0, productType: 3, architecture: x64
DownloadManager Information: 0 : Loading product xml from: https://www.microsoft.com/web/webpi/3.0/enterpriseproductlist.xml
DownloadManager Information: 0 : https://www.microsoft.com/web/webpi/3.0/enterpriseproductlist.xml responded with 304
DownloadManager Information: 0 : Response headers:
HTTP/1.1 304 Not Modified
Cache-Control: max-age=900
Last-Modified: Fri, 17 Dec 2010 05:05:26 GMT
Accept-Ranges: bytes
ETag: "165844a89dcb1:0"
Server: Microsoft-IIS/7.5
VTag: 79126842300000000
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:50:32 GMT


DownloadManager Information: 0 : Remote file has not changed, using local cached file: C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\903079739.xml.temp
DownloadManager Information: 0 : Filtering by majorOS: 6, minorOS: 1, majorSP: 0, minorSP: 0, productType: 3, architecture: x64
DownloadManager Information: 0 : Getting ratings file from http://go.microsoft.com/?linkid=9752395
DownloadManager Information: 0 : http://go.microsoft.com/?linkid=9752395 responded with 302
DownloadManager Information: 0 : Response headers:
HTTP/1.1 302 Found
Cache-Control: private
Content-Length: 203
Content-Type: text/html; charset=utf-8
Expires: Sun, 16 Jan 2011 21:49:32 GMT
Location: http://www.microsoft.com/web/handlers/WebPI.ashx?command=getatomfeedwithavgratingquery
Server: Microsoft-IIS/7.5
X-AspNet-Version: 2.0.50727
Set-Cookie: MC1=GUID=bfbce5ad82846744864acd53cb5ce4cb&HASH=ade5&LV=20111&V=3; domain=microsoft.com; expires=Sun, 03-Oct-2010 07:00:00 GMT; path=/
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:50:32 GMT


DownloadManager Information: 0 : Ratings file loaded successfully
DownloadManager Information: 0 : Content-disposition header: attachment; filename="PHPMgrLogo.png"
DownloadManager Information: 0 : Adding product Visual Web Developer 2010 Express (VWD) to cart
DownloadManager Information: 0 : Product 'VWD' was already in cart.
DownloadManager Information: 0 : Adding dependency 'SQLExpress' for product 'VWD'
DownloadManager Information: 0 : Product 'SQLExpress' being added to install list
DownloadManager Information: 0 : Configuring SQL SQLExpress
DownloadManager Information: 0 : Using SQL windows authentication
DownloadManager Information: 0 : No MySQL to configure
DownloadManager Information: 0 : Setting current install to 1
DownloadManager Information: 0 : Starting install sequence
DownloadManager Information: 0 : Downloading file 'http://go.microsoft.com/fwlink/?LinkID=186784&clcid=0x0409' to: C:\Users\kenny\AppData\Local\Temp\tmpEFC.tmp
DownloadManager Information: 0 : http://go.microsoft.com/fwlink/?LinkID=186784&clcid=0x0409 responded with 302
DownloadManager Information: 0 : Response headers:
HTTP/1.1 302 Found
Cache-Control: private
Content-Length: 218
Content-Type: text/html; charset=utf-8
Expires: Sun, 16 Jan 2011 21:53:03 GMT
Location: http://download.microsoft.com/download/5/1/A/51A153F6-6B08-4F94-A7B2-BA1AD482BC75/SQLEXPR_x64_ENU.exe
Server: Microsoft-IIS/7.5
X-AspNet-Version: 2.0.50727
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:54:03 GMT


DownloadManager Information: 0 : Content-disposition header: attachment
DownloadManager Information: 0 : Moving downloaded file 'C:\Users\kenny\AppData\Local\Temp\tmpEFC.tmp' to: C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\installers\SQLExpress\2FF1A50B2277987C9CD65B99812CEAF2A67EA362\SQLEXPR_x64_ENU.exe
DownloadManager Information: 0 : Downloading file 'http://go.microsoft.com/?linkid=9732119' to: C:\Users\kenny\AppData\Local\Temp\tmp5742.tmp
DownloadManager Information: 0 : Starting EXE install for product 'SQL Server Express 2008 R2'. Commandline is: 'C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\installers\SQLExpress\2FF1A50B2277987C9CD65B99812CEAF2A67EA362\SQLEXPR_x64_ENU.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQLEXPRESS /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSVCStartupType=Automatic /AddCurrentUserAsSqlAdmin /ENABLERANU=1 /IACCEPTSQLSERVERLICENSETERMS /hideconsole '
DownloadManager Information: 0 : http://go.microsoft.com/?linkid=9732119 responded with 302
DownloadManager Information: 0 : Response headers:
HTTP/1.1 302 Found
Cache-Control: private
Content-Length: 210
Content-Type: text/html; charset=utf-8
Expires: Sun, 16 Jan 2011 21:55:33 GMT
Location: http://download.microsoft.com/download/0/D/6/0D600544-AD1A-45FB-8D40-838EBF3C03EC/vwd_web.exe
Server: Microsoft-IIS/7.5
X-AspNet-Version: 2.0.50727
Set-Cookie: MC1=GUID=cec8d63516ec4d408cc9f77759666e24&HASH=35d6&LV=20111&V=3; domain=microsoft.com; expires=Sun, 03-Oct-2010 07:00:00 GMT; path=/
X-Powered-By: ASP.NET
Date: Sun, 16 Jan 2011 21:56:32 GMT


DownloadManager Information: 0 : Waiting for process: 4428 - C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\installers\SQLExpress\2FF1A50B2277987C9CD65B99812CEAF2A67EA362\SQLEXPR_x64_ENU.exe
DownloadManager Information: 0 : Content-disposition header: attachment
DownloadManager Information: 0 : Moving downloaded file 'C:\Users\kenny\AppData\Local\Temp\tmp5742.tmp' to: C:\Users\kenny\AppData\Local\Microsoft\Web Platform Installer\installers\VWD\DD6B1454FE3F90EA126CF550AE344F8E5B831786\vwd_web.exe
DownloadManager Information: 0 : Install exit code for product 'SQL Server Express 2008 R2' is -1706970590
DownloadManager Error: 0 : Install return code for product 'SQL Server Express 2008 R2' is Failure
DownloadManager Information: 0 : Product SQL Server Express 2008 R2 done install completed
DownloadManager Information: 0 : Increasing current install to 2
DownloadManager Warning: 0 : Dependency failed for product 'Visual Web Developer 2010 Express'. Skipping install
DownloadManager Information: 0 : Product Visual Web Developer 2010 Express had a dependency fail. Increasing install product to 3

needforspeed · 17 Jan 2011 at 21:58

I got the 2 installed now. If the computer name and User Name are or was the same. The computer name has to be changed.

SQL Server Express R2

needforspeed

needforspeed

needforspeed

needforspeed

needforspeed

needforspeed