Installeren Sql Server 2016 voor Configuratiemanager.
1. Mount your “DVD” or “*.iso” with Sql installation files;
2. Run installation and go to “Installatie';
3. Select “Nieuw Sql Server stand-alone installation or add features to an existing installation';
4. Enter your “Product key” and click the “Volgende” button;
5. Read the License agreement and set the check mark “I accept the license terms“. Click the “Volgende” button;
6. If you have an Internet connection set the checkmark “Use Microsoft Update to check for updates (aanbevolen)'. Click the “Volgende” button;
7. Klik op de 'Volgende” button;
8. After the system check you may get a “Waarschuwing” message (it’s normal). Click the “Next” button;
9. Set check mark on:
- Database Engine Services;
- Full-Text and Semantic Extractions…;
- Rapportageservices – Native.
After selecting click “Volgende” button;
10. As you see there is no “SQL Management Studio”, you may install it later by downloading it from the current site.
11. Enter your instance name in “Named instance', and “Instance ID” set automatically. Click the “Volgende” button;
12. Set “Service Accounts” for our Sql services (we created them early) and set “Startup Type” to “Automatic';
13. Set “Collation”:
Sql_latin1_general_cp1_ci_as
If you set another collation – check the SCCM documentation! Klik op de 'Volgende” button;
14. In “Serverconfiguratie” select “Ramen authentification mode'. Add user “BUILTIN\Administrator” and local group “<Computer name>\Administrators” by clicking “Toevoegen” button;
15. Configure “Gegevensmappen” (path for Databases, Logs, and Backups) for your needs;
16. Configure “Tempdb” (path for temp Databases and Logs) for your needs and click the “Volgende” button;
17. 'Rapportageservicesconfiguratie” set “Alleen installeren', We configureren het later. Click the “Volgende” button;
18. Click the “Installeren” button to start installation;
19. Installation starts;
20. Installation succeeded, we can go further and make post-install configurations. Click the “Close” button to close the window;
