{"id":2106,"date":"2017-09-30T21:43:53","date_gmt":"2017-09-30T16:13:53","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=2106"},"modified":"2026-09-13T16:18:34","modified_gmt":"2026-09-13T10:48:34","slug":"install-sql-management-studio-plesk-server","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/install-sql-management-studio-plesk-server\/","title":{"rendered":"How to install SQL management Studio on plesk server"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This guide covers how to install SQL Server Management Studio (SSMS) on a Windows server running Plesk, so you can connect to and manage your MSSQL database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One important fix upfront: the original download link and installation method for this guide are both outdated. SSMS used to be bundled with the SQL Server installer and selected as a feature during setup \u2014 that changed starting with SQL Server 2016, when Microsoft made SSMS a free, standalone tool with its own separate installer and release cycle. The steps below use the current method.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Implementation<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">I. Prerequisites<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A Windows Server with RDP access<\/li>\n\n\n\n<li>MSSQL Server already installed and running<\/li>\n\n\n\n<li>Internet access on the server to download the installer<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">II. How SSMS Connects to MSSQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SSMS is just a client application \u2014 it doesn&#8217;t run the database itself. It connects to your MSSQL Server instance over TCP (port 1433 by default) using either Windows Authentication or SQL Server Authentication, then lets you browse, query, and manage databases through its interface.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2017\/09\/ssms_mssql_architecture-scaled.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"331\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2017\/09\/ssms_mssql_architecture-1024x331.png\" alt=\"\" class=\"wp-image-11733\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2017\/09\/ssms_mssql_architecture-1024x331.png 1024w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2017\/09\/ssms_mssql_architecture-300x97.png 300w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2017\/09\/ssms_mssql_architecture-768x248.png 768w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2017\/09\/ssms_mssql_architecture-1536x497.png 1536w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2017\/09\/ssms_mssql_architecture-2048x663.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">III. Download SSMS<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Log in to the server using RDP, then download SSMS from the <strong>current<\/strong> official Microsoft page:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">https:\/\/learn.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms\n<\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Note:<\/strong> The original download link (<code>microsoft.com\/...\/details.aspx?id=29062<\/code>) pointed to an old SQL Server 2012-era combined installer page that no longer works \u2014 Microsoft&#8217;s old download center URLs for this have been retired. The link above is Microsoft&#8217;s current, maintained SSMS download page and will always point to the latest version.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">IV. Run the Installer<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Double-click the downloaded installer (<code>SSMS-Setup-ENU.exe<\/code>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Unlike the older combined installer, there&#8217;s no &#8220;Add Features to an existing instance&#8221; step anymore \u2014 SSMS installs as its own standalone application now, independent of any specific SQL Server version. Click <strong>Install<\/strong> and let the wizard complete; a restart may be required afterward depending on your Windows version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V. Open SSMS and Connect<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Launch <strong>SQL Server Management Studio<\/strong>, then go to:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">File \u2192 Connect Object Explorer\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Enter your server name and authentication details to connect to your MSSQL instance.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">VI. Conclusion<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Installing SSMS today is simpler than the original combined-installer method \u2014 download the current standalone installer directly from Microsoft, run it, and connect through Object Explorer. Since SSMS now updates independently of SQL Server itself, this same process works regardless of which SQL Server version your Plesk server is actually running.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FAQ-Frequently Asked Questions<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Does SSMS need to match my SQL Server version?<\/strong> No \u2014 since SSMS became standalone, a current SSMS version works with a wide range of SQL Server versions, both older and newer. There&#8217;s no need to track matching version numbers the way the old bundled installer implied.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Can I install SSMS on a different machine and connect to the Plesk server remotely?<\/strong> Yes \u2014 SSMS just needs network access to the SQL Server&#8217;s port (1433 by default), so many admins run it from their own workstation rather than RDPing into the server just to manage the database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What if I can&#8217;t connect after installing?<\/strong> Check that SQL Server is configured to accept remote connections (if connecting from off-server) and that the Windows Firewall allows traffic on the SQL Server port.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Related Articles<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/set-static-ip-address-centos7-minimal-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Configure a Static IP Address on CentOS7<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/install-phpmyadmin-ubuntu\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Install phpMyAdmin on Ubuntu<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Talk to our experts.<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Looking for the right technology solution for your business? Our team of experts can help you with development, cloud, DevOps, design, and a wide range of other technology needs. Get in touch with our team <a href=\"https:\/\/pheonixsolutions.com\/contact\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction This guide covers how to install SQL Server Management Studio (SSMS) on a Windows server running Plesk, so you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1019],"tags":[381,384],"class_list":["post-2106","post","type-post","status-publish","format-standard","hentry","category-cloud-aws","tag-mssql","tag-windowsserver","psol-cat-cloud-aws"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-xY","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=2106"}],"version-history":[{"count":1,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2106\/revisions"}],"predecessor-version":[{"id":11734,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2106\/revisions\/11734"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=2106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=2106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=2106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}