{"id":5700,"date":"2020-06-06T10:32:51","date_gmt":"2020-06-06T10:32:51","guid":{"rendered":"https:\/\/truehost.co.ke\/support\/?post_type=ht_kb&#038;p=5700"},"modified":"2024-06-07T13:03:35","modified_gmt":"2024-06-07T13:03:35","password":"","slug":"how-to-connect-remotely-to-mssql-database","status":"publish","type":"docs","link":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/","title":{"rendered":"How to Connect Remotely to MSSQL Database"},"content":{"rendered":"\n<p>To connect to the SQL server successfully, please use the details below. Note that, you need to change the <strong>HOSTNAME<\/strong> of your server to either lim202.truehost.cloud or hnk201.truehost.cloud depending on which server you belong.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">FOR SQL SERVER 2019<\/h2>\n\n\n\n<p>Server Type: <strong>Database Engine<\/strong><br>Server name: <strong>HOSTNAME,1435 <\/strong>(change to your server hostname as provided on the Account details)<br>Authentication:<strong> SQL Server Authentication<\/strong><br>User name: <strong>Your database username<\/strong><br>Password: <strong>Password for User name above<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">FOR SQL SERVER 2017<\/h2>\n\n\n\n<p>Server Type: <strong>Database Engine<\/strong><br>Server name: <strong>HOSTNAME,1434<\/strong> (change to your server hostname as provided on the Account details)<br>Authentication:<strong> SQL Server Authentication<\/strong><br>User name: <strong>Your database username<\/strong><br>Password: <strong>Password for User name above<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">FOR SQL SERVER 2012<\/h2>\n\n\n\n<p>Server Type: <strong>Database Engine<\/strong><br>Server name: <strong>HOSTNAME,1433<\/strong> (change to your server hostname as provided on the Account details)<br>Authentication: <strong>SQL Server Authentication<\/strong><br>User name: <strong>Your database username<\/strong><br>Password: <strong>Password for User name above<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To connect to the SQL server successfully, please use the details below. Note that, you need to change the HOSTNAME of your server to either lim202.truehost.cloud or hnk201.truehost.cloud depending on which server you belong. FOR SQL SERVER 2019 Server Type: Database EngineServer name: HOSTNAME,1435 (change to your server hostname as provided on the Account details)Authentication: [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_category":[],"doc_tag":[],"class_list":["post-5700","docs","type-docs","status-publish","hentry"],"year_month":"2026-06","word_count":137,"total_views":"0","reactions":{"happy":"0","normal":"0","sad":"1"},"author_info":{"name":"w m","author_nicename":"wm","author_url":"https:\/\/truehost.com\/support\/author\/wm\/"},"doc_category_info":[],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Connect Remotely to MSSQL Database -<\/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:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect Remotely to MSSQL Database -\" \/>\n<meta property=\"og:description\" content=\"To connect to the SQL server successfully, please use the details below. Note that, you need to change the HOSTNAME of your server to either lim202.truehost.cloud or hnk201.truehost.cloud depending on which server you belong. FOR SQL SERVER 2019 Server Type: Database EngineServer name: HOSTNAME,1435 (change to your server hostname as provided on the Account details)Authentication: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T13:03:35+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-connect-remotely-to-mssql-database\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-connect-remotely-to-mssql-database\\\/\",\"name\":\"How to Connect Remotely to MSSQL Database -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\"},\"datePublished\":\"2020-06-06T10:32:51+00:00\",\"dateModified\":\"2024-06-07T13:03:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-connect-remotely-to-mssql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-connect-remotely-to-mssql-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-connect-remotely-to-mssql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect Remotely to MSSQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"name\":\"\",\"description\":\"Help In a Click\",\"publisher\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truehost.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\",\"name\":\"Truehost Kenya\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"width\":240,\"height\":48,\"caption\":\"Truehost Kenya\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect Remotely to MSSQL Database -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect Remotely to MSSQL Database -","og_description":"To connect to the SQL server successfully, please use the details below. Note that, you need to change the HOSTNAME of your server to either lim202.truehost.cloud or hnk201.truehost.cloud depending on which server you belong. FOR SQL SERVER 2019 Server Type: Database EngineServer name: HOSTNAME,1435 (change to your server hostname as provided on the Account details)Authentication: [&hellip;]","og_url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/","article_modified_time":"2024-06-07T13:03:35+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/","url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/","name":"How to Connect Remotely to MSSQL Database -","isPartOf":{"@id":"https:\/\/truehost.com\/support\/#website"},"datePublished":"2020-06-06T10:32:51+00:00","dateModified":"2024-06-07T13:03:35+00:00","breadcrumb":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Connect Remotely to MSSQL Database"}]},{"@type":"WebSite","@id":"https:\/\/truehost.com\/support\/#website","url":"https:\/\/truehost.com\/support\/","name":"","description":"Help In a Click","publisher":{"@id":"https:\/\/truehost.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truehost.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/truehost.com\/support\/#organization","name":"Truehost Kenya","url":"https:\/\/truehost.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","width":240,"height":48,"caption":"Truehost Kenya"},"image":{"@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/5700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/comments?post=5700"}],"version-history":[{"count":4,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/5700\/revisions"}],"predecessor-version":[{"id":7658,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/5700\/revisions\/7658"}],"wp:attachment":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/media?parent=5700"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_category?post=5700"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_tag?post=5700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}