Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This walkthrough uses sample names and values from a company called Contoso. Replace these with your own. For example:
- Domain controller name - corpdc
- Domain name - contoso
- MIM Service Server name - corpservice
- MIM Sync Server name - corpsync
- SQL Server name - corpsql
- Password - Replace with your own strong password
Important
MIM 2016 SP3 supports SQL AlwaysOn Availability Group (AoAG) listeners with RegisterAllProvidersIP option set to 0, meaning that SQL Server AoAG cross-subnet failover is not currently supported.
Important
SQL Transparent Data Encryption is supported by MIM Synchronization Service and MIM Service and Portal components with MIM SP3 or later builds.
Install SQL Server 2017 Standard/Enterprise Edition
Launch PowerShell as a domain administrator.
Change to the directory where the SQL Server setup program is located.
Type the following commands.
.\setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="contoso\SqlServer" /SQLSVCPASSWORD="<Replace with your own strong password>" /AGTSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="contoso\Administrator"
More info SQL deployment accounts and services can be found here
Note
SSMS is no longer included in SQL 2017. Download details can be found here