Guida passo passo: Installing SQL Server 2017 for System Center Orchestrator 2016.
NOTA: This is a LAB installation, don’t repeat it in production!
Un po' di preparazione:
- I create 2 service accounts for SQL Server (sql01svc E sql01agent) in Active Directory, aggiungere sql01svc to Administrators security group;
- Create a separate logical disk for SQL Server databases.
Installation process
- Start SQL 2017 installazione;
2. Navigate to Installazioneand chooseNew SQL Server stand-alone installation…;
3. Choose edition and click Prossimo;
4. Read and accept license terms, clic Prossimo;
5. In my case and don’t select Update check, Fare clic su next;
6. There is now Internet on this machine so the error is normal, clic Prossimo;
7. As you may see there is now no .Net 3.5 requirement più, clic Prossimo;
8. Select the feature that you need, clic Prossimo;
9. Selezionare Default instance or create Named, clic Prossimo;
10. Enter your service accounts for services and navigate to the Collation scheda;
11. Ensure that the collation is SQL_Latin1_General_CP1_CI_AS, e fare clic Prossimo;
12. Aggiungere SQL Server administrators e navigare verso the Data Directories scheda;
13. You can change paths (like I) or leave by default, navigate to the TempDB scheda;
14. Modifica Directories or leave by default and click Next;
15. When ready, clic Installare;
16. When the installation completes, clic Vicino;
NOTA: 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.
