{"id":30228,"date":"2022-06-11T13:55:09","date_gmt":"2022-06-11T13:55:09","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=30228"},"modified":"2022-12-23T05:52:48","modified_gmt":"2022-12-23T05:52:48","slug":"how-to-install-mssql-in-centos-7","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-install-mssql-in-centos-7\/","title":{"rendered":"How to install MSSQL in CENTOS 7?"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Step 1 &#8211; Install SQL Server<\/h2>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">sudo alternatives --config python\r\n<span class=\"hljs-comment\"># If not configured, install python2 and openssl10 using the following commands: <\/span>\r\nsudo yum install python2\r\nsudo yum install compat-openssl10\r\n<span class=\"hljs-comment\"># Configure python2 as the default interpreter using this command: <\/span>\r\nsudo alternatives --config python\r\n\r\n<span class=\"hljs-comment\"># Download the Microsoft SQL Server 2019 Red Hat repository configuration file:<\/span>\r\n$ sudo curl -o \/etc\/yum.repos.d\/mssql-server.repo https:<span class=\"hljs-comment\">\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server-2019.repo<\/span>\r\n\r\n<span class=\"hljs-comment\"># Run the following commands to install SQL Server:<\/span>\r\n$ sudo yum install -y mssql-server\r\n\r\n<span class=\"hljs-comment\"># After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.<\/span>\r\n$ sudo \/opt\/mssql\/bin\/mssql-conf setup\r\n\r\n<span class=\"hljs-comment\"># Once the configuration is done, verify that the service is running:<\/span>\r\nsystemctl status mssql-server\r\n\r\n<span class=\"hljs-comment\"># To allow remote connections, open the SQL Server port on the firewall on RHEL. The default SQL Server port is TCP 1433. If you're using FirewallD for your firewall, you can use the following commands:<\/span>\r\nsudo firewall-cmd --zone=<span class=\"hljs-keyword\">public<\/span> --add-port=<span class=\"hljs-number\">1433<\/span>\/tcp --permanent\r\nsudo firewall-cmd --reload\r\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2 &#8211; Install the SQL Server command-line tools<\/h2>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># Download the Microsoft Red Hat repository configuration file.<\/span>\r\nsudo curl -o \/etc\/yum.repos.d\/msprod.repo https:<span class=\"hljs-comment\">\/\/packages.microsoft.com\/config\/rhel\/7\/prod.repo<\/span>\r\n\r\n<span class=\"hljs-comment\"># If you had a previous version of mssql-tools installed, remove any older unixODBC packages.<\/span>\r\n$ sudo yum remove unixODBC-utf16 unixODBC-utf16-devel\r\n\r\n<span class=\"hljs-comment\"># Run the following commands to install mssql-tools with the unixODBC developer package. <\/span>\r\n$ sudo yum install -y mssql-tools unixODBC-devel\r\n\r\n<span class=\"hljs-comment\"># For convenience, add \/opt\/mssql-tools\/bin\/ to your PATH environment variable. <\/span>\r\n$ <span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">'export PATH=\"$PATH:\/opt\/mssql-tools\/bin\"'<\/span> &gt;&gt; ~\/.bash_profile\r\n$ <span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">'export PATH=\"$PATH:\/opt\/mssql-tools\/bin\"'<\/span> &gt;&gt; ~\/.bashrc\r\n$ source ~\/.bashrc\r\n\r\n<span class=\"hljs-comment\"># Connect locally<\/span>\r\nsqlcmd -S localhost -U SA -P <span class=\"hljs-string\">'&lt;YourPassword&gt;'<\/span>\r\n\r\n<span class=\"hljs-comment\"># Connect remote - If you later decide to connect remotely, specify the machine name or IP address for the -S parameter, and make sure port 1433 is open on your firewall.<\/span>\r\n$ sqlcmd -S ip -U SA -P <span class=\"hljs-string\">'&lt;YourPassword&gt;'<\/span>\r\n\r\n<span class=\"hljs-keyword\">If<\/span> successful, you should get to a sqlcmd command prompt: <span class=\"hljs-number\">1<\/span>&gt;.\r\n\r\n$ sqlcmd -S ip -U SA -P <span class=\"hljs-string\">'&lt;YourPassword&gt;'<\/span>  -Q <span class=\"hljs-string\">\"cmdline query\"<\/span> <span class=\"hljs-keyword\">and<\/span> <span class=\"hljs-keyword\">exit<\/span>\r\n\r\nsqlcmd -S localhost -U SA -P <span class=\"hljs-string\">'Rajesh123'<\/span> -Q <span class=\"hljs-string\">\"sp_databases\"<\/span> &gt;&gt; output.log\r\ngrep <span class=\"hljs-string\">\"master\"<\/span> output.log\r\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Step 1 &#8211; Install SQL Server Step 2 &#8211; Install the SQL Server command-line tools<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-30228","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/30228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=30228"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/30228\/revisions"}],"predecessor-version":[{"id":30229,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/30228\/revisions\/30229"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=30228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=30228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=30228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}