{"id":8564,"date":"2020-11-07T09:24:58","date_gmt":"2020-11-07T09:24:58","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=8564"},"modified":"2024-04-24T07:50:38","modified_gmt":"2024-04-24T06:50:38","slug":"how-to-connect-your-database-remotely-through-sql-management-studio","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/","title":{"rendered":"How to Connect your Database Remotely through SQL Management Studio?"},"content":{"rendered":"<p><strong><span data-preserver-spaces=\"true\">Steps to connect your database remotely through SQL Management Studio:<\/span><\/strong><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Open\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Microsoft SQL Server Management Studio.\u00a0<\/span><\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12007\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png\" alt=\"\" width=\"1599\" height=\"899\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png 1599w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open-300x169.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open-768x432.png 768w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open-1024x576.png 1024w\" sizes=\"auto, (max-width: 1599px) 100vw, 1599px\" \/><\/p>\n<ul>\n<li><strong><span data-preserver-spaces=\"true\">Connect to Server<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0dialog box appears on the screen.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12006\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio.png\" alt=\"\" width=\"1599\" height=\"860\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio.png 1599w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio-300x161.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio-768x413.png 768w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio-1024x551.png 1024w\" sizes=\"auto, (max-width: 1599px) 100vw, 1599px\" \/><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">In the\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Server type<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0list box, select\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Database Engine<\/span><\/strong><span data-preserver-spaces=\"true\">.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">In the\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Server name<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0text box, enter the name of the server or IP address.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">In the\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Authentication<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0list box, select\u00a0<\/span><strong><span data-preserver-spaces=\"true\">SQL Server Authentication.\u00a0<\/span><\/strong><\/li>\n<li><span data-preserver-spaces=\"true\">In the\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Login<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0text box, type the Microsoft SQL database username.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">In the\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Password<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0text box, enter the password.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">If you do not want to re-enter the password every time you connect to the server then, select the\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Remember password<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0check box.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Now, click on\u00a0<\/span><strong><span data-preserver-spaces=\"true\">Connect<\/span><\/strong><span data-preserver-spaces=\"true\">.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12009\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connect-min.jpg\" alt=\"\" width=\"479\" height=\"317\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connect-min.jpg 479w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connect-min-300x199.jpg 300w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">You will see the database in the object explorer window.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12010\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connected_censored.jpg\" alt=\"\" width=\"1599\" height=\"564\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connected_censored.jpg 1599w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connected_censored-300x106.jpg 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connected_censored-768x271.jpg 768w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_connected_censored-1024x361.jpg 1024w\" sizes=\"auto, (max-width: 1599px) 100vw, 1599px\" \/><\/p>\n<p><span data-preserver-spaces=\"true\">That&#8217;s how you can connect to the database remotely through the SQL management studio.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steps to connect your database remotely through SQL Management Studio: Open\u00a0Microsoft SQL Server Management Studio.\u00a0 Connect to Server\u00a0dialog box appears on the screen. In the\u00a0Server type\u00a0list box, select\u00a0Database Engine. In the\u00a0Server name\u00a0text box, enter the name of the server or IP address. In the\u00a0Authentication\u00a0list box, select\u00a0SQL Server Authentication.\u00a0 In the\u00a0Login\u00a0text box, type the Microsoft SQL [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230],"tags":[],"class_list":["post-8564","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Connect your Database Remotely through SQL Management Studio?<\/title>\n<meta name=\"description\" content=\"Within a few clicks and following some steps you can easily connect your database remotely through SQL Management Studio.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect your Database Remotely through SQL Management Studio?\" \/>\n<meta property=\"og:description\" content=\"Within a few clicks and following some steps you can easily connect your database remotely through SQL Management Studio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-07T09:24:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T06:50:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png\" \/>\n<meta name=\"author\" content=\"Gandhar Kulkarni\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gandhar Kulkarni\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/\",\"name\":\"How to Connect your Database Remotely through SQL Management Studio?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png\",\"datePublished\":\"2020-11-07T09:24:58+00:00\",\"dateModified\":\"2024-04-24T06:50:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22\"},\"description\":\"Within a few clicks and following some steps you can easily connect your database remotely through SQL Management Studio.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png\",\"width\":1599,\"height\":899},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect your Database Remotely through SQL Management Studio?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22\",\"name\":\"Gandhar Kulkarni\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g\",\"caption\":\"Gandhar Kulkarni\"},\"description\":\"Gandhar is a marketing professional at MilesWeb. He is passionate about exploring and writing technical articles related to web hosting and digital marketing. Also, he has over four years of experience in digital marketing. Besides content writing, he tries to engage an online audience through YouTube video tutorials and social media activities.\",\"sameAs\":[\"https:\/\/www.milesweb.co.uk\"],\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/gandhar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect your Database Remotely through SQL Management Studio?","description":"Within a few clicks and following some steps you can easily connect your database remotely through SQL Management Studio.","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:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/","og_locale":"en_GB","og_type":"article","og_title":"How to Connect your Database Remotely through SQL Management Studio?","og_description":"Within a few clicks and following some steps you can easily connect your database remotely through SQL Management Studio.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-11-07T09:24:58+00:00","article_modified_time":"2024-04-24T06:50:38+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png","type":"","width":"","height":""}],"author":"Gandhar Kulkarni","twitter_misc":{"Written by":"Gandhar Kulkarni","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/","name":"How to Connect your Database Remotely through SQL Management Studio?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png","datePublished":"2020-11-07T09:24:58+00:00","dateModified":"2024-04-24T06:50:38+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22"},"description":"Within a few clicks and following some steps you can easily connect your database remotely through SQL Management Studio.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/11\/sql_server_management_studio_open.png","width":1599,"height":899},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-connect-your-database-remotely-through-sql-management-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Connect your Database Remotely through SQL Management Studio?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/88ac09123c3123e4375c7f7ea6fb0a22","name":"Gandhar Kulkarni","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b73c712f8d261f04bab6b0d466a2164e?s=96&d=blank&r=g","caption":"Gandhar Kulkarni"},"description":"Gandhar is a marketing professional at MilesWeb. He is passionate about exploring and writing technical articles related to web hosting and digital marketing. Also, he has over four years of experience in digital marketing. Besides content writing, he tries to engage an online audience through YouTube video tutorials and social media activities.","sameAs":["https:\/\/www.milesweb.co.uk"],"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/gandhar\/"}]}},"views":515,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=8564"}],"version-history":[{"count":10,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8564\/revisions"}],"predecessor-version":[{"id":15619,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8564\/revisions\/15619"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=8564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=8564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=8564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}