Solved MSSQL server express, cant take ownership of windows/temp

[sdowney717]

I tried several things, but always get this error, so the install of MS sqlserver express fails.
One suggestion was to change ownership to the name of the person installing the sql express
I did the other changes suggested here.

https://social.technet.microsoft.co...am-filesmicrosoft-sql-server100dts-failed-the

Then this says about taking ownership here, but I will not let me take ownership of windows temp as scott

All I can do is cancel uninstall and maybe try run the install as administrator??

text output of failure

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2066808829
  Start time:                    2015-09-06 15:37:17
  End time:                      2015-09-06 16:03:20
  Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for RS:              Use the following information to resolve the error, uninstall this feature, and then run the setup process again.


Machine Properties:
  Machine name:                  SCOTTUPSTAIRSWI
  Machine processor count:       2
  OS version:                    Windows 7
  OS service pack:               Service Pack 1
  OS region:                     United States
  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  Configured
  SQL Server 2014      SQLEXPRESS           MSSQL12.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014      SQLEXPRESS           MSSQL12.SQLEXPRESS             SQL Server Replication                   1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014      SQLEXPRESS           MSSQL12.SQLEXPRESS             Full-Text and Semantic Extractions for Search 1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014      SQLEXPRESS           MSRS12.SQLEXPRESS              Reporting Services - Native              1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Management Tools - Basic                 1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Management Tools - Complete              1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Client Tools Connectivity                1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Client Tools Backwards Compatibility     1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Client Tools SDK                         1033                 Express Edition      12.0.2000.8     No         Yes       

Package properties:
  Description:                   Microsoft SQL Server 2014 
  ProductName:                   SQL Server 2014
  Type:                          RTM
  Version:                       12
  SPLevel:                       0
  Installation location:         C:\Users\scott\Downloads\SQLEXPRADV_x64_ENU\x64\setup\
  Installation edition:          Express

Product Update Status:
  None discovered.

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
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSERVERMODE:                  MULTIDIMENSIONAL
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 <empty>
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CLTCTLRNAME:                   <empty>
  CLTRESULTDIR:                  <empty>
  CLTSTARTUPTYPE:                0
  CLTSVCACCOUNT:                 <empty>
  CLTSVCPASSWORD:                <empty>
  CLTWORKINGDIR:                 <empty>
  COMMFABRICENCRYPTION:          0
  COMMFABRICNETWORKLEVEL:        0
  COMMFABRICPORT:                0
  CONFIGURATIONFILE:             
  CTLRSTARTUPTYPE:               0
  CTLRSVCACCOUNT:                <empty>
  CTLRSVCPASSWORD:               <empty>
  CTLRUSERS:                     <empty>
  ENABLERANU:                    true
  ENU:                           true
  ERRORREPORTING:                true
  FEATURES:                      SQLENGINE, REPLICATION, FULLTEXT, RS, LOCALDB
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher
  FTSVCPASSWORD:                 <empty>
  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:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\Network Service
  ISSVCPASSWORD:                 <empty>
  ISSVCSTARTUPTYPE:              Automatic
  MATRIXCMBRICKCOMMPORT:         0
  MATRIXCMSERVERNAME:            <empty>
  MATRIXNAME:                    <empty>
  NPENABLED:                     0
  PID:                           *****
  QUIET:                         false
  QUIETSIMPLE:                   false
  ROLE:                          AllFeatures_WithDefaults
  RSINSTALLMODE:                 DefaultNativeMode
  RSSHPINSTALLMODE:              DefaultSharePointMode
  RSSVCACCOUNT:                  NT Service\ReportServer
  RSSVCPASSWORD:                 <empty>
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  SQL
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCPASSWORD:                <empty>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           SCOTTUPSTAIRSWI\scott
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBLOGDIR:               <empty>
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  true
  TCPENABLED:                    0
  UIMODE:                        AutoAdvance
  UpdateEnabled:                 true
  UpdateSource:                  MU
  USEMICROSOFTUPDATE:            false
  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20150906_153715\ConfigurationFile.ini

Detailed results:
  Feature:                       Reporting Services - Native
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred during the setup process of the feature.
  Next Step:                     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
  Component name:                SQL Server Reporting Services
  Component error code:          0x84CF0003
  Error description:             Updating permission setting for folder 'C:\Windows\Temp' failed. The folder permission setting were supposed to be set to 'D:(A;OICI;0x1200af;;;S-1-5-80-2885764129-887777008-271615777-1616004480-2722851051)'.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=0x0ADF5303%400xBB814387&EvtType=0x0ADF5303%400xBB814387

  Feature:                       Database Engine Services
  Status:                        Passed

  Feature:                       Full-Text and Semantic Extractions for Search
  Status:                        Passed

  Feature:                       SQL Server Replication
  Status:                        Passed

  Feature:                       LocalDB
  Status:                        Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20150906_153715\SystemConfigurationCheck_Report.htm

 

[sdowney717]

Also I had over 7gb free space before I attempted to install this twice, I have uninstalled the failed 226mb instance, and now I have only 4gb free space. So is it sucking up invisible space?
And this has taken hours of my time.

It seems to me on every failed server instance install attempt, whatever files it makes are being left behind even though I go to uninstall a program and remover the MS server express. So my hard drive is filling up. Pretty soon I will be out of space.

Then I will be asking how to delete failed server instances.

Looking at space in the middle of this third install attempt, I am now under 3gb free.

I think this is how it is done
https://social.msdn.microsoft.com/F...-by-a-later-version-?forum=sqlsetupandupgrade

Edit, update, this third install also failed even running installer as administrator.

 

[sdowney717]

ok, uninstall does ot remove any instances of sqlserver 2104, as the web site mentions, it just uninstalls it and closes.
I have 3 instances which are broke sitting on the drive. And no clue how to get rid of them.

Ok, ran disk analyzer in Ubuntu, and it showed 7 gb of Mysqlserver instances in program data folder-MysqlServer, maybe they were hidden in windows explorer. So I freed over 7gb, so back to square one.

My feeling is I wont be able to install it. MySQL installs and runs dandy. I can run MSDE 2000 in an xp virtual machine to test my app. I have a database app that uses either MySQL or SQLServer.

MS says this is how to resolve, which I did, and still not working. And I can not take ownership windows/temp directory which some says fixed this issue.
https://support.microsoft.com/en-us/kb/2000257

 

[sdowney717]

solved, Avast! had prevented the install.
So I uninstalled everything to do with sqlsserver from control panel, maybe 15 items.
Then reinstalled and it ok.

 

[sdowney717]

I could net get in config manager, so I had to repair the sqlserver instance MSSQLSERVER4, from the installer I left open.
https://social.msdn.microsoft.com/F...d-by-microsoft-manager-console?forum=sqltools

They do not make this easy. Even though it was just installed, it was broken until I selected to repair it.

 

[sdowney717]

HaHa, total success for me!
I was able to login to my program I designed, create the database, and now it shows up in the config manager.
I use Myql, I wanted to rexamine sqlserver 2014 to see if it still works, and it does. I had originally programmed this for MSDE 2000.

A couple things, the server name is 'the name of the computer \ the name of the sql server instance'
Then when creating a database, the name of it has to be stored where the instance has it's stored databases, in my case that shows in the directory here in this attached pic.

Database name is TESTME.
I made this program years ago, and it still works for MS Sqlserver. I have recently made a lot of changes, so since between MS and MySQL exist sql command structure differences, I need to test them to be sure it all works.