Guía paso a paso: Installing SQL Server 2017 for System Center Orchestrator 2016.
NOTA: This is a LAB installation, don’t repeat it in production!
Un poco de preparación:
- Yo creo 2 service accounts for SQL Server (sql01svc y sql01agent) in Active Directory, agregar sql01svc to Administrators security group;
- Create a separate logical disk for SQL Server databases.
Installation process
- Start SQL 2017 instalación;
2. Navegar a Instalacióny elegirNew SQL Server stand-alone installation…;
3. Choose edition and click Próximo;
4. Leer y aceptar los términos de la licencia, hacer clic Próximo;
5. In my case and don’t select Update check, Haga clic en Nextendido;
6. There is now Internet on this machine so the error is normal, hacer clic Próximo;
7. As you may see there is now no .Net 3.5 requirement ya no, hacer clic Próximo;
8. Select the feature that you need, hacer clic Próximo;
9. Seleccionar Default instance or create Named, hacer clic Próximo;
10. Enter your service accounts for services and navigate to the Collation pestaña;
11. Ensure that the collation is Sql_latin1_general_cp1_ci_as, y haga clic Próximo;
12. Agregar SQL Server administrators y navegar a the Data Directories pestaña;
13. You can change paths (like I) or leave by default, navigate to the TempDB pestaña;
14. Cambiar Directories or leave by default and click Nextendido;
15. When ready, hacer clic Instalar;
16. When the installation completes, hacer clic Cerca;
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.
