
Microsoft SQL Server 2017 Standard on Windows Server 2016
Works - But needs documentation
Works well - but you need some kind of documentation. I struggled to get onto the SQL server.
Login as a local admin and then login into MS SQL Manager that way. You can then go into Security\Logins and enable the sa account.
How does one login to SQL Server?
Absolutely frustrating to figure out HOW to login to SQL Server on this box. Zero instructions! Happened to come here to the comments to find out from another user
You login using the local Administrator account.
This isn't anywhere in the documentation. Spin up the AMI, Domain Join if necessary. Login to the server as the login administrator, then open up MSSQL Management Studio and login using the Windows Authentication method...Add you login accounts from there. SA is also disabled out of the box.
No documentation on SQL passwords
I guess it might work ok - but I'll never know. There is zero documentation on the default credentials for SQL 2017, making it unusable. How hard would it be to include a brief document along with this AMI? I'd have been better off installing SQL Server myself.