Guia passo a passo: Installing SQL Servidor 2017 for System Center Orchestrator 2016.
OBSERVAÇÃO: This is a LAB installation, don’t repeat it in production!
Alguma preparação:
- I create 2 service accounts for SQL Servidor (sql01svc e sql01agent) em Diretório Ativo, add sql01svc to Administrators security group;
- Create a separate logical disk for SQL Server databases.
Installation process
- Começar SQL 2017 instalação;
2. Navegue até Instalaçãoe escolhaNovo SQL Server stand-alone installation…;
3. Choose edition and click Próximo;
4. Read and accept license terms, clique Próximo;
5. In my case and don’t select Update check, click Next;
6. There is now Internet on this machine so the erro is normal, clique Próximo;
7. As you may see there is now no .Net 3.5 requirement anymore, clique Próximo;
8. Select the feature that you need, clique Próximo;
9. Selecione Default instance or create Named, clique Próximo;
10. Enter your service accounts for services and navigate to the Collation aba;
11. Ensure that the collation is SQL_Latin1_General_CP1_CI_AS, e clique Próximo;
12. Adicionar SQL Server administrators e navegue até the Data Directories aba;
13. You can change paths (like I) or leave by default, navigate to the TempDB aba;
14. Mudar Directories or leave by default and click Next;
15. When ready, clique Instalar;
16. When the installation completes, clique Fechar;
OBSERVAÇÃO: Don’t forget to change the SQL port from dynamic to static and open it on Firewall do Windows, and install SQL Management Studio on some machines.
