Guide étape par étape: Installation de SQL Server 2017 pour l'orchestrateur de centre système 2016.
NOTE: This is a LAB installation, don’t repeat it in production!
Un peu de préparation:
- Je crée 2 service accounts for SQL Server (sql01svc et sql01agent) in Active Directory, ajouter sql01svc to Administrators security group;
- Create a separate logical disk for SQL Server databases.
Installation process
- Start SQL 2017 installation;
2. Accédez à Installationand chooseNew SQL Server stand-alone installation…;
3. Choose edition and click Suivant;
4. Read and accept license terms, cliquez Suivant;
5. In my case and don’t select Update check, click Next;
6. There is now Internet on this machine so the error is normal, cliquez Suivant;
7. As you may see there is now no .Filet 3.5 requirement plus, cliquez Suivant;
8. Select the feature that you need, cliquez Suivant;
9. Sélectionner Default instance or create Named, cliquez Suivant;
10. Enter your service accounts for services and navigate to the Collation languette;
11. Ensure that the collation is SQL_Latin1_General_CP1_CI_AS, et cliquez Suivant;
12. Ajouter SQL Server administrators et accédez à the Data Directories languette;
13. You can change paths (comme je) or leave by default, se diriger vers the TempDB languette;
14. Change Répertoires or leave by default and click Next;
15. When ready, cliquez Installer;
16. When the installation completes, cliquez Fermer;
NOTE: Don’t forget to change the SQL port from dynamic to static and open it on Windows Firewall, and install SQL Management Studio on some machines.