Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: MSSQL server express, cant take ownership of windows/temp

06 Sep 2015   #1
sdowney717

Windows 7 Ultimate x64
 
 
MSSQL server express, cant take ownership of windows/temp

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.com...dts-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
Code:
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





Attached Thumbnails
MSSQL server express, cant take ownership of windows/temp-sqlfail.png  
Attached Images
MSSQL server express, cant take ownership of windows/temp-ownership.png 
My System SpecsSystem Spec
.
06 Sep 2015   #2
sdowney717

Windows 7 Ultimate x64
 
 

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/Fo...etupandupgrade

Edit, update, this third install also failed even running installer as administrator.
My System SpecsSystem Spec
06 Sep 2015   #3
sdowney717

Windows 7 Ultimate x64
 
 

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


Attached Thumbnails
MSSQL server express, cant take ownership of windows/temp-failsqlinstances.png  
My System SpecsSystem Spec
.

07 Sep 2015   #4
sdowney717

Windows 7 Ultimate x64
 
 

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.


Attached Thumbnails
MSSQL server express, cant take ownership of windows/temp-sqlsuccess.png  
My System SpecsSystem Spec
07 Sep 2015   #5
sdowney717

Windows 7 Ultimate x64
 
 

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/Fo...forum=sqltools

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


Attached Thumbnails
MSSQL server express, cant take ownership of windows/temp-sqlserver7.png   MSSQL server express, cant take ownership of windows/temp-sqlserver8.png  
My System SpecsSystem Spec
07 Sep 2015   #6
sdowney717

Windows 7 Ultimate x64
 
 

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.


Attached Thumbnails
MSSQL server express, cant take ownership of windows/temp-sqlserversuccessbookstoreprogramtableshows.png   MSSQL server express, cant take ownership of windows/temp-sqlserver9.png  
My System SpecsSystem Spec
Reply

 MSSQL server express, cant take ownership of windows/temp




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Unable to Take Ownership of Folder in Windows Server 2008R2
Hi. I'm trying to delete a folder with one file in it. No matter what I try, it tells me, the domain admin, that access is denied. It won't let me take ownership. :mad: Is there a way to get around this and get this Autodesk POS off my server? Attached is a screenshot of the denial. ...
Network & Sharing
SQL SERVER EXPRESS 2008 will not allow New Database
I have installed SQL EXPRESS Management Tools but I cannot get it to do anything. If I try to create a new database, I just get an error saying "Access to the database file is not allowed". Also the object browser screen ( on the left ) is completely empty. I have no existing files to...
Software
Remote Access to SQL Server Express 2008 Windows 7
Hello, I have installed SQL Server Express 2008 on my desktop and am attempting to connect to it from my lap top. I have enabled remote connections for SQL Server and opened up a port on my desktop. When I attempt to connect to the server instance from my laptop via ipaddress\sqlserver with...
System Security
Sql server express 2005
Okay this is driving me batty and any help y'all could offer would be most appreciated!! I have an old (2002-era) proprietary program I use for work that ran FINE on 32-bit XP without any special tweaking. It also runs fine on 32-bit W7 on my laptop. I couldn't get it to install normally in...
Software
SQL Server Express 2008 - Can't uninstall/repair
Hey I installed SQL Server Express 2008. It gave some error messages during installation that I passed by (oops!) I'm trying to uninstall but get the following error message: TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following...
Software
SQL server 2008 express
Hello, Hum. I've got a question. I want install SQL server 2008 + SQL management express 2008 to my Computer. If I'm trying that, it says me somewhat with Service pack. Can someone help me? Here some screens: http://img5.imagebanana.com/img/ezhyy9ga/screen.png...
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 21:55.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App