July 22, 2016 at 11:23 am
I am trying to install MSSQL 2012 using power shell.
I have an ISO of MS SQL 2012 in CD rom on power Shell i am going to cd rom.
Basically i am doing an unattended installation.
I run the following command
.\setup.exe /AGTSVCPASSWORD=XXXX /SQLSVCPASSWORD=XXXX /SAPWD=XXXX /ConfigurationFile=C:\tempdir\config.ini
Setup runs for some time in as i can see in task manager but then it exits
I get the attached http://pastebin.com/HjQx6mHW SQL logs basically it is "Access is Denied".
Any clue why?
Regards
July 24, 2016 at 5:13 pm
Unless you are using a configuration file you should be careful executing the install using PowerShell. Reserved characters in PowerShell might be messing with something you are not expecting. I know for me on more than one occasion I gave up trying to run the install from PowerShell when $'s in passwords and named instances were being interpreted as PowerShell variables.
Edit: Sorry, just noticed you are using a configuration file for most of your settings. If you are using a dollar sign anywhere you might need to escape it for it to be interpreted correctly.
Joie Andrew
"Since 1982"
July 26, 2016 at 7:25 am
A few things to try:
I suggest you enclose the path to the INI file in quotes, just in case:
/ConfigurationFile="C:\tempdir\config.ini"
I add params for QuietSimple and licence agreement (these can also be set within the INI file)
/QS /IACCEPTSQLSERVERLICENSETERMS
Ensure the UI mode is commented-out:
; UIMODE="Normal"
Can also experiment with enabling/disabling
QUIET="True"
in the INI file.
Also, try starting Powershell with local administrator rights.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply