November 5, 2012 at 7:01 am
Hi all,
So im trying to script out a silent install of SQL Express 2012 using the Configuration File.
I ran the install to create the configuration file. and changed the follow settings:
Added
; ACCEPT LICENSE
IACCEPTSQLSERVERLICENSETERMS=1
changed
; Setup will display progress only, without any user interaction.
QUIETSIMPLE="True"
from False to True
; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found.
UpdateEnabled="FALSE"
from True to False
----------------------------------------
I run the install with: sql.exe /ConfigurationFile=C:/config.INI
Where c:/config.INI is the name and file location of the config file.
When it runs, It opens the extracting part. then just finishes. nothing else happends...
Anyone point me in the right direction for what im doing wrong?
full file below:
; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will incorporate the instance ID of the SQL Server instance.
INSTANCEID="OFFLINE"
; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature.
SQMREPORTING="False"
; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature.
ERRORREPORTING="False"
; Specify the installation directory.
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
; Agent account name
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
; Auto-start service after installation.
AGTSVCSTARTUPTYPE="Disabled"
; CM brick TCP communication port
COMMFABRICPORT="0"
; How matrix will use private networks
COMMFABRICNETWORKLEVEL="0"
; How inter brick communication will be protected
COMMFABRICENCRYPTION="0"
; TCP port used by the CM brick
MATRIXCMBRICKCOMMPORT="0"
; Startup type for the SQL Server service.
SQLSVCSTARTUPTYPE="Automatic"
; Level to enable FILESTREAM feature at (0, 1, 2 or 3).
FILESTREAMLEVEL="0"
; Set to "1" to enable RANU for SQL Server Express.
ENABLERANU="False"
; Specifies a Windows collation or an SQL collation to use for the Database Engine.
SQLCOLLATION="Latin1_General_CI_AS"
; Account for SQL Server service: Domain\User or system account.
SQLSVCACCOUNT="Domain\SQL-SqlServ"
; Windows account(s) to provision as SQL Server system administrators.
SQLSYSADMINACCOUNTS="Domain\SQL-SysAdmin"
; The default is Windows Authentication. Use "SQL" for Mixed Mode Authentication.
SECURITYMODE="SQL"
; Provision current user as a Database Engine system administrator for SQL Server 2012 Express.
ADDCURRENTUSERASSQLADMIN="False"
; Specify 0 to disable or 1 to enable the TCP/IP protocol.
TCPENABLED="1"
; Specify 0 to disable or 1 to enable the Named Pipes protocol.
NPENABLED="0"
; Startup type for Browser Service.
BROWSERSVCSTARTUPTYPE="Automatic"
November 5, 2012 at 7:19 am
UPDATE!
So I commented out
; UIMODE="Normal"
and changed
IACCEPTSQLSERVERLICENSETERMS="True"
from 1 to TRUE.
Still not working.. Ive tried changing QUIET to False (and turning either QUIET on or QUIETSIMPLE is wrong) to see if it will still work but gets stuck at the license section where it wont go passed it. Ive tried both True and 1 but either work.
Im not sure if the UIMODE being commented out is a problem with trying to do a install with QUIET and QUIETSIMPLE both on False.
Still confused and rather annoyed at it all..
Seems to get so far then just stop.. :/
November 7, 2012 at 1:31 am
After some incredibly simple and effect advice from a friend.. I looked at the Install logs to find out why it was stopping!
Very simple.. coping the config file that SQL makes doesn't add any passwords to the file, they need to be manually added...
Add SA and the AD Service account for the data engine and it now installs..
The path is: \\Server\c$\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log to the logs for anyone who didnt know.
Only issue i have is that I added an AD Group for the SQLSYSADMINACCOUNTS and it hasn't been added.
Im not sure if this is because its a Group not a user and SQL wants a Password for it. I looked at the summary and it has no errors.. but its easy enough to get around as im running a script after the install to set up server defaults.
Hope this helps others.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply