{"id":621,"date":"2024-06-21T18:17:26","date_gmt":"2024-06-21T18:17:26","guid":{"rendered":"https:\/\/vpswebhostingindia.in\/blog\/?p=621"},"modified":"2024-06-21T18:23:40","modified_gmt":"2024-06-21T18:23:40","slug":"how-to-installing-ms-sql-server-management-studio","status":"publish","type":"post","link":"https:\/\/vpswebhostingindia.in\/blog\/how-to-installing-ms-sql-server-management-studio\/","title":{"rendered":"How to Install Microsoft SQL Server Management Studio (SSMS)"},"content":{"rendered":"\n<p>SQL Server Management Studio (SSMS) is a free integrated tool that allows you to access, configure, manage and administer all components of the SQL server, Azure SQL Database, Azure SQL Managed Instance and Azure Synapse Analytics.&nbsp;&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-an-sql-server-management-studio\">What Is an SQL Server Management Studio?<\/h2>\n\n\n\n<p>MS SQL Server Management Studio is a workstation or a client tool which is used to connect to and manage your SQL Server<\/p>\n\n\n\n<p>SQL Server Management Studio (SSMS) is a <strong>windows software, or a client tool<\/strong> used to connect and work with our SQL Server from a <strong>graphical interface<\/strong> instead of using the command line. Microsoft SQL Server 2005 launched the management studio to work with SQL Server and Azure SQL databases.<\/p>\n\n\n\n<p>It allows DBAs and database developers to <strong>configure, manage<\/strong>, and <strong>administer<\/strong> all components within SQL Server. Its main functionality is to create databases and tables, execute SQL queries for inserting, updating, and deleting data, creating and managing stored procedures, triggers, views, and cursors. It also enables us to set privileges (securities) on databases and their objects.<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#what-is-an-sql-server-management-studio\">What Is an SQL Server Management Studio?<\/a><\/li><li><a href=\"#download-install-the-free-app-microsoft-sql-server-management-studio\">Download &amp; Install the Free App: Microsoft SQL Server Management Studio<\/a><ul><\/ul><\/li><\/ul><\/nav><\/div>\n\n\n\n<p>SSMS also includes tools for deployment, database health monitoring, and reporting. It includes <strong>SQL Profiler<\/strong>, which allows us to examine the performance of our SQL databases. It&#8217;s also possible to use it to schedule background work. If we want to connect to a remote SQL Server instance, we&#8217;ll need this GUI tool or similar software. It is used by Administrators, Developers, Testers, etc. The latest version of SQL <a href=\"https:\/\/vpswebhostingindia.in\/vps_hosting\/\">Server<\/a> Management Studio is <strong>SSMS 18.8 RC<\/strong>. If we have installed a previous version, we just need to install <strong>SSMS 18.8 upgrades<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"download-install-the-free-app-microsoft-sql-server-management-studio\">Download &amp; Install the Free App: Microsoft SQL Server Management Studio<\/h2>\n\n\n\n<p>Download <a href=\"https:\/\/www.microsoft.com\/en-us\/Download\/confirmation.aspx?id=101064\" rel=\"nofollow noopener\" target=\"_blank\">SQL 2019 Express<\/a> from Microsoft<\/p>\n\n\n\n<p>Double click the file to launch the installer<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"990\" height=\"401\" src=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-6.png\" alt=\"SQL Server Express\" class=\"wp-image-614\" srcset=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-6.png 990w, https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-6-300x122.png 300w, https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-6-768x311.png 768w\" sizes=\"auto, (max-width: 990px) 100vw, 990px\" \/><\/figure>\n\n\n\n<p>Select the Custom tile<\/p>\n\n\n\n<p>Select Install<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\ufffc\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"365\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture3_5.png\" width=\"464\"><\/h3>\n\n\n\n<p>The installation process will starts<\/p>\n\n\n\n<p><br><img loading=\"lazy\" decoding=\"async\" height=\"331\" width=\"569\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture4_4.png\" alt=\"\"><\/p>\n\n\n\n<p>Select Install SQL Server Management Tools<\/p>\n\n\n\n<p><br><img loading=\"lazy\" decoding=\"async\" height=\"335\" width=\"562\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture20_1.png\" alt=\"\"><\/p>\n\n\n\n<p>The installer will direct you to Download SQL Server Management Studio (SSMS) &#8211; SQL Server Management Studio (SSMS) | Microsoft Docs<br><br>Scroll to the section called Download SSMS then select the Free Download for SQL Server Management Studio (SSMS) 18.x.x<br><br><img loading=\"lazy\" decoding=\"async\" height=\"185\" width=\"624\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture21_1.png\" alt=\"\"><br><br>The download process will begin<br><br><img loading=\"lazy\" decoding=\"async\" height=\"262\" width=\"435\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture22_1.png\" alt=\"\"><br><br>Double click the SSMS-Setup installer<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"852\" height=\"529\" src=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-7.png\" alt=\"SQL Server Management Studio\" class=\"wp-image-622\" srcset=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-7.png 852w, https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-7-300x186.png 300w, https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-7-768x477.png 768w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><\/figure>\n\n\n\n<p><br>Select Install<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"442\" src=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-9.png\" alt=\"\" class=\"wp-image-624\" srcset=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-9.png 616w, https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-9-300x215.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure>\n\n\n\n<p>The installation will begin<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"560\" src=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-8.png\" alt=\"\" class=\"wp-image-623\" srcset=\"https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-8.png 662w, https:\/\/vpswebhostingindia.in\/blog\/wp-content\/uploads\/2024\/06\/image-8-300x254.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><\/figure>\n\n\n\n<p><br><br><br>Restart is required to complete the setup<br><br><img loading=\"lazy\" decoding=\"async\" height=\"471\" width=\"565\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture26_0.png\" alt=\"\"><br><br><br><strong>Step Three: Configure SQL Server 2019 Configuration Manager<\/strong><br><br>In the Start Menu locate SQL Server 2019 Configuration Manger<br><br><img loading=\"lazy\" decoding=\"async\" height=\"564\" width=\"469\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture27_0.png\" alt=\"\"><br><br>Expand SQL Native Client 11.0 Configuration, SQL Server Network Configuration and SQL Native Client 11.0 Configuration<br><br><img loading=\"lazy\" decoding=\"async\" height=\"285\" width=\"510\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture28_0.png\" alt=\"\"><br><br>If not enabled, enable TCP\/IP and Named Pipes by right clicking on either TCP\/IP or Named Pipes followed by OK<br><br><img loading=\"lazy\" decoding=\"async\" height=\"250\" width=\"510\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture29_0.png\" alt=\"\"><br><br><img loading=\"lazy\" decoding=\"async\" height=\"227\" width=\"514\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture30_0.png\" alt=\"\"><br><br><img loading=\"lazy\" decoding=\"async\" height=\"261\" width=\"517\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture31_0.png\" alt=\"\"><br><br><img loading=\"lazy\" decoding=\"async\" height=\"230\" width=\"516\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture32_0.png\" alt=\"\"><br><br>Select SQL Server Services<br><br><img loading=\"lazy\" decoding=\"async\" height=\"108\" width=\"624\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture33_0.png\" alt=\"\"><br><br>Right click on SQL Server Browser and restart<br><br><img loading=\"lazy\" decoding=\"async\" height=\"293\" width=\"610\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture34_0.png\" alt=\"\"><br><br>Right click on SQL Server and restart<br><br><img loading=\"lazy\" decoding=\"async\" height=\"295\" width=\"624\" src=\"https:\/\/kb.communitybrands.com\/sites\/kb\/files\/picture36_0.png\" alt=\"\"><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server Management Studio (SSMS) is a free integrated tool that allows you to access, configure, manage and administer all components of the SQL server, Azure SQL Database, Azure SQL Managed Instance and Azure Synapse Analytics.&nbsp;&nbsp; What Is an SQL Server Management Studio? MS SQL Server Management Studio is a workstation or a client tool [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":628,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"_eb_attr":"","footnotes":""},"categories":[9,49],"tags":[],"class_list":["post-621","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-sql","category-sql-server-express"],"_links":{"self":[{"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/posts\/621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/comments?post=621"}],"version-history":[{"count":2,"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/posts\/621\/revisions"}],"predecessor-version":[{"id":629,"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/posts\/621\/revisions\/629"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/media\/628"}],"wp:attachment":[{"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/media?parent=621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/categories?post=621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vpswebhostingindia.in\/blog\/wp-json\/wp\/v2\/tags?post=621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}