No edit summary |
No edit summary |
||
Line 50: | Line 50: | ||
### Microsoft OLE DB Driver - There is a link provided in the second column. | ### Microsoft OLE DB Driver - There is a link provided in the second column. | ||
### Click Next once finished installing prerequisites. | ### Click Next once finished installing prerequisites. | ||
## On the Configure the Service Manager Database screen, | ## On the Configure the Service Manager Database screen, enter the server name and instance name. For me, this was SAD-SCSM01\MSSQLSERVER. Ensure you create a new database. You can leave everything else default. |
Revision as of 23:28, 24 May 2024
History
System Center Service Manager:System Center Service Manager provides an integrated platform for automating and adapting your organization's IT service management best practices, such as those found in Microsoft Operations Framework (MOF) and Information Technology Infrastructure Library (ITIL). It provides built-in processes for incident and problem resolution, change control, and asset lifecycle management. Official documentation can be found here.
This service was setup to enable internal sysadminafterdark operations staff to receive tickets from devices and track internal change management requests. This enables us to have one central console for everything alert related so we can easily prioritize and track our time.
Deployment
It is recommended to snapshot often when deploying Microsoft System Center Products. To deploy Service Manager, follow these steps:
- Begin with a clean install of Windows Server 2022 Desktop Edition. You can find specific VM requirements for this server at Servers:SAD-SCSM01.
- A total of five virtual disks are needed for a proper installation:
- 128GB OS Disk - For Windows Server 2022.
- 256GB Program Data Disk - For Database: Microsoft SQL Server 2022 and System Center Service Manager:System Center Service Manager program files.
- 256GB Database Disk - To store database files.
- 256GB Logs Disk - To store SQL log files.
- 64GB TempDB Disk - To store SQL TempDB files.
- A total of five virtual disks are needed for a proper installation:
- Install Microsoft SQL Server 2022.
- Mount the Microsoft SQL 2022 ISO and run setup.exe.
- Click "Installation" on the sidebar then click "New SQL Server standalone installation or add features to an existing installation".
- On the Edition screen, enter your product license key.
- On the License Terms screen, Accept the license terms.
- No action needed for section Global Rules.
- Choose whether or not to use Windows Update on the Microsoft Update tab. I choose not to.
- Click Next on the Install Rules tab.
- Note: I received a warning about Windows Firewall, there's no need to worry about this.
- Perform the following actions on the Feature Selection screen:
- Check "Database Engine Services" and "Full-Text and Semantic Extractions for Search"
- Change the "Instance root directory", "Shared feature directory", and "Shared feature directory (x86)" drive letter to your Program Files disk. In my case, this is drive D. Leave the rest of the path untouched.
- On the Instance Configuration screen, the defaults are fine. Click Next.
- Perform the following steps on the Server Configuration page:
- Open Active Directory Users and Groups and create a service account for SQL to run under. I am using Users and Groups:svc_scsmsql.
- Change the Account name for both services and input the password. Make sure this account is documented. SQL Server Browser cannot be modified.
- Set the Startup Type to Automatic.
- On the Collation Page, the default of SQL_Latin1_General_CP1_CL_AS is fine, just note you will not be able to change the language without reinstalling SQL. I only speak English.
- Click Next.
- On the Database Engine Configuration section, perform the following tasks:
- On the Server Configuration Tab: The default of "Windows Authentication Mode is fine. Add Domain Users and your SQL Service account Users and Groups:svc_scsmsql to the SQL Server Administrators box.
- On the Data Directories tab: set "Data Root Directory" to your database drive. In my case that would be E:\Database. The other data directories should change to reflect this new path. Do not change those paths! Change the "User database log directory" to your Logs drive. In my case it would be F:\Logs\SQL. The Backup Directory is fine. Mine defaulted to E:\Database\MSSQL16.MSSQLSERVER\MSSQL\Backup.
- On the TempDB Tab: Remove the default data directory and specify your TempDB drive. In my case, it is G:\TempDB. Change the Log Directory to your logs drive. I choose to use path F:\Logs\TempDB.
- On the Memory tab: Click "Recommended" then accept the recommended configuration.
- All other tabs can be left at default values. Click Next.
- On the Ready to Install Screen, Click Install.
- Configure SQL Post-install by launching "SQL Server Configuration Manager" from the Start Menu.
- Expand "SQL Server Network Configuration" then click "Protocols for MSSQLSERVER" Enable "Shared Memory", "Named Pipes" and "TCP/IP".
- Install Microsoft System Center Service Manager 2022
- Mount the ISO and run setup.exe.
- On the Product Registration screen, enter the name of your organization (for both fields), your product key, and agree to the License Terms. Click Next.
- We will need to install some prerequisites as defined by the Prerequisites screen. I had to install the following:
- Microsoft .Net 3.5 - Install from Windows Server Manager
- Microsoft OLE DB Driver - There is a link provided in the second column.
- Click Next once finished installing prerequisites.
- On the Configure the Service Manager Database screen, enter the server name and instance name. For me, this was SAD-SCSM01\MSSQLSERVER. Ensure you create a new database. You can leave everything else default.