Install SQL Server 2016 for Configuration Manager.
1. Mount your “DVD” or “*.iso” with SQL installation files;
2. Run installation and go to “Installasjon";
3. Plukke ut "New SQL Server stand-alone installation or add features to an existing installation";
4. Enter your “Product key” and click the “Neste"-knappen;
5. Read the License agreement and set the check mark “I accept the license terms“. Klikk på "Neste"-knappen;
6. If you have an Internet connection set the checkmark “Use Microsoft Update to check for updates (recommended)". Klikk på "Neste"-knappen;
7. Click the "Neste"-knappen;
8. After the system check you may get a “Warning” message (det er normalt). Click the “Next” button;
9. Set check mark on:
- Databasemotortjenester;
- Full-Text and Semantic Extractions…;
- Rapporteringstjenester – Native.
After selecting click “Neste"-knappen;
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. Klikk på "Neste"-knappen;
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! Click the "Neste"-knappen;
14. i "Serverkonfigurasjon” select “Windows authentification mode". Add user “BUILTIN\Administrator” and local group “<Computer name>\Administrators” by clicking “Legg til"-knappen;
15. Configure “Datakataloger” (path for Databases, Logs, and Backups) for your needs;
16. Configure “TempDB” (path for temp Databases and Logs) for your needs and click the “Neste"-knappen;
17. "Konfigurasjon av rapporteringstjenester” set “Bare installer", vi konfigurerer det senere. Klikk på "Neste"-knappen;
18. Klikk på "Installere” 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;