{"id":2855,"date":"2025-12-21T12:24:48","date_gmt":"2023-08-03T07:36:37","guid":{"rendered":""},"modified":"2025-02-02T00:46:19","modified_gmt":"2025-02-01T23:46:19","slug":"how-to-install-and-use-ms-sql-server-on-rocky-linux","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-and-use-ms-sql-server-on-rocky-linux\/","title":{"rendered":"Linux VPS &#038; VPS Windows Setup Guide | NetCloud24 and Use MS SQL Server on Rocky Linux"},"content":{"rendered":"<p>\u00a0<\/p>\n<\/p>\n<header>\n<h1>\u00a0<\/h1>\n<\/header>\n<article>\n<section>\n<h2>Introduction<\/h2>\n<p>Microsoft SQL Server is a powerful relational database management system (RDBMS) that provides a range of tools for managing and analyzing data. This guide will help you install and configure MS SQL Server on Rocky Linux, which can be effectively hosted on a  for optimal performance and reliability.<\/p>\n<\/section>\n<section>\n<h2>Prerequisites<\/h2>\n<ul>\n<li>A Rocky Linux server with root access<\/li>\n<li>Basic knowledge of Linux commands<\/li>\n<li>An active internet connection<\/li>\n<\/ul>\n<\/section>\n<section>\n<h2>Step 1: Update Your System<\/h2>\n<p>Start by updating your package index and upgrading existing packages:<\/p>\n<pre><code>sudo dnf update -y<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 2: Import the Microsoft Repository GPG Key<\/h2>\n<p>Import the GPG key to ensure the integrity of the packages:<\/p>\n<pre><code>sudo rpm --import https:\/\/packages.microsoft.com\/keys\/microsoft.asc<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 3: Register the Microsoft SQL Server Repository<\/h2>\n<p>Run the following command to add the Microsoft SQL Server repository:<\/p>\n<pre><code>sudo curl https:\/\/packages.microsoft.com\/config\/rhel\/9\/mssql-server-2019.repo -o \/etc\/yum.repos.d\/mssql-server.repo<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 4: Install MS SQL Server<\/h2>\n<p>Now install MS SQL Server using the following command:<\/p>\n<pre><code>sudo dnf install -y mssql-server<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 5: Configure MS SQL Server<\/h2>\n<p>Run the configuration script to set up your SQL Server instance:<\/p>\n<pre><code>sudo \/opt\/mssql\/bin\/mssql-conf setup<\/code><\/pre>\n<p>Follow the prompts to select your edition, set the SA password, and configure other options.<\/p>\n<\/section>\n<section>\n<h2>Step 6: Enable and Start the SQL Server Service<\/h2>\n<p>Enable and start the SQL Server service with the following commands:<\/p>\n<pre><code>sudo systemctl enable mssql-server\r\nsudo systemctl start mssql-server<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 7: Install SQL Server Command-Line Tools<\/h2>\n<p>To manage your SQL Server instance, install the command-line tools:<\/p>\n<pre><code>sudo curl https:\/\/packages.microsoft.com\/config\/rhel\/9\/prod.repo -o \/etc\/yum.repos.d\/mssql-tools.repo\r\nsudo dnf install -y mssql-tools unixODBC-devel<\/code><\/pre>\n<p>Add the tools to your PATH for easy access:<\/p>\n<pre><code>echo 'export PATH=\"$PATH:\/opt\/mssql-tools\/bin\"' &gt;&gt; ~\/.bash_profile\r\nsource ~\/.bash_profile<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 8: Connect to MS SQL Server<\/h2>\n<p>You can now connect to your SQL Server instance using the command-line tools:<\/p>\n<pre><code>sqlcmd -S localhost -U SA -P 'YourPassword'<\/code><\/pre>\n<p>Replace <code>YourPassword<\/code> with the SA password you set during configuration.<\/p>\n<\/section>\n<section>\n<h2>Step 9: Conclusion<\/h2>\n<p>You have successfully installed and configured MS SQL Server on Rocky Linux. This robust database management system can significantly benefit from being hosted on a . For additional options, explore various  solutions, including <a href=\"https:\/\/ie.netcloud24.com\">Windows VPSVirtual Private Server Hosting<\/a> and <a href=\"https:\/\/ie.netcloud24.com\">Windows VPS Hosting UK<\/a> for optimal performance and security.<\/p>\n<\/section>\n<\/article>\n<footer>\n<p>\u00a9 2024 MS SQL Server Installation Tutorial. All rights reserved.<\/p>\n<\/footer>\n<div class=\"post-author-box\" style=\"border-top:1px solid #ddd;margin-top:20px;padding-top:15px;\">\n<p><strong>Author:<\/strong> \u0141ukasz Bodziony<\/p>\n<p><strong>Website:<\/strong> <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a><\/p>\n<p><em>\u0141ukasz Bodziony is the CEO and founder of <a href=\"https:\/\/netcloud24.com\" target=\"_blank\" rel=\"dofollow\">NETCLOUD24<\/a>, a global VPS hosting brand proudly originating from Poland. With extensive experience in cloud computing, virtualization, and server management, he delivers high-performance <strong>Windows VPS<\/strong> and <strong>Remote Desktop Services (RDS)<\/strong> solutions to clients across Europe, North America, and beyond.<\/em><\/p>\n<p><em>His expertise covers a wide range of technologies, including <strong>Microsoft Azure<\/strong>, <strong>Proxmox VE<\/strong>, <strong>Amazon Web Services (AWS)<\/strong>, and numerous other virtualization and cloud platforms.<\/em><\/p>\n<p><em>Beyond running his hosting business, \u0141ukasz also provides <strong>professional paid server configuration and optimization services<\/strong> for companies and individuals. Outside of work, he is dedicated to caring for his children and building a secure future for them.<\/em><\/p>\n<p><em>If you are interested in working with him or need expert assistance with your hosting, cloud environment, or server setup, feel free to reach out via <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a>.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0 Introduction Microsoft SQL Server is a powerful relational database management system (RDBMS) that provides a range of tools for managing and analyzing data. This guide will\u2026<\/p>\n","protected":false},"author":1,"featured_media":3421,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","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}},"categories":[],"tags":[14,12,11,23,20,21,22,17,7,8,6,10,18,19,15,24,16,5,13,9],"class_list":["post-2855","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-cheapvps","tag-cloudvps","tag-hostingvps","tag-rds","tag-rdscal","tag-remotedesktop","tag-remotedesktopvps","tag-servervps","tag-ukvps","tag-virtualserver","tag-vpshosting","tag-vpsserver","tag-vpssolutions","tag-vpswindows","tag-vpswithwindows","tag-windowsrds","tag-windowsserver","tag-windowsvps","tag-windowsvpshosting","tag-windowsvpsuk"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=2855"}],"version-history":[{"count":0,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2855\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media\/3421"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=2855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=2855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=2855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}