System Center için SQL Server 2019 Kurulumu ve Yapılandırması










NETSH Advfirewall set allprofiles state off

135 | TCP\UDP | Remote Procedure Call (RPC) |
1433 | TCP\UDP | Database Engine |
1434 | TCP\UDP | Administration Connection or SQL Browser |
2382 | TCP\UDP | SQL Server Browser |
2383 | TCP\UDP | Analysis Services |
4022 | TCP\UDP | Service Broker |

NETSH advFirewall firewall add rule name="Allow SQL Server Services" dir=in action=allow protocol=TCP localport=135,1433,1434,2382,2383,4022 remoteip=localsubnet profile=DOMAIN NETSH firewall set MulticastBroadcastResponse ENABL






















SELECT SERVERPROPERTY('MachineName') as 'Server Name', SERVERPROPERTY('instancename') as 'Instance', SERVERPROPERTY('productversion') as 'Product Version', SERVERPROPERTY('productlevel') as 'Product Level', SERVERPROPERTY('edition') as 'Product Edition', SERVERPROPERTY('buildclrversion') as 'CLR Version', SERVERPROPERTY('collation') as 'Default SQL Collation', SERVERPROPERTY('lcid') as 'Win Language Collation' SELECT name, compatibility_level FROM sys.databases ORDER BY compatibility_levelGörüldüğü gibi kurulum yaptığım versiyon 15.0.2000.5 SQL Kurulumları ve ince ayarlamalarımız da tamamlandıktan sonra SQL Server 2019 un son Cumulative Update lerini de yaparak kullanıma hazır hale getiriyoruz. İlk önce aşağıdaki adresten son SQL Server 2019 Cumulative Update’i indiriyoruz. www.microsoft.com/en-us/download/details.aspx?id=100809










Yorumlar
Henüz yorum yok.