Set up an identity management server: SQL Server 2016

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 - Pass@word1

Install SQL Server 2016 Standard/Enterprise Edition

  1. Launch PowerShell as a domain administrator.

  2. Change to the directory where the SQL Server setup program is located.

  3. Type the following commands.

    .\setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="contoso\SqlServer" /SQLSVCPASSWORD="Pass@word1"   /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 2016. Download details can be found here