Having a setup error installing SQL 2012 on Windows Core 2016.
Fresh install of Windows 2016 Core
Roles: File Server, IIS w/remote management & ASP.NET 4.6, .NET 3.5
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:
AGTSVCACCOUNT="NT AUTHORITY\Network Service"