System Center Service Manager için sistem gereksinimleri

Bu makalede System Center 2022 - Service Manager (SM) için sistem gereksinimleri ayrıntılı olarak açıklanır.

Not

Önceki sürümlerden farklı olarak, SM 2022 için önkoşul olarakSQL Server 2014 içinRapor Görüntüleyicisi araçları / Microsoft CLR Türlerini el ile yüklemeniz gerekmez.

System Center 2022 - Service Manager için sistem gereksinimleri

Aşağıdaki bölümlerde SM 2022 için genel performans ve ölçeklenebilirlik kılavuzu açıklanır ve çeşitli iş yükleri için donanım yapılandırmaları önerilir. System Center 2022 esnek ve ölçeklenebilir olacak şekilde oluşturulduğundan, belirli senaryoların donanım gereksinimleri burada sunulan yönergelerden farklı olabilir.

Service Manager için kapasite sınırları

Service Manager test edilen kapasite sınırları hakkında bilgi edinmek için Dağıtım senaryoları için yapılandırmalar bölümünü okuyun.

Desteklenen birlikte kullanım

Yükseltmeleri basitleştirmeye yardımcı olmak için Service Manager 2022 bağlayıcılarını aşağıdaki System Center bileşenleriyle kullanabilirsiniz.

• System Center 2019/2022 Virtual Machine manager
• System Center 2019/2022 Orchestrator
• System Center 2019/2022 Operations Manager
• System Center 2019/2022 Configuration Manager (yalnızca geçiş senaryosu sırasında)
• System Center Configuration Manager CB sürümleri
  • 1511, 1602, 1606, 1710, 1802, 1806 - 2103, 2107

Donanım

Sunucular	İşlemci (min.)	İşlemci (ön.)	RAM (min.)	RAM (ön.)	Sabit disk alanı (min.)	Sabit disk alanı (ön.)
Service Manager Yönetim Sunucusu	4 Çekirdek 2,66 GHz CPU	4 Çekirdek 2,66 GHz CPU	8 GB	8 GB	10 GB	10 GB
Service Manager Veritabanı	8 Çekirdek 2,66 GHz CPU	8 Çekirdek 2,66 GHz CPU	8 GB	32 GB	80 GB	80 GB
Data Warehouse Management Server'Service Manager	4 Çekirdek 2,66 GHz CPU	4 Çekirdek 2,66 GHz CPU	8 GB	16 GB	10 GB	10 GB
Data Warehouse Veritabanlarını Service Manager	8 Çekirdek 2,66 GHz CPU	8 Çekirdek 2,66 GHz CPU	8 GB	32 GB	400 GB	400 GB
Service Manager Konsolu	2 Çekirdek 2 GHz CPU	2 Çekirdek 2 GHz CPU	4 GB	4 GB	10 GB	10 GB
Service Manager Self Servis Portalı (tek başına)	4 Çekirdek 2,66 GHz CPU	8 Çekirdek 2,66 GHz CPU	8 GB	16 GB	80 GB	80 GB
Service Manager Self Servis Portalı + İkincil Yönetim Sunucusu (Önerilen)	8 Çekirdek 2,66 GHz CPU	8 Çekirdek 2,66 GHz CPU	16 GB	32 GB	80 GB	80 GB

Yazılım gereksinimleri

Bileşen	Gereksinim
Service Manager yönetim sunucusu	Yönetim sunucusunun gereksinimleri: Windows Server için .NET Framework 3.5 SP1 için ADO.NET Data Services Güncelleştirmesi; yerel istemci SQL Server Yönetim sunucusu Windows'un 64 bit sürümüne yüklenmelidir.
Veri ambarı yönetim sunucusu	Ambar yönetim sunucusu şunları gerektirir: SQL Server Yerel istemci Veri ambarı yönetim sunucusu Windows'un 64 bit sürümüne yüklenmelidir.
Service Manager/veri ambarı veritabanları	Service Manager veya veri ambarı veritabanları şunları gerektirir: SQL Server Reporting Services (SSRS); Çözümleme Yönetim Nesnelerini SQL Server. SQL Server ve Analysis Services harmanlama ayarları, Service Manager veritabanını, veri ambarı veritabanını, Analysis Services veritabanını ve Reporting Services veritabanını barındıran bilgisayarlar için aynı olmalıdır.
Service Manager konsolu	Konsolun gerektirdiği: Konsol bilgisayarında OLAP veri küplerini görüntülemek için Microsoft Excel; Windows Server için .NET Framework 3.5 SP1 için ADO.NET Data Services Güncelleştirmesi; Çözümleme Yönetim Nesnelerini SQL Server. Konsol, Windows'un 64 bit sürümüne yüklenebilir.
Self Servis portalı	Self-Service Portal sunucusu şunları gerektirir: Windows 2016 sunucusu veya üzeri; IIS rolü ve ASP.NET 4.5 etkin; Çözümleme Yönetim Nesnelerini SQL Server. Sunucu makinesini Service Manager SDK Hizmeti’nin çalıştığı etki alanına ekleyin. İdeal olarak, birincil veya ikincil sunucuya eklemeniz önerilir.
Self servis kullanan makineler	Self-Service Portal için 1024 X 768 üzerinde bir ekran çözünürlüğü gerekir. Desteklenen tarayıcılar: Microsoft Edge; Microsoft Internet Explorer 10 ve 11; Mozilla Firefox 42 ve üzeri; Google Chrome 46 ve üzeri.
SQL Server Reporting Services	SSRS'yi barındıran bilgisayarın veri ambarı yönetim sunucusunu barındıran bilgisayarda olmadığı bir dağıtım topolojisinde, genel derleme önbelleğine Microsoft.EnterpriseManagement.Reporting.Code eklemeniz gerekir. El ile uygulanan adımlar hakkında bilgi edinin.

Ek notlar

• Operations Manager - Service Manager bir Operations Manager ortamından uyarıları ve yapılandırma öğelerini içeri aktarma özelliğine sahiptir. Hem Service Manager hem de Operations Manager'ı aynı ortama yükleme hakkında bilgi edinin. Operations Manager için bir veri reyonu oluşturabilirsiniz.

• Configuration Manager - Service Manager Configuration Manager bir ortamdan yapılandırma öğelerini içeri aktarabilir.

• Ağ gereksinimleri - Bilgi bankası makalelerinden dış içeriği görüntülemek için, Service Manager konsolunu barındıran bilgisayarların doğrudan veya ara sunucu üzerinden İnternet erişimi olmalıdır.

• SMTP sunucusu- Bildirim özelliğini kullanmak ve e-posta yoluyla olay oluşturmak için Basit Posta Aktarım Protokolü (SMTP) sunucusuna erişiminiz olmalıdır.

• Windows güvenli modu- Service Manager çalışmaz ve Windows Server güvenli modda çalışıyorsa Service Manager tarafından kullanılan hizmetler başlatılmaz. güvenli moddayken Service Manager hizmetlerini el ile başlatmayı denerseniz, hizmetler başlatılamaz ve olay günlüğüne bir hata yazılır.

SQL Server gereksinimleri

Microsoft SQL Server, System Center - Service Manager tarafından oluşturulan veritabanlarını barındırmaktadır. Ayrıca, System Center 2022 - Service Manager için Microsoft Online Analytical Processing (OLAP) küpleriyle çalışmak için SQL Server Analysis Services (SSAS) gerekir. System Center 2022 - Service Manager raporlamasını desteklemek için SQL Server Reporting Services (SSRS) gereklidir.

SQL Server ortamınızın System Center 2022 yüklemesini veya yükseltmesini desteklemeye hazır olup olmadığını değerlendirmek için bu bilgileri kullanın. System Center'ın bir veya birden çok bileşenini dağıtırken bu bilgileri kullanın.

Not

Yükleme sırasında, Service Manager ve veri ambarı veritabanlarını barındıracak SQL Server çalıştıran bilgisayarlarda tam metin araması SQL Server seçin.

SQL Server sürüm desteği

Not

• SM, SSAS modu Tablolu'yu desteklemez. SQL Server yüklemesi sırasında SSAS modunu Çok boyutlu olarak seçin.
• Desteklenen SQL sürümleri için, şu anda Microsoft tarafından desteklenen hizmet paketlerini kullanın.
• Service Manager 2022, CU8 veya üzeri ile SQL 2019'ı destekler; ancak SQL 2019 RTM'yi desteklemez.
• SQL 2019 (CU8 veya üzeri) ile ODBC 17.3 - 17.10.4.1 ve MSOLEDBSQL 18.2 - 18.6.6 kullanın.

Service Manager	SQL Server 2017	Toplu Güncelleştirme 8 ile SQL Server 2019
Service Manager/Data Warehouse veritabanı	•	•

Not

System Center 2022 - Service Manager MultiSubnetFailover parametresini desteklemez. Bu parametre System Center 2022 - Service Manager bağlantı dizelerinde kullanılmaz.

Güncelleştirmelere izin ver

System Center 2022 - Service Manager yüklemek veya yükseltmek için, konak veritabanlarını SQL Server çalıştıran bilgisayarların güncelleştirmelere izin verecek şekilde yapılandırılması gerekir. Güncelleştirmelere izin verilmiyorsa, System Center 2022 - Service Manager Kurulumu tamamlanmaz ve yüklemenin Veritabanı oluşturma aşamasında aşağıdaki hata iletisi görüntülenir:

Müşteri eylemi yürütülürken bir hata oluştu: _ExecuteSqlScripts. Bu yükseltme denemesi, kalıcı değişiklikler yapılmadan önce başarısız oldu. Yükseltme işlemi, sistemin orijinal durumuna başarıyla geri alındı. Düzeltmeler yapıldıktan sonra bu rol için yükseltmeyi yeniden deneyebilirsiniz.

SQL Server'da allow updates durumunu, SQL Server Management Studio içinden aşağıdaki depolanan yordamı yürüterek denetleyebilirsiniz:

sp_configure 'allow updates'

Sonuçlar tablosunda run_value değerini inceleyin. Çalıştırma değerinin değeri 1 ise, aşağıdaki saklı yordamla değeri 0 olarak ayarlayın ve kurulum'u yeniden çalıştırın.

sp_configure 'allow updates',0 reconfigure with override

Service Manager veritabanları için AlwaysOn Kullanılabilirlik Grupları ile ilgili dikkat edilmesi gerekenler

SQL Server AlwaysOn Kullanılabilirlik Grupları işlevselliği System Center 2022 - Service Manager tarafından desteklenir.

AlwaysOn kullanılabilirlik gruplarıyla Service Manager yükleme hakkında daha fazla bilgi için buraya bakın.

SQL 2017'ye yükseltme

Aşağıdaki adımlar SQL 2017'ye yükseltme hakkında bilgi sağlar.

Not

SQL 2017'ye yükseltme işlemi raporlama hizmetlerini kaldırır; yedekleme raporlama veritabanı ve şifreleme anahtarları gibi gerekli raporları geçirmeyi unutmayın.

SQL 2016'dan 2017'ye yükseltmek için aşağıdaki adımları kullanın:

1. SQL 2017'ye yükseltin.
2. SQL 2017 raporlama hizmetlerini (SSRS) yükleyin, mevcut raporlama veritabanını kullanmak için raporlama hizmetleri yapılandırma yöneticisini başlatın ve şifreleme anahtarlarını geri yükleyin. Web hizmeti URL'sini ve Web portalı URL'sini yapılandırın.
3. SQL 2017 için yükseltme işlemini başlatmadan önce sahip olduğunuz raporlama sunucusu Web hizmeti sanal dizini ve Web portalı URL'si için aynı değerleri kullanın.
4. SSRS'yi burada paylaşılan ayrıntılara göre yapılandırın.
5. [İsteğe bağlı] CLR sıkı güvenliğini etkinleştirmek için Service Manager veritabanlarının her birinde aşağıdaki betiği çalıştırın. Varsayılan olarak, SQL 2017'ye yükseltildikten sonra CLR sıkı güvenliği devre dışı bırakılır.

SQL 2019'a yükseltme

Aşağıdaki adımlar SQL 2019'a yükseltme hakkında bilgi sağlar.

Not

• SQL 2019 ile Toplu Güncelleştirme 8 (CU8) veya üzerini kullanmanız gerekir.
• ODBC 17.3 - 17.10.4.1 ve MSOLEDBSQL 18.2 - 18.6.6 kullanın.
• SQL 2019'a yükseltme işlemi raporlama hizmetlerini kaldırır; yedekleme raporlama veritabanı ve şifreleme anahtarları gibi gerekli raporları geçirmeyi unutmayın.

SQL 2017'den 2019'a yükseltmek için aşağıdaki adımları kullanın:

1. SQL 2019'a yükseltin.
2. SQL 2019 raporlama hizmetlerini (SSRS) yükleyin, mevcut raporlama veritabanını kullanmak için raporlama hizmetleri yapılandırma yöneticisini başlatın ve şifreleme anahtarlarını geri yükleyin. Web hizmeti URL'sini ve Web portalı URL'sini yapılandırın.
3. SQL 2019 için yükseltme işlemini başlatmadan önce sahip olduğunuz raporlama sunucusu Web hizmeti sanal dizini ve Web portalı URL'si için aynı değerleri kullanın.
4. SSRS'yi burada paylaşılan ayrıntılara göre yapılandırın.
5. [İsteğe bağlı] CLR sıkı güvenliğini etkinleştirmek için Service Manager veritabanlarının her birinde aşağıdaki betiği çalıştırın. Varsayılan olarak, SQL 2019'a yükseltildikten sonra CLR sıkı güvenliği devre dışı bırakılır.

CLR sıkı güvenliğini etkinleştirme

İsteğe bağlı. CLR sıkı güvenliğini etkinleştirmek için aşağıdaki betiği kullanın.

-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash1 BINARY(64), @ClrName1 NVARCHAR(4000);
set @Hash1 = HASHBYTES(N'SHA2_512', 0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000504500004c010300cdef7c440000000000000000e0000e210b010800000c000000080000000000005e2b000000200000004000000000ec560020000000020000040000000000000004000000000000000080000000020000f2f10000030000040000100000100000000010000010000000000000100000000000000000000000042b000057000000004000001005000000000000000000000000000000000000006000000c0000008c2a00001c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000640b000000200000000c000000020000000000000000000000000000200000602e72737263000000100500000040000000060000000e0000000000000000000000000000400000402e72656c6f6300000c0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000402b0000000000004800000002000500082100008409000009000000000000000000000000000000502000008000000000000000000000000000000000000000000000000000000000000000000000000c506f2ef337d14f0bc66e27fa02006623253f6655697a25078f76132dfd4cf9ec02d54581a9310a12538c2a82f19f230bbe2ac6017a095a82147a15f65488b5b38c9612cfc2c228f748d5519b4981a836189698e99b7f54961091fbb404afb93ab9d8110f22652ab16e7ff50f9dfb4236d78f61e93555018ba85d95c28cb5452a02281000000a0000002a00133003001e00000001000011000214fe0116fe010b072d0500160a2b0b02031e281200000a0a2b00062a000042534a4201000100000000000c00000076322e302e35303732370000000005006c0000001c020000237e0000880200003c03000023537472696e677300000000c40500000800000023555300cc050000100000002347554944000000dc050000a803000023426c6f620000000000000002000001471502000900000000fa0133001600000100000014000000020000000200000002000000120000000e00000001000000010000000300000000000a00010000000000060084007d000600c900aa000600d700aa000600fd00eb0006001601eb0006003101eb0006005001eb0006006d01eb0006008401eb0006009f01eb000600b801eb000600d101eb000600ee01eb0006001a0207023b002e02000006005d023d0206007d023d020a00df02c4020e00210302030e00270302030000000001000000000001000100010110002b004600050001000100d0200000000081188b000a000100dc2000000000960091000e00010000000100f40200000200fa0211008b00140019008b00190021008b00140029008b00140031008b00140039008b00140041008b00140049008b00140051008b00140059008b00140061008b00140069008b00140071008b001e0081008b00240089008b000a0009008b000a0091008b000a009900340336022e003b00ac022e000b0043022e0013006d022e0023006d022e002b006d022e00330073022e0053004a032e004300e4022e004b0025032e006b0075032e007b0087032e005b0065032e0073007e0340008b00cb003e020480000006000000f50f00000100000029009b02000002000000000000000000000001007400000000000200000000000000000000000100b8020000000002000000000000000000000001007d00000000000000003c4d6f64756c653e004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e646c6c00526567756c617245787072657373696f6e4576616c7561746f72004d6963726f736f66742e456e74657270726973654d616e6167656d656e742e446174614163636573732e53716c006d73636f726c69620053797374656d004f626a656374002e63746f72004d617463686573526567756c617245787072657373696f6e0053797374656d2e52756e74696d652e496e7465726f705365727669636573004775696441747472696275746500436f6d56697369626c654174747269627574650053797374656d2e5265666c656374696f6e00417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c6541747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f6475637441747472696275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c7946696c6556657273696f6e41747472696275746500417373656d626c7956657273696f6e4174747269627574650053797374656d2e446961676e6f73746963730044656275676761626c6541747472696275746500446562756767696e674d6f6465730053797374656d2e52756e74696d652e436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c0053797374656d2e44617461004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e41747472696275746500696e707574007061747465726e0053797374656d2e546578742e526567756c617245787072657373696f6e730052656765780052656765784f7074696f6e730049734d61746368000003200000000000a79e22af2016204a81c804d4f9bce8010008b77a5c561934e08903200001050002020e0e042001010e042001010205200101113d042001010880a000240000048000009400000006020000002400005253413100040000010001004ddb14fd25fa54ef1fe05516d69c0bb19c86956e2d5245e728300417e6a018daac56b61ee215e4c096dba942368bb4aa76956042bb3efb709cda847d7396839f57a40b90829fe5f347a5d2e2c198367cbc1092aa9762ae9776e59fed16703887329ffeb6d6cbf44853c496a22bc79bb3ce00f29760995dafa6aa97779983e0b48169010005005455794d6963726f736f66742e53716c5365727665722e5365727665722e446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038390a446174614163636573730000000054020f497344657465726d696e69737469630154020949735072656369736501540e044e616d651b666e5f4d617463686573526567756c617245787072657373696f6e54557f4d6963726f736f66742e53716c5365727665722e5365727665722e53797374656d446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038391053797374656d4461746141636365737300000000070003020e0e115104070202022901002433333532323533352d393332652d346130342d623965302d30616330383630353137663300000501000000003801003353716c436c722066756e6374696f6e616c697479207573656420627920746865206461746120616363657373206c617965722e0000370100324d6963726f736f66742e456e74657270726973654d616e6167656d656e742e53716c2e446174614163636573734c6179657200004001003b436f707972696768742032303035204d6963726f736f667420436f72706f726174696f6e2e2020416c6c207269676874732072657365727665642e00002401001f4d6963726f736f6674204f7065726174696f6e73204d616e6167657220763300001a0100154d6963726f736f667420436f72706f726174696f6e00000f01000a362e302e343038352e3000000801000701000000000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f777301000000000000cdef7c44000000000200000059000000a82a0000a80c000052534453165649e3ed4a514990cc3fb2ca36648a01000000643a5c6d6f6d76332e6d61696e5c7461726765745c64656275675c693338365c4d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e706462000000002c2b000000000000000000004e2b0000002000000000000000000000000000000000000000000000402b00000000000000000000000000000000000000005f436f72446c6c4d61696e006d73636f7265652e646c6c0000000000ff250020ec5600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000b80400000000000000000000b80434000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000bd04effe00000100000006000000f50f000006000000f50f3f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b00418040000010053007400720069006e006700460069006c00650049006e0066006f000000f4030000010030003000300030003000340062003000000080003400010043006f006d006d0065006e00740073000000530071006c0043006c0072002000660075006e006300740069006f006e0061006c0069007400790020007500730065006400200062007900200074006800650020006400610074006100200061006300630065007300730020006c0061007900650072002e0000004c001600010043006f006d00700061006e0079004e0061006d006500000000004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e000000900033000100460069006c0065004400650073006300720069007000740069006f006e00000000004d006900630072006f0073006f00660074002e0045006e00740065007200700072006900730065004d0061006e006100670065006d0065006e0074002e00530071006c002e0044006100740061004100630063006500730073004c0061007900650072000000000038000b000100460069006c006500560065007200730069006f006e000000000036002e0030002e0034003000380035002e0030000000000064002100010049006e007400650072006e0061006c004e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c00000000009c003c0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000320030003000350020004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e002e002000200041006c006c0020007200690067006800740073002000720065007300650072007600650064002e0000006c00210001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c0000000000600020000100500072006f0064007500630074004e0061006d006500000000004d006900630072006f0073006f006600740020004f007000650072006100740069006f006e00730020004d0061006e00610067006500720020007600330000003c000b000100500072006f006400750063007400560065007200730069006f006e00000036002e0030002e0034003000380035002e0030000000000040000b00010041007300730065006d0062006c0079002000560065007200730069006f006e00000036002e0030002e0034003000380035002e00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000c000000603b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set        @ClrName1 = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.DataAccessLayer');        

-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName1)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash1
END        

--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash1, @ClrName1        
END
GO

-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash BINARY(64), @ClrName NVARCHAR(4000);
set  @Hash = HASHBYTES(N'SHA2_512', 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006182CF4B0000000000000000E00002210B010800001600000008000000000000BE3400000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000006834000053000000004000006004000000000000000000000000000000000000006000000C000000B83300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000C4140000002000000016000000020000000000000000000000000000200000602E7273726300000060040000004000000006000000180000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001E00000000000000000000000000004000004200000000000000000000000000000000A0340000000000004800000002000500DC250000DC0D00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000360002731000000A7D010000042A0000133002002D00000001000011000F01281100000A16FE010A062D03002B1A027B010000040F01281200000A6F1300000A1F2C6F1400000A262A5200027B01000004037B010000046F1500000A262A0000133004004C00000002000011007E1600000A0A027B010000042C13027B010000046F1700000A16FE0216FE012B01170C082D1A027B0100000416027B010000046F1700000A17596F1800000A0A06731900000A0B2B00072A133003002900000001000011000314FE0116FE010A062D0B7201000070731A00000A7A02036F1B00000A731C00000A7D010000042A000000133002002A00000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03027B010000046F1D00000A6F1E00000A002A1E02281F00000A2A5602281F00000A000002732100000A7D02000004002A133002002F000000010000110228080000060000032C0E036F2200000A16FE0216FE012B01170A062D0F00027B02000004036F2300000A0000002A001B3003007600000003000011007E1600000A0A00027B020000046F2400000A0D2B1C1203282500000A0B00067209000070076F1D00000A282600000A0A001203282700000A130411042DD7DE0F1203FE160300001B6F2800000A00DC0006282900000A16FE01130411042D09007E1600000A0C2B0B0006176F2A00000A0C2B00082A000001100000020014002D41000F0000000013300200140000000100001100027B020000046F2B00000A16FE010A2B00062A133001000B000000040000110073080000060A2B00062A00133004008100000005000011000F00281200000A0A0F00281100000A2D10066F2C00000A282900000A16FE012B0116130411042D08280C0000060D2B4E06178D2100000113051105161F2C9D1105176F2D00000A0B160C2B1600070807089A6F2C00000A6F2E00000AA2000817580C08078E69FE04130411042DDE07280100002B000773090000060D2B00092A00000013300100110000000600001100027B020000046F2B00000A0A2B00062A0000001B300300560000000700001100160A00027B020000046F2400000A0D2B1F1203282500000A0B0007031B283100000A0A0616FE01130411042D022B0E001203282700000A130411042DD4DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010003040000F000000001B300200520000000700001100170A00037B020000046F2400000A0D2B1B1203282500000A0B000207280F0000060A06130411042D022B0E001203282700000A130411042DD8DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010002C3C000F0000000013300200170000000800001100020328130000060A066F0B00000616FE010B2B00072A001B300200670000000900001100027B0200000473090000060A00037B020000046F2400000A0D2B261203282500000A0B0006076F0F000006130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCDDE0F1203FE160300001B6F2800000A00DC00060C2B00082A000110000002001A003751000F000000001B30020064000000090000110073080000060A00037B020000046F2400000A0D2B291203282500000A0B0002076F0F00000616FE01130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCADE0F1203FE160300001B6F2800000A00DC00060C2B00082A01100000020014003A4E000F0000000013300400410000000A000011000314FE0116FE010C082D0B7201000070731A00000A7A036F1B00000A0A06178D210000010D09161F2C9D09176F2D00000A0B027B02000004076F2300000A002A000000133002002500000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03026F1D00000A6F1E00000A002A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000014050000237E000080050000A805000023537472696E677300000000280B00001000000023555300380B0000100000002347554944000000480B00009402000023426C6F6200000000000000020000015717A2090908000000FA01330016000001000000250000000300000002000000150000000F0000000300000032000000110000000A0000000100000002000000020000000300000001000000020000000100000000000A0001000000000006009C0095000A00CA00AF000A00F000DB0006000601FA000A002C01DB0006005B01510106006D0151010600A10186010600B001860106006902570206008002570206009D0257020600BC0257020600D50257020600EE02570206000903570206002403570206005C033D0306007003570206009C0389035300B00300000600DF03BF030600FF03BF0306001D0495000A003304AF000A005404AF0006006C0495000600840495000A00A504AF000600CB0486012300E204000006001705950006004805950006004D05950006006E0595000A007905AF0006008C059500000000000100000000000100010001201000450051000500010001000120100088005100050002000800010014010A000100A8012F00502000000000860027010E00010060200000000086003601120001009920000000008600410118000200B02000000000860047011E000300082100000000E601680123000300402100000000E6017A0129000400762100000000861880010E0005007E2100000000861880010E0005009421000000008618800136000500D02100000000C600BE013F000600642200000000E609C701430006008422000000009608D201470006009C22000000009600DB014C0006002C23000000008600E101530007004C23000000008600E70157000700C023000000008600EB015C0008003024000000008600F4015C0009005424000000009600FD0162000A00D824000000009600030262000C00582500000000E601680123000E00A82500000000E6017A0129000F00000001001902000001001F02000001002502000001002702000001002902000001003102000001003302000001003B02000001004202000001004A02000002005002000001004A020000020050020000010025020000010027020200090003000D0003000900510080017400590080017400610080017400690080017400710080017400790080017400810080017400890080017400910080017900990080017400A10080017E00B10080018400B90080010E00C10080010E00C90080018900210080010E002900C701430029005B043F0021006504F10021006504F700210065040101D900730407012100790453002100BE010A01290080017400E1008001740031009A043F002100800174000900BE013F0039007A017400090080010E00E900800189000C0080010E001400C10453000C00D9044F010C00ED0459011C00FB046801D90007056D011C000E054300010123050E00D9002B057401D900390579010C00C1045300D90043053F00D90060058F01D90066053F00190174059901210180010E00D9009D05DA010C00A405F5012E001B002B022E006B0073022E000B0012022E0013002B022E00230031022E002B0012022E00330040022E003B002B022E004B002B022E005B0061022E0063006A0243007B008F00630003011701C0018301B101E0018301B10100028301B10120028301B101FD0010017E018A01A501D601E301EF01FB0109020300010000000D026B00000014026F0002000B00030002000C0005004301490162010480000001000000B30EF0680000000000005100000002000000000000000000000001008C00000000000200000000000000000000000100A300000000005F00A10100000000003C4D6F64756C653E004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E646C6C00436F6E636174656E617465004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E6564446174615479706500536574006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E446174612E53716C547970657300494E756C6C61626C650053797374656D2E5465787400537472696E674275696C64657200696E7465726D656469617465526573756C7400496E69740053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F720053797374656D2E436F6C6C656374696F6E732E47656E65726963004C6973746031006D656D626572730049436F6C6C656374696F6E603100546F537472696E67006765745F49734E756C6C006765745F4E756C6C00506172736500436F756E740048617300496E636C7564657300496E436F6D6D6F6E00556E696F6E00496E746572736563740049734E756C6C004E756C6C0076616C7565006F7468657200720077006F626A65637473007300656C656D656E740073756273657400616E6F74686572006669727374007365636F6E640053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174006765745F56616C756500417070656E6400537472696E6700456D707479006765745F4C656E67746800417267756D656E744E756C6C457863657074696F6E0052656164537472696E670053716C55736572446566696E656454797065417474726962757465006765745F436F756E740049456E756D657261626C6560310041646452616E676500456E756D657261746F7200476574456E756D657261746F72006765745F43757272656E7400436F6E636174004D6F76654E6578740049446973706F7361626C6500446973706F73650049734E756C6C4F72456D70747900537562737472696E67005472696D004368617200537472696E6753706C69744F7074696F6E730053706C697400546F4C6F77657200417272617900536F72740053716C4D6574686F6441747472696275746500537472696E67436F6D70617269736F6E00457175616C730041646400000372000003770000032C0000000000988CD7764C980A49A3DB04E0EFC50A160008B77A5C561934E0890306121103200001052001011115052001011208042000111505200101121905200101121D0606151221010E08200101151225010E0320000E03200002040000120C060001120C111503200008042001020E05200102120C080002120C120C120C03280002040800120C042001010E042001010205200101115504200101080520010111696101000200000004005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F000005200112110E0520011211030307010205200112111C02060E0520020E08080607030E1115022B010002000000020054080B4D61784279746553697A65401F000054020D4973427974654F7264657265640105151221010E05151225010E0920010115127901130008200015117D0113000515117D010E04200013000600030E0E0E0E040001020E0420010E080B07050E0E0E15117D010E02040701120C0920021D0E1D0311808907100101011D1E00030A010E0B07060E1D0E08120C021D03240100020054020F497344657465726D696E6973746963015402094973507265636973650103070108080003020E0E1180950B0705020E0215117D010E02050702120C020520010113000D0705120C0E120C15117D010E020807040E1D0E021D031801001355736572446566696E6564446174615479706500000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000006182CF4B000000000200000091000000D4330000D415000052534453E34F9E44F81FB94E95CF281C5235867A01000000443A5C50726F6A656374735C55736572446566696E656444617461547970655C55736572446566696E656444617461547970655C6F626A5C44656275675C4D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E70646200000000903400000000000000000000AE340000002000000000000000000000000000000000000000000000A034000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000080400000000000000000000080434000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE0000010000000100F068B30E00000100F068B30E3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00468030000010053007400720069006E006700460069006C00650049006E0066006F00000044030000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000500014000100460069006C0065004400650073006300720069007000740069006F006E0000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0033003700360033002E00320036003800360034000000000098003B00010049006E007400650072006E0061006C004E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C00000000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F00660074002000320030003100300000000000A0003B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C0000000000480014000100500072006F0064007500630074004E0061006D00650000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0033003700360033002E00320036003800360034000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0033003700360033002E0032003600380036003400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000C03400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set        @ClrName = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.UserDefinedDataType');

-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash
END        

--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash, @ClrName        
END
GO

Sunucu İşletim Sistemi

Aşağıdaki Windows Server işletim sistemi sürümleri desteklenir.

System Center bileşeni	Windows Server 2019 Standard, Datacenter	Windows Server 2019 Server Core	Windows Server 2022 Standard, Datacenter	Windows Server 2022 Server Core
Service Manager Yönetim Sunucusu	•	•	•	•
Service Manager Data Warehouse Yönetim Sunucusu	•	•	•	•
Service Manager Veritabanı veya Veri Ambarı Veritabanı	•	•	•	•
Service Manager Self Servis Portalı (HTLM 5)	•	•	•	•

İstemci işletim sistemi

Windows istemci işletim sisteminin aşağıdaki sürümleri Service Manager konsolu için desteklenir.

System Center istemci tarafı bileşenleri	Windows Server® 2019 Standard, Datacenter Enterprise	Windows Server® 2022 Standard, Datacenter	Windows 10	Windows 11
Service Manager Konsolu	•	•	•	•

Desteklenen .NET Sürümleri

.NET'in aşağıdaki sürümleri Service Manager için desteklenir.

System Center bileşeni	.NET 3.5 SP1	.NET 4	.NET 4.5	.NET 4.5.1	.Net 4.5.2	.NET 4.6	.NET 4.6.1	.NET 4.7	.NET 4.8
Service Manager Yönetim Sunucusu	•			•		•	•	•	•
Service Manager Data Warehouse Yönetim Sunucusu	•			•		•	•	•	•
Service Manager konsolu	•			•		•	•	•	•
Service Manager Self-Service Portalı	•			•		•	•	•	•

Desteklenen PowerShell Sürümleri

Aşağıdaki PowerShell sürümleri Service Manager için desteklenir.

System Center Bileşeni	Windows PowerShell 4.0	Windows PowerShell 5.0
Service Manager Konsolu	•	•
Service Manager Yönetim Sunucusu	•	•
Service Manager Data Warehouse Yönetim Sunucusu	•	•

Sonraki adımlar

• Perakende satış ve Service Manager sürümleri hakkında bilgi edinmek ve 180 günlük değerlendirme yüklemesini seçmenin bu iki sürüm üzerindeki etkisini öğrenmek için Service Manager sürümleri gözden geçirin.
• Service Manager test edilen sınırları hakkında bilgi edinmek için Dağıtım senaryoları için yapılandırmalar bölümünü okuyun.
• Service Manager donanım performansı hakkında bilgi edinin.