Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Install SQL 2008 silent without Administrator previleges

Answered Install SQL 2008 silent without Administrator previleges

  • Friday, November 23, 2012 1:44 PM
     
      Has Code
    Sign In to Vote
    0

    Hi,

    I'm trying to install SQL 2008 R2 remotely without the Administrator (via cygwin)

    The user root is in the administrator group, however the install throws all sorts of errors at execution

    setup.exe /CONFIGURATIONFILE=configurationfile.ini

    Error

    Running Action: MsiTimingAction
----------------------------------------------------------------------
Running Action: Install_WatsonX64_Cpu64_Action
Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 
Sco: Attempting to open registry subkey 
Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
Target package: "C:\sql\x64\redist\watson\dw20sharedamd64.msi"
InstallPackage: MsiInstallProduct returned the result code 1622.
Watson Bucket 1 
 Original Parameter Values 

Parameter 0 : 10.50.1600.1 

Parameter 2 : dw20sharedamd64.msi 

Parameter 3 : 0x162A16FE 

Parameter 4 : 0x1622 

Parameter 5 : Install_WatsonX64 


 Final Parameter Values 

Parameter 0 : 10.50.1600.1 

Parameter 2 : dw20sharedamd64.msi 

Parameter 3 : 0x162A16FE 

Parameter 4 : 0x1622 

Parameter 5 : Install_WatsonX64 

Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121123_133628\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_


    Any ideas how I can get around this?

    http://www.newquayfood.co.uk


    • Edited by sercan1 Friday, November 23, 2012 1:45 PM
    •  
     

All Replies

  • Friday, November 23, 2012 2:03 PM
    Moderator
     
     
    Sign In to Vote
    1

    Hello,

    Administrative permissions/rights are required to install SQL Server on a computer.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Friday, November 23, 2012 2:47 PM
     
     
    Sign In to Vote
    0
    No way around or hack? Looking to deploy SQL over the network but root (administrator group member)

    http://www.newquayfood.co.uk

     
  • Friday, November 23, 2012 3:00 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Without administrative permissions it won’t be possible to install SQL Server, to my knowledge.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Friday, November 23, 2012 3:53 PM
     
     
    Sign In to Vote
    0
    But the user is in Administrators group!

    http://www.newquayfood.co.uk

     
  • Friday, November 23, 2012 4:09 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    I found error 1622 is related to “Error opening installation log file. Verify that the specified log file location exists and is writable”.

    I guess that C:\sql directory does not exist on remote machines.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Friday, November 23, 2012 4:30 PM
     
     
    Sign In to Vote
    0
    C:\sql is the directory is where I extracted the SQL ISO

    http://www.newquayfood.co.uk

     
  • Friday, November 23, 2012 4:37 PM
     
     Proposed
    Sign In to Vote
    1
    Administrative privileges are required for SQL Server 2008 scilent install.

    Regards,

    Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

    http://basitaalishan.com

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Proposed As Answer by Basit Farooq Friday, November 23, 2012 4:37 PM
    •  
     
  • Friday, November 23, 2012 5:20 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,


    Does it exist on the remote machine or it exist on your machine only?

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

     
  • Saturday, November 24, 2012 1:16 PM
     
     
    Sign In to Vote
    0
    Does what exist on the remote machine?

    http://www.newquayfood.co.uk

     
  • Saturday, November 24, 2012 8:01 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Does the c:\sql directory exist on every remote computer where you are running SQL Setup with that configuration file?

    Create that directory on every computer.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Monday, November 26, 2012 12:35 PM
     
     
    Sign In to Vote
    0

    c:\sql exists on the server where the configuration file exists .

    No worries...another Microsoft balls up...forcing everything to be ran by 'Administrator'!

    http://www.newquayfood.co.uk

     
  • Monday, November 26, 2012 1:13 PM
    Moderator
     
     Proposed
    Sign In to Vote
    1

    Hello,

    Yes, it requires administrative privileges to install SQL Server.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Saturday, December 01, 2012 12:34 PM
     
     Answered
    Sign In to Vote
    0
    http://www.poweradmin.com/PAExec/ is what I need

    http://www.newquayfood.co.uk

    • Marked As Answer by sercan1 Saturday, December 01, 2012 12:34 PM
    •