चरण-दर-चरण मार्गदर्शिका: Installing SQL Server 2017 for System Center Orchestrator 2016.
टिप्पणी: This is a LAB installation, don’t repeat it in production!
कुछ तैयारी:
- I create 2 service accounts for SQL Server (sql01svc और sql01agent) in Active Directory, add sql01svc to Administrators security group;
- Create a separate logical disk for SQL Server databases.
Installation process
- Start SQL 2017 installation;
2. पर जाए इंस्टालेशनऔर चुनेंNew SQL Server stand-alone installation…;
3. Choose edition and click अगला;
4. Read and accept license terms, क्लिक अगला;
5. In my case and don’t select Update check, एन पर क्लिक करेंविस्तार;
6. There is now Internet on this machine so the error is normal, क्लिक अगला;
7. As you may see there is now no .Net 3.5 requirement anymore, क्लिक अगला;
8. Select the feature that you need, क्लिक अगला;
9. चुनना Default instance or create Named, क्लिक अगला;
10. Enter your service accounts for services and navigate to the Collation टैब;
11. Ensure that the collation is SQL_Latin1_सामान्य_CP1_CI_AS, और क्लिक करें अगला;
12. जोड़ना SQL Server administrators and navigate to the Data Directories टैब;
13. You can change paths (like I) or leave by default, पर जाए the TempDB टैब;
14. परिवर्तन Directories or leave by default and click Nविस्तार;
15. When ready, क्लिक स्थापित करना;
16. When the installation completes, क्लिक बंद करना;
टिप्पणी: 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.