Install SQL on Windows Core 2016

Having a setup error installing SQL 2012 on Windows Core 2016.

Setup:
Fresh install of Windows 2016 Core
Roles:  File Server, IIS w/remote management & ASP.NET 4.6, .NET 3.5
All updates
Create one file share to move config files to.
Create firewall rules to allow remote management to Windows Core.
This system is a standalone system not connected to a domain.

I am attempting to install MS SQL 2012 64 bit remotely with PowerShell.  I have tried with both a config file and command line options.

I can get it to install as long as I don't use the SECURITYMODE=SQL and SAPWD="SomePassword"

As soon as I use those two options it errors out and throws an error about not being able to create and XML document.

I also have set:  SQLSYSADMINACCOUNTS="Administrator"

Since you can't install SSMS on Windows Core, I have to have an SA password set for remote connectivity.

Any ideas on what am I missing about using those two options?  I have searched and not been able to come up with anything and have tried multiple times on clean installs.
Below is my config file:

[OPTIONS]
ACTION="INSTALL"
FEATURES="SQLEngine,Replication"
INSTANCENAME="MSSQLSERVER"
SECURITYMODE="SQL"
SAPWD=”SomePassword”
TCPENABLED="1"
SQLSVCACCOUNT="NT AUTHORITY\System"
SQLSYSADMINACCOUNTS="Administrator"
AGTSVCACCOUNT="NT AUTHORITY\Network Service"
AGTSVCSTARTUPTYPE="AUTOMATIC"
UPDATEENABLED="FALSE"
IACCEPTSQLSERVERLICENSETERMS="TRUE"
SQMREPORTING="FALSE"
ERRORREPORTING="FALSE"
INSTANCEDIR="C:\Data\SQLData\MSSQLServer"
SQLUSERDBDIR="C:\Data\SQLData\MSSQLServer\Databases"
SQLBACKUPDIR="C:\Data\SQLData\MSSQLServer\Backups"
SQLTEMPDBDIR="C:\Data\SQLData\MSSQLServer\TempDB"
SQLUSERDBLOGDIR="C:\Data\SQLData\MSSQLServer\Logs"
rsmith1969Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

65tdRetiredCommented:
I suspect SQL server is being installed it is not allowing  mixed mode authentication.
One could finish the install and then from a management station (PC or and GUI server} install the SSMS and then enable mixed mode and configure the SA account.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you check the install parameters before?
/SAPWD

Required when /SECURITYMODE=SQL
Specifies the password for the SQL Server SA account.

If you remove the /SECURITYMODE parameter then you can also remove the /SAPWD:
/SECURITYMODE

Optional
Specifies the security mode for SQL Server.
If this parameter is not supplied, then Windows-only authentication mode is supported.
Supported value: SQL
0
rsmith1969Author Commented:
65td.

You are correct it did install without the securitymode=sql and sapwd parameters as stated in my post.

What I didn't consider and you suggested was using a management station to access it using Windows authentication.  I was trying from my personal system which didn't have the same user for access.  Once I created a new server with Administrator as the login I was able to access it from that system with SSMS.

This would not have been an issue if I had setup a domain for the system and then any domain credentials would have worked but these practice systems were in a WORKGROUP.

Thanks
0
rsmith1969Author Commented:
Thanks for the assisstance
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.