{"id":2025,"date":"2021-09-20T10:11:26","date_gmt":"2021-09-20T10:11:26","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2025"},"modified":"2021-09-20T10:11:26","modified_gmt":"2021-09-20T10:11:26","slug":"how-to-enable-mssql-support-on-linux-server","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/","title":{"rendered":"How to Enable mssql support on Linux server"},"content":{"rendered":"<p>The answer to the above question is you need to first compile freetds and then compile PHP with freetds support.<\/p>\n<p>But\u00a0<strong>what is FreeTDS?<\/strong><br \/>\nFreeTDS is a free implementation of the TDS (Tabular Data Stream) protocol that is used by Sybase and Microsoft for their database products. It implements different version os TDS which includes TDS 4.2, 5.0, 7.0 and 8.0, and can communicate with any Sybase or Microsoft SQL Server. FreeTDS generally comes with a low level library (the TDS layer) along with a number of APIs (Application Programming Interfaces). The APIs are DB-Lib, CT-Lib, and ODBC.<br \/>\nYou can install freetds by using yum.<\/p>\n<p>yum install freetds<\/p>\n<p>After that you need to recompile the php with mssql support<\/p>\n<p>check the php version on the server and then download the same php version file<\/p>\n<p>for example php 5.3.2.<br \/>\nYou can downlad php version by using this URL\u00a0<strong>http:\/\/us3.php.net\/downloads.php<\/strong><\/p>\n<p><strong>cd \/usr\/local\/src<\/strong><\/p>\n<p><strong>wget http:\/\/us3.php.net\/get\/php-5.3.2.tar.bz2\/from\/in.php.net\/mirror<\/strong><\/p>\n<p><strong>tar -xzvf php-5.3.2.tar.bz2<\/strong><\/p>\n<p><strong>cd php-5.3.2\/ext\/mssql<\/strong><\/p>\n<p><strong>phpize<\/strong><\/p>\n<p><strong>.\/configure \u2013with-mssql<\/strong><\/p>\n<p>make<br \/>\nmake install<\/p>\n<p>Next look for the mssql.so file and make sure it is in the module directory specified in your php.ini. Copy it to the specified location if needed.<\/p>\n<p><strong>php -i | grep php.ini<\/strong><\/p>\n<p><strong>vi \/usr\/local\/lib\/php.ini<\/strong><\/p>\n<p><strong>Add this line to your php.ini:<\/strong><\/p>\n<p><strong>extension=mssql.so<\/strong><\/p>\n<p>Save the php.ini and restart Apache:<\/p>\n<p><strong>\/etc\/init.d\/httpd restart<\/strong><\/p>\n<p>To install Enable mssql support on\u00a0Linux server\u00a0you need a good tech support people from web host.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The answer to the above question is you need to first compile freetds and then compile PHP with freetds support. But\u00a0what is FreeTDS? FreeTDS is a free implementation of the TDS (Tabular Data Stream) protocol that is used by Sybase and Microsoft for their database products. It implements different version os TDS which includes TDS [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-2025","post","type-post","status-publish","format-standard","hentry","category-linux-servers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Enable mssql support on Linux server - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Enable mssql support on Linux server - OWS KB\" \/>\n<meta property=\"og:description\" content=\"The answer to the above question is you need to first compile freetds and then compile PHP with freetds support. But\u00a0what is FreeTDS? FreeTDS is a free implementation of the TDS (Tabular Data Stream) protocol that is used by Sybase and Microsoft for their database products. It implements different version os TDS which includes TDS [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-20T10:11:26+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/\",\"name\":\"How to Enable mssql support on Linux server - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"datePublished\":\"2021-09-20T10:11:26+00:00\",\"dateModified\":\"2021-09-20T10:11:26+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mssql-support-on-linux-server\/\",\"name\":\"How to Enable mssql support on Linux server\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=2025"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2025\/revisions"}],"predecessor-version":[{"id":2026,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2025\/revisions\/2026"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}