Hi everybody,

I try to install remotely (a remote server) SQL Server 2008 R2 by powershell script.

On the future SQL server, I copied the sources of SQL and the configurationfile.ini. 

On my other server, I wrote the following script :
Invoke-Command -ComputerName xxx -ScriptBlock{
C:\SQL2k8R2\setup.exe /ConfigurationFile="C:\SQL2k8R2\ConfigurationFile.ini}

When I launch the script, I get the following error message :
The /UIMode setting cannot be used in conjunction with /Q or /QS

My configurationfile file is writen like this :

[SQLSERVER2008]
INSTANCEID="TOTO"
ACTION="Install"
FEATURES=SQLENGINE,SSMS,ADV_SSMS
HELP="False"
INDICATEPROGRESS="True"
QUIET="True"
QUIETSIMPLE="False"
X86="False"
ENU="True"
UIMODE="AutoAdvance"
ERRORREPORTING="False"
INSTALLSHAREDDIR="PATH"
INSTALLSHAREDWOWDIR="PATH"
INSTANCEDIR="PATH"
SQMREPORTING="False"
INSTANCENAME="TOTO"
AGTSVCACCOUNT="CONTOSO\FRCSSQL"
AGTSVCSTARTUPTYPE="Manual"
ISSVCSTARTUPTYPE="Automatic"
ISSVCACCOUNT="NT AUTHORITY\NetworkService"
ASSVCSTARTUPTYPE="Automatic"
ASCOLLATION="Latin1_General_CI_AS"
ASDATADIR="Data"
ASLOGDIR="Log"
ASBACKUPDIR="Backup"
ASTEMPDIR="Temp"
ASCONFIGDIR="Config"
ASPROVIDERMSOLAP="1"
FARMADMINPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
ENABLERANU="False"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
SQLSVCACCOUNT="CONTOSO\FRCSSQL"
SQLSYSADMINACCOUNTS="CONTOSO\Administrator"
SQLBACKUPDIR="D:\Backup SQL"
SQLUSERDBDIR="D:\SQL Data"
SQLUSERDBLOGDIR="D:\SQL Logs"
SQLTEMPDBDIR="D:\SQL Data"
SQLTEMPDBLOGDIR="D:\SQL Logs"
ADDCURRENTUSERASSQLADMIN="False"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Automatic"
RSSVCSTARTUPTYPE="Automatic"
RSINSTALLMODE="FilesOnlyMode"
IAcceptSQLServerLicenseTerms="True"

Thanks for your help :-)

Hello,

Please change UIMODE to normal, as shown in the example I posted on the following link:

http://msdn.microsoft.com/en-us/library/dd239405(v=SQL.105).aspx (Community Content)

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

After changing the UIMode parameter I always get the error message :
The /UIMode setting cannot be used in conjunction with /Q or /QS

Hello,

I found the following text about the UIMODE.

The UIMode setting cannot be used with the /Q or /QS parameters.

http://msdn.microsoft.com/en-us/library/ms144259(v=sql.105).aspx  

Do not use those switches with UIMODE.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Hello,

When I put a ; in front of 
QUIET="True"
QUIETSIMPLE="False"

I get the error message :

"Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application. "

Thanks for your help :-) 

CAN you try to leave 

QUIET="True"
QUIETSIMPLE="False"

and modify

UIMODE="AutoAdvance"

to

;UIMODE="AutoAdvance"

It is blocked at line :

Launching external tool : C:\SQL2k8R2\x64\FixSqlRegistryKey_x64.exe

• Proposed as answer by grfarley Friday, January 10, 2014 10:49 PM

No idea ? 

Are you running in elevated mode(running as Administrator)

Yes ... 

Can you share/upload summary and detail log to file sharing site like skydrive, to read SQL server setup logs see

http://msdn.microsoft.com/en-us/library/ms143702(v=sql.100).aspx

Hi,

sorry for the late ...

I can't access to skydrive because it is not allowed by the security team. 

Do you have an email please ?

Thank you.

I was having a possibly similar issue. I was trying to script an install of SQL Server 2012 onto a remote computer.
I found (in my bootstrap installation logs \Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log) that I was getting an error stating "Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation.......(and the rest of your error)" I was using both the "QUITE" and "QUITEMODE" properties in the configuration file I as using for the install.
I could run the script commands from the local machine without an issue, however when I ran it from a remote machine the script would fail with that error.
All of the documentation I had found said that you should set "QUITE=FALSE" and "QUITEMODE=TRUE". But that did not turn out to be the case for my installation. 
The only property I set was the "QUITE" property and I set that to "TRUE".
Comment out the "QUITEMODE" property as well as the "UIMODE" property.
Once I had set my configuration properties to those values my install completed successfully without any issues.