{"id":21993,"date":"2026-09-16T17:38:44","date_gmt":"2026-09-16T14:08:44","guid":{"rendered":"https:\/\/maralhost.com\/kb\/docs\/windows\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d9%86%d8%b5%d8%a8-sql-server-2025\/"},"modified":"2026-09-16T17:50:15","modified_gmt":"2026-09-16T14:20:15","slug":"sql-server-2025-installation","status":"publish","type":"docs","link":"https:\/\/maralhost.com\/kb\/docs\/windows\/sql-server-2025-installation\/","title":{"rendered":"\u0622\u0645\u0648\u0632\u0634 \u0646\u0635\u0628 SQL Server 2025 \u062f\u0631 Windows Server"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u0645\u0642\u062f\u0645\u0647<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Microsoft SQL Server<\/strong> \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u062d\u0628\u0648\u0628\u200c\u062a\u0631\u06cc\u0646 \u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 (Database Management System) \u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u0633\u0627\u0632\u0645\u0627\u0646\u06cc \u0648 \u0633\u0631\u0648\u0631\u06cc \u0627\u0633\u062a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Server \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u067e\u0631\u062f\u0627\u0632\u0634 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631 \u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627<\/li>\n\n\n\n<li>\u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u0633\u0627\u0632\u0645\u0627\u0646\u06cc<\/li>\n\n\n\n<li>ERP \u0648 CRM<\/li>\n\n\n\n<li>\u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627\u06cc \u0645\u0627\u0644\u06cc<\/li>\n\n\n\n<li>Application Server\u0647\u0627<\/li>\n\n\n\n<li>\u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627\u06cc \u062f\u0627\u062e\u0644\u06cc \u0633\u0627\u0632\u0645\u0627\u0646<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0646\u062d\u0648\u0647 \u0646\u0635\u0628 <strong>SQL Server 2025<\/strong> \u0631\u0648\u06cc <strong>Windows Server 2025<\/strong> \u0631\u0627 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0645\u0631\u062d\u0644\u0647\u200c\u0628\u0647\u200c\u0645\u0631\u062d\u0644\u0647 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u067e\u06cc\u0634\u200c\u0646\u06cc\u0627\u0632\u0647\u0627\u06cc \u0646\u0635\u0628 SQL Server 2025<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0642\u0628\u0644 \u0627\u0632 \u0634\u0631\u0648\u0639 \u0646\u0635\u0628\u060c \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0633\u06cc\u0633\u062a\u0645\u200c\u0639\u0627\u0645\u0644 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0634\u062f\u0647<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Server 2025 \u0642\u0627\u0628\u0644\u06cc\u062a \u0646\u0635\u0628 \u0631\u0648\u06cc \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f Windows Server \u0631\u0627 \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u06cc\u0634\u0646\u0647\u0627\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Windows Server 2025 Standard\nWindows Server 2025 Datacenter<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u0645\u0646\u0627\u0628\u0639 \u0633\u062e\u062a\u200c\u0627\u0641\u0632\u0627\u0631\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u062d\u062f\u0627\u0642\u0644 \u0645\u0646\u0627\u0628\u0639 \u0628\u0633\u062a\u0647 \u0628\u0647 \u0646\u0648\u0639 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u062a\u0641\u0627\u0648\u062a \u0627\u0633\u062a.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u0645\u0648\u0631\u062f<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u0645\u0642\u062f\u0627\u0631 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">CPU<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u062d\u062f\u0627\u0642\u0644 4 Core<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">RAM<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u062d\u062f\u0627\u0642\u0644 8GB<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Storage<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u0641\u0636\u0627\u06cc \u06a9\u0627\u0641\u06cc \u0628\u0631\u0627\u06cc Database \u0648 Log<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Disk<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u062a\u0631\u062c\u06cc\u062d\u0627\u064b SSD<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Network<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u062f\u0627\u0631<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0627\u0642\u062f\u0627\u0645\u0627\u062a \u0642\u0628\u0644 \u0627\u0632 \u0646\u0635\u0628<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0642\u0628\u0644 \u0627\u0632 \u0646\u0635\u0628 SQL Server \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0628\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc Windows Server<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0628\u062a\u062f\u0627 Windows Update \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u06cc\u0631:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Settings\nWindows Update\nCheck for updates<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0646\u0638\u06cc\u0645 \u0646\u0627\u0645 Server<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u0642\u0628\u0644 \u0627\u0632 \u0646\u0635\u0628 SQL Server \u0646\u0627\u0645 \u0633\u06cc\u0633\u062a\u0645 \u0646\u0647\u0627\u06cc\u06cc \u0634\u062f\u0647 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc \u0646\u0627\u0645:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>hostname<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u062a\u063a\u06cc\u06cc\u0631 \u0646\u0627\u0645:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Rename-Computer -NewName SQL-SERVER01<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0633\u067e\u0633 Restart:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Restart-Computer<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u0628\u0631\u0631\u0633\u06cc \u0641\u0636\u0627\u06cc Disk<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc \u0641\u0636\u0627\u06cc \u0622\u0632\u0627\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Get-PSDrive<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06cc\u0627:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wmic logicaldisk get size,freespace,caption<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Server \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0646\u0635\u0628\u060c \u0628\u0631\u0627\u06cc Database \u0648 Transaction Log \u0646\u06cc\u0632 \u0628\u0647 \u0641\u0636\u0627\u06cc \u06a9\u0627\u0641\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u062f\u0627\u0646\u0644\u0648\u062f SQL Server 2025<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0641\u0627\u06cc\u0644 \u0646\u0635\u0628 SQL Server \u0631\u0627 \u0627\u0632 \u0633\u0627\u06cc\u062a \u0631\u0633\u0645\u06cc Microsoft \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0632\u0645\u0627\u0646 \u0646\u0635\u0628 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u06af\u0632\u06cc\u0646\u0647\u200c\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Developer Edition\nExpress Edition\nStandard Edition\nEnterprise Edition<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc \u0645\u062d\u06cc\u0637 Production \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0627\u0632:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Standard\nEnterprise<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc \u0645\u062d\u06cc\u0637 \u062a\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Developer<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0646\u0627\u0633\u0628 \u0627\u0633\u062a.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"936\" src=\"https:\/\/maralhost.com\/kb\/wp-content\/uploads\/2026\/09\/SQL-Server-2025-Installation-Guide1-1024x936.webp\" alt=\"\" class=\"wp-image-22002\" title=\"\" srcset=\"https:\/\/maralhost.com\/kb\/wp-content\/uploads\/2026\/09\/SQL-Server-2025-Installation-Guide1-1024x936.webp 1024w, https:\/\/maralhost.com\/kb\/wp-content\/uploads\/2026\/09\/SQL-Server-2025-Installation-Guide1-300x274.webp 300w, https:\/\/maralhost.com\/kb\/wp-content\/uploads\/2026\/09\/SQL-Server-2025-Installation-Guide1-767x701.webp 767w, https:\/\/maralhost.com\/kb\/wp-content\/uploads\/2026\/09\/SQL-Server-2025-Installation-Guide1.webp 1312w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">\u0627\u062c\u0631\u0627\u06cc Setup<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0633 \u0627\u0632 Mount \u06a9\u0631\u062f\u0646 ISO \u06cc\u0627 \u0627\u062c\u0631\u0627\u06cc \u0641\u0627\u06cc\u0644 \u0646\u0635\u0628:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0641\u0627\u06cc\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>setup.exe<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0646\u062c\u0631\u0647 SQL Server Installation Center \u0628\u0627\u0632 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u0627\u0648\u0644: \u0627\u0646\u062a\u062e\u0627\u0628 Installation<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0632 \u0645\u0646\u0648\u06cc \u0633\u0645\u062a \u0686\u067e:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Installation<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0633\u067e\u0633:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>New SQL Server stand-alone installation or add features to an existing installation<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u062f\u0648\u0645: \u0628\u0631\u0631\u0633\u06cc Setup Support Rules<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Server \u0642\u0628\u0644 \u0627\u0632 \u0646\u0635\u0628 \u0633\u06cc\u0633\u062a\u0645 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0648\u0627\u0631\u062f\u06cc \u0645\u0627\u0646\u0646\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627\u06cc \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632<\/li>\n\n\n\n<li>Restart Pending<\/li>\n\n\n\n<li>Firewall<\/li>\n\n\n\n<li>Permission<\/li>\n\n\n\n<li>\u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0646\u0635\u0628<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0635\u0648\u0631\u062a \u0648\u062c\u0648\u062f \u062e\u0637\u0627 \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0645\u0634\u06a9\u0644 \u0631\u0641\u0639 \u0634\u0648\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u0633\u0648\u0645: \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 License<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634 License Key \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u06cc\u0627 Edition \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Enterprise Evaluation\nDeveloper\nStandard\nEnterprise<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0633\u067e\u0633:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Next<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u0686\u0647\u0627\u0631\u0645: \u0642\u0628\u0648\u0644 \u0642\u0648\u0627\u0646\u06cc\u0646 Microsoft<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u06af\u0632\u06cc\u0646\u0647:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>I accept the license terms<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0633\u067e\u0633:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Next<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u067e\u0646\u062c\u0645: \u0646\u0635\u0628 Setup Files<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Setup \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u0646\u0635\u0628 \u0631\u0627 \u0622\u0645\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0646\u062a\u0638\u0631 \u0628\u0645\u0627\u0646\u06cc\u062f \u062a\u0627 \u0645\u0631\u062d\u0644\u0647 \u06a9\u0627\u0645\u0644 \u0634\u0648\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u0634\u0634\u0645: Feature Selection<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0686\u0647 Component\u0647\u0627\u06cc\u06cc \u0646\u0635\u0628 \u0634\u0648\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u06af\u0632\u06cc\u0646\u0647\u200c\u0647\u0627\u06cc \u0645\u0647\u0645:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">Feature<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u06a9\u0627\u0631\u0628\u0631\u062f<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">Database Engine Services<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u0645\u0648\u062a\u0648\u0631 \u0627\u0635\u0644\u06cc SQL Server<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SQL Server Replication<\/td><td class=\"has-text-align-center\" data-align=\"center\">Replication<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Full-Text Search<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u062c\u0633\u062a\u062c\u0648\u06cc \u0645\u062a\u0646\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Analysis Services<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Reporting Services<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u06af\u0632\u0627\u0631\u0634\u200c\u06af\u06cc\u0631\u06cc<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Integration Services<\/td><td class=\"has-text-align-center\" data-align=\"center\">ETL \u0648 \u0627\u0646\u062a\u0642\u0627\u0644 \u062f\u0627\u062f\u0647<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc \u06cc\u06a9 \u0646\u0635\u0628 \u0645\u0639\u0645\u0648\u0644\u06cc:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Database Engine Services<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u0647\u0641\u062a\u0645: \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u0633\u06cc\u0631 \u0646\u0635\u0628<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u06cc\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\Program Files\\Microsoft SQL Server<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0633\u062a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 Server\u0647\u0627\u06cc Production \u0628\u0647\u062a\u0631 \u0627\u0633\u062a:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Database<\/li>\n\n\n\n<li>Log<\/li>\n\n\n\n<li>Backup<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0648\u06cc Disk \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0642\u0631\u0627\u0631 \u06af\u06cc\u0631\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\ SQL Program Files\n\nD:\\ SQL Data\n\nE:\\ SQL Backup<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u0647\u0634\u062a\u0645: Instance Configuration<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0646\u0648\u0639 Instance \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0648 \u062d\u0627\u0644\u062a \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Default Instance<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0646\u0627\u0645 \u0633\u0631\u0648\u06cc\u0633:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MSSQLSERVER<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u062a\u0635\u0627\u0644:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SERVERNAME<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Named Instance<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL2025<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u062a\u0635\u0627\u0644:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SERVERNAME\\SQL2025<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc \u0686\u0646\u062f SQL Server \u0631\u0648\u06cc \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645\u060c Named Instance \u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u0646\u0647\u0645: \u062a\u0646\u0638\u06cc\u0645 \u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0628\u062e\u0634:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Server Configuration<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627\u06cc SQL Server \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0648\u0627\u0631\u062f \u0645\u0647\u0645:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL Server Database Engine\nSQL Server Agent\nSQL Server Browser<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u062a\u0646\u0638\u06cc\u0645 Startup Type<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc Production \u0645\u0639\u0645\u0648\u0644\u0627\u064b:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Automatic<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u062f\u0647\u0645: Database Engine Configuration<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0627\u0633\u062a.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Authentication Mode<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0648 \u062d\u0627\u0644\u062a \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Windows Authentication<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0641\u0642\u0637 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 Windows \u06cc\u0627 Domain \u0627\u062c\u0627\u0632\u0647 Login \u062f\u0627\u0631\u0646\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Mixed Mode<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0645\u06a9\u0627\u0646 Login \u0628\u0627:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Windows Account\nSQL Login<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0635\u0648\u0631\u062a \u0627\u0646\u062a\u062e\u0627\u0628 Mixed Mode \u0628\u0627\u06cc\u062f \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sa<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062a\u0639\u06cc\u06cc\u0646 \u0634\u0648\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0627\u0641\u0632\u0648\u062f\u0646 Administrator<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0628\u062e\u0634:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Specify SQL Server administrators<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06a9\u0627\u0631\u0628\u0631 Administrator \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DOMAIN\\Administrator<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06cc\u0627:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SERVER01\\Administrator<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u062a\u0646\u0638\u06cc\u0645 \u0645\u0633\u06cc\u0631 Database Files<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u06cc\u0631\u0647\u0627\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">\u0645\u0648\u0631\u062f<\/th><th class=\"has-text-align-center\" data-align=\"center\">\u0645\u0633\u06cc\u0631 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">Data Root Directory<\/td><td class=\"has-text-align-center\" data-align=\"center\">D:\\SQL\\Data<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">User Database Directory<\/td><td class=\"has-text-align-center\" data-align=\"center\">D:\\SQL\\Data<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">User Log Directory<\/td><td class=\"has-text-align-center\" data-align=\"center\">E:\\SQL\\Log<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Backup Directory<\/td><td class=\"has-text-align-center\" data-align=\"center\">F:\\SQL\\Backup<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0631\u062d\u0644\u0647 \u06cc\u0627\u0632\u062f\u0647\u0645: \u0646\u0635\u0628 SQL Server<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u0635\u0641\u062d\u0647:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Ready to Install<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u0648:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Install<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0641\u0631\u0622\u06cc\u0646\u062f \u0646\u0635\u0628 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0628\u0631\u0631\u0633\u06cc \u0648\u0636\u0639\u06cc\u062a \u0633\u0631\u0648\u06cc\u0633 SQL Server<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0633 \u0627\u0632 \u0646\u0635\u0628:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>services.msc<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL Server (MSSQLSERVER)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 \u062d\u0627\u0644\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Running<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0627\u0634\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0628\u0631\u0631\u0633\u06cc \u0628\u0627 PowerShell<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0646\u0645\u0627\u06cc\u0634 \u0633\u0631\u0648\u06cc\u0633 SQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Get-Service | Where-Object {$_.Name -like \"*SQL*\"}<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0646\u0635\u0628 SQL Server Management Studio (SSMS)<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a SQL Server \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0627\u0632 SSMS \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SSMS \u0627\u0628\u0632\u0627\u0631 \u062c\u062f\u0627\u06af\u0627\u0646\u0647\u200c\u0627\u06cc \u0627\u0632 SQL Server \u0627\u0633\u062a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0633 \u0627\u0632 \u0646\u0635\u0628:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL Server Management Studio<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0627\u062a\u0635\u0627\u0644 \u0628\u0647 SQL Server<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 SSMS:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Server Type:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Database Engine<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Server Name:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc Default Instance:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SERVERNAME<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc Named Instance:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SERVERNAME\\INSTANCE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Authentication:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Windows Authentication<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06cc\u0627:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL Server Authentication<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u0646 TCP\/IP<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 Remote \u0628\u0627\u06cc\u062f TCP\/IP \u0641\u0639\u0627\u0644 \u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL Server Configuration Manager<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u06cc\u0631:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL Server Network Configuration\nProtocols for MSSQLSERVER<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06af\u0632\u06cc\u0646\u0647:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TCP\/IP<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Enable<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u062a\u0646\u0638\u06cc\u0645 \u067e\u0648\u0631\u062a SQL Server<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0648\u0631\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TCP 1433<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0633\u062a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 TCP\/IP:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>IP Addresses<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0642\u0633\u0645\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TCP Port<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0633 \u0627\u0632 \u062a\u063a\u06cc\u06cc\u0631:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0633\u0631\u0648\u06cc\u0633 SQL Server \u0631\u0627 Restart \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u0646 Remote Connection<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0631 SSMS:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0648\u06cc Server:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Properties\nConnections<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06af\u0632\u06cc\u0646\u0647:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Allow remote connections to this server<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0631\u0627 \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u062a\u0646\u0638\u06cc\u0645 Firewall \u0648\u06cc\u0646\u062f\u0648\u0632<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 Remote \u0628\u0627\u06cc\u062f \u067e\u0648\u0631\u062a SQL \u0628\u0627\u0632 \u0634\u0648\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u062b\u0627\u0644:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>New-NetFirewallRule `\n-DisplayName \"SQL Server TCP 1433\" `\n-Direction Inbound `\n-Protocol TCP `\n-LocalPort 1433 `\n-Action Allow<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0628\u0631\u0631\u0633\u06cc \u0627\u062a\u0635\u0627\u0644 SQL Server<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0627 PowerShell:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Test-NetConnection SERVERNAME -Port 1433<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u062e\u0631\u0648\u062c\u06cc \u0645\u0648\u0641\u0642:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TcpTestSucceeded : True<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0628\u0631\u0631\u0633\u06cc Version SQL Server<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u062f\u0627\u062e\u0644 SSMS \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT @@VERSION;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u06cc\u0627:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SERVERPROPERTY('ProductVersion');<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u062e\u0637\u0627\u0647\u0627\u06cc \u0631\u0627\u06cc\u062c \u0646\u0635\u0628 SQL Server<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">\u0646\u0635\u0628 \u0645\u062a\u0648\u0642\u0641 \u0645\u06cc\u200c\u0634\u0648\u062f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pending Restart \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f.<\/li>\n\n\n\n<li>\u0641\u0636\u0627\u06cc Disk \u06a9\u0627\u0641\u06cc \u0628\u0627\u0634\u062f.<\/li>\n\n\n\n<li>Windows Update \u06a9\u0627\u0645\u0644 \u0628\u0627\u0634\u062f.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u0627\u062a\u0635\u0627\u0644 Remote \u0628\u0631\u0642\u0631\u0627\u0631 \u0646\u0645\u06cc\u200c\u0634\u0648\u062f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TCP\/IP Enabled\nFirewall\nSQL Service Running\nPort Configuration<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Login \u0628\u0627 sa \u0627\u0646\u062c\u0627\u0645 \u0646\u0645\u06cc\u200c\u0634\u0648\u062f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Mixed Mode Authentication<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0641\u0639\u0627\u0644 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0633\u067e\u0633:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER LOGIN sa ENABLE;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Service \u0627\u062c\u0631\u0627 \u0646\u0645\u06cc\u200c\u0634\u0648\u062f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0628\u0631\u0631\u0633\u06cc Log:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u06cc\u0631:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Event Viewer\nWindows Logs\nApplication<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0648:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL Server Error Log<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0628\u0647\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0628\u0631\u0627\u06cc sa \u0631\u0645\u0632 \u0642\u0648\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u062f\u0631 \u0635\u0648\u0631\u062a \u0639\u062f\u0645 \u0646\u06cc\u0627\u0632\u060c sa \u0631\u0627 Disable \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>SQL Server \u0631\u0627 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0631\u0648\u06cc \u0627\u06cc\u0646\u062a\u0631\u0646\u062a \u0642\u0631\u0627\u0631 \u0646\u062f\u0647\u06cc\u062f.<\/li>\n\n\n\n<li>\u067e\u0648\u0631\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0631\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n\n\n\n<li>Backup \u0645\u0646\u0638\u0645 Database \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/li>\n\n\n\n<li>\u062f\u0633\u062a\u0631\u0633\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u0645\u062d\u062f\u0648\u062f \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>SQL Server \u0631\u0627 \u0647\u0645\u06cc\u0634\u0647 \u0628\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u0645\u0637\u0627\u0644\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u062a\u0646\u062f \u0631\u0633\u0645\u06cc Microsoft \u062f\u0631\u0628\u0627\u0631\u0647 \u0646\u0635\u0628 SQL Server:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/install-sql-server\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/install-sql-server<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u062a\u0646\u062f \u0631\u0633\u0645\u06cc Microsoft \u062f\u0631\u0628\u0627\u0631\u0647 SQL Server Management Studio:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/ssms\/install\/install\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/ssms\/install\/install<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0645\u0633\u062a\u0646\u062f \u0631\u0633\u0645\u06cc Microsoft \u062f\u0631\u0628\u0627\u0631\u0647 \u062a\u0646\u0638\u06cc\u0645 Remote Connection:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/configure-the-remote-access-server-configuration-option\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/configure-the-remote-access-server-configuration-option<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u062c\u0645\u0639\u200c\u0628\u0646\u062f\u06cc<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u0646\u0635\u0628 SQL Server 2025 \u0631\u0648\u06cc Windows Server \u0634\u0627\u0645\u0644 \u0645\u0631\u0627\u062d\u0644 \u0627\u0635\u0644\u06cc \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Download SQL Server\nRun Setup\nFeature Selection\nInstance Configuration\nAuthentication Configuration\nDatabase Engine Setup\nInstall\nInstall SSMS\nEnable TCP\/IP\nConfigure Firewall\nTest Connection<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u067e\u0633 \u0627\u0632 \u0646\u0635\u0628 \u0635\u062d\u06cc\u062d\u060c \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0627\u0645\u0646\u06cc\u062a\u06cc\u060c Backup\u060c \u062f\u0633\u062a\u0631\u0633\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0648 \u0628\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc\u200c\u0647\u0627\u06cc \u062f\u0648\u0631\u0647\u200c\u0627\u06cc \u0627\u0647\u0645\u06cc\u062a \u0632\u06cc\u0627\u062f\u06cc \u062f\u0627\u0631\u0646\u062f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u06cc\u06a9 SQL Server \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0628\u0627\u06cc\u062f \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0646\u0635\u0628 \u0635\u062d\u06cc\u062d\u060c \u062f\u0627\u0631\u0627\u06cc \u0633\u0627\u062e\u062a\u0627\u0631 \u0645\u0646\u0627\u0633\u0628 \u0628\u0631\u0627\u06cc \u0646\u06af\u0647\u062f\u0627\u0631\u06cc Database\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0633\u062a\u0631\u0633\u06cc\u200c\u0647\u0627 \u0648 \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0627\u0634\u062f.<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0645\u0642\u062f\u0645\u0647 Microsoft SQL Server \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u062d\u0628\u0648\u0628\u200c\u062a\u0631\u06cc\u0646 \u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 (Database Management System) \u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u0633\u0627\u0632\u0645\u0627\u0646\u06cc \u0648 \u0633\u0631\u0648\u0631\u06cc \u0627\u0633\u062a. SQL Server \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u067e\u0631\u062f\u0627\u0632\u0634 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631 \u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0646\u062d\u0648\u0647 \u0646\u0635\u0628 SQL Server 2025 \u0631\u0648\u06cc Windows Server 2025 \u0631\u0627 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0645\u0631\u062d\u0644\u0647\u200c\u0628\u0647\u200c\u0645\u0631\u062d\u0644\u0647 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645. \u067e\u06cc\u0634\u200c\u0646\u06cc\u0627\u0632\u0647\u0627\u06cc \u0646\u0635\u0628 SQL Server 2025 [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":21996,"parent":17708,"menu_order":50,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-21993","docs","type-docs","status-publish","has-post-thumbnail","hentry"],"acf":[],"author_avatar":"https:\/\/maralhost.com\/kb\/wp-content\/litespeed\/avatar\/86d527e9d6c721b378b27e18daa8865e.jpg?ver=1790059220","author_name":"Fateme Moayed","_links":{"self":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/21993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/comments?post=21993"}],"version-history":[{"count":3,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/21993\/revisions"}],"predecessor-version":[{"id":22003,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/21993\/revisions\/22003"}],"up":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/docs\/17708"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/media\/21996"}],"wp:attachment":[{"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/media?parent=21993"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/maralhost.com\/kb\/wp-json\/wp\/v2\/doc_tag?post=21993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}