By using this site, you agree to the Privacy Policy.
Accept
EnterinITEnterinITEnterinIT
  • HOME
  • IT PRO
  • TECH
  • MICROSOFT
    • Azure
    • ConfigMgr/SCCM
    • DPM
    • Orchestrator
    • Hyper-V
    • Microsoft Edge Insider
    • MSI
    • Office 365
    • Office Insider
    • Power BI
    • Skype
    • SQL Server
    • Teams
  • WINDOWS
    • Windows Admin Center
    • Windows Client
    • Windows Server
  • SCCM Query Collection List
Reading: Step-by-Step Guide: Installing SQL Server 2017 for System Center Orchestrator 2016
Font ResizerAa
EnterinITEnterinIT
Font ResizerAa
  • HOME
  • IT PRO
  • TECH
  • MICROSOFT
  • WINDOWS
  • SCCM Query Collection List
Search
  • HOME
  • IT PRO
  • TECH
  • MICROSOFT
    • Azure
    • ConfigMgr/SCCM
    • DPM
    • Orchestrator
    • Hyper-V
    • Microsoft Edge Insider
    • MSI
    • Office 365
    • Office Insider
    • Power BI
    • Skype
    • SQL Server
    • Teams
  • WINDOWS
    • Windows Admin Center
    • Windows Client
    • Windows Server
  • SCCM Query Collection List
Orchestrator

Step-by-Step Guide: Installing SQL Server 2017 for System Center Orchestrator 2016

Published: February 11, 2024
2 Min Read
SHARE

Step-by-Step Guide: Installing SQL Server 2017 for System Center Orchestrator 2016.

NOTE: This is a LAB installation, don’t repeat it in production!

Some preparation:

  1. I create 2 service accounts for SQL Server (sql01svc and sql01agent) in Active Directory, add sql01svc to Administrators security group;
  2. Create a separate logical disk for SQL Server databases.

Installation process

  1. Start SQL 2017 installation;

2. Navigate to Installation and choose New SQL Server stand-alone installation…;

3. Choose edition and click Next;

4. Read and accept license terms, click Next;

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, click Next;

7. As you may see there is now no .Net 3.5 requirement anymore, click Next;

8. Select the feature that you need, click Next;

9. Select Default instance or create Named, click Next;

10. Enter your service accounts for services and navigate to the Collation tab;

11. Ensure that the collation is SQL_Latin1_General_CP1_CI_AS, and click Next;

12. Add SQL Server administrators and navigate to the Data Directories tab;

13. You can change paths (like I) or leave by default, navigate to the TempDB tab;

14. Change Directories or leave by default and click Next;

15. When ready, click Install;

16. When the installation completes, click Close;

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.

TAGGED:Microsoft SQL ServerSystem CenterSystem Center Orchestrator
Previous Article Skype for Business Error Move-CsUser HostedMigration fault
Next Article SQL 2017 Install Reporting Services
Leave a Comment Leave a Comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Translation

English中文(简体)DanskNederlandsFrançaisDeutschItaliano한국어PolskiPortuguêsRomânăEspañolУкраїнська
by Transposh - translation plugin for wordpress

Popular Posts

System Requirements for Windows Server 2016
Windows Server
Configuration Manager Query Collection List
Configuration Manager Query Collection List
ConfigMgr
Structured/Managed Navigation enabled on Modern Pages in Classic Team Sites
Tech
SCCM Failed to get DP locations as the expected version from MP
ConfigMgr

Recent Posts

Windows 10 Hyper-V VM Settings
Hyper-V
A Beginner’s Guide to Configuring Hyper-V on Windows 10
Hyper-V
Configuration Manager Query Collection List
SCCM Current Branch Update 1610
ConfigMgr
Configuration Manager Query Collection List
Configuration Manager Client Cache Cleanup Script
ConfigMgr

© 2023 EnterinIT

Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?