{"id":141,"date":"2014-06-28T10:47:45","date_gmt":"2014-06-28T13:47:45","guid":{"rendered":"https:\/\/maurobernal.com.ar\/blog\/?p=141"},"modified":"2020-09-15T23:00:51","modified_gmt":"2020-09-16T02:00:51","slug":"como-especificar-el-puerto-en-el-sql-server-management-studio","status":"publish","type":"post","link":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/","title":{"rendered":"Como especificar el Puerto en el SQL Server Management Studio"},"content":{"rendered":"\n<p>\u00daltimamente por seguridad he estado migrando el puerto default del MS SQL Server de 1433 a otro diferente. Y en consecuencia m\u00e1s de uno me pregunto como usar el IDE de Microsoft para conectarse luego de este cambio. Si quieres saber como cambiar el puerto en el que corre tu motor SQL mir\u00e1 este post (<a href=\"https:\/\/maurobernal.com.ar\/blog\/blog\/mssql\/cambiar-el-puerto-del-ms-sql-server\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/maurobernal.com.ar\/blog\/blog\/mssql\/cambiar-el-puerto-del-ms-sql-server<\/a>)<\/p>\n\n\n\n<p> Aqu\u00ed te cuento como cambiar el puerto de la conexi\u00f3n.<\/p>\n\n\n<p>Si tienen configurado el motor <strong>SQL Server<\/strong> en un puerto diferente al predeterminado (1433), para poder realizar una conexi\u00f3n desde el <strong>SQL Server Management Studio<\/strong> se debe ingresar de la siguiente manera:<\/p>\n<p><strong>[HOST] , [PUERTO]<br \/><\/strong><\/p>\n<p>Es decir que separamos el mismo con una coma (,).<\/p>\n<p><span style=\"text-decoration: underline;\">Ejemplo:<br \/><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif1.png?ssl=1\" alt=\"\" \/><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif2.png?ssl=1\" alt=\"\" \/><br \/><\/span><\/p>\n<p>Si llegaste hasta aqu\u00ed pero no sabes como se puede volver a cambiar el mismo, mir\u00e1 este post: (<a href=\"https:\/\/maurobernal.com.ar\/blog\/blog\/mssql\/cambiar-el-puerto-del-ms-sql-server\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/maurobernal.com.ar\/blog\/blog\/mssql\/cambiar-el-puerto-del-ms-sql-server<\/a>)<\/p>\n<p><!-- \/wp:post-content --><\/p>\n\n<!-- wp:paragraph -->\n<p><\/p>\n<!-- \/wp:paragraph -->","protected":false},"excerpt":{"rendered":"<p>\u00daltimamente por seguridad he estado migrando el puerto default del MS SQL Server de 1433 a otro diferente. Y en consecuencia m\u00e1s de uno me pregunto como usar el IDE&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[16],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-mssql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Como especificar el Puerto en el SQL Server Management Studio &#183; devops Mauro Bernal<\/title>\n<meta name=\"description\" content=\"Como especificar el Puerto en el SQL Server 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:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como especificar el Puerto en el SQL Server Management Studio &#183; devops Mauro Bernal\" \/>\n<meta property=\"og:description\" content=\"Como especificar el Puerto en el SQL Server Management Studio\" \/>\n<meta property=\"og:url\" content=\"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"devops Mauro Bernal\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-28T13:47:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-09-16T02:00:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif1.png\" \/>\n<meta name=\"author\" content=\"Mauro Bernal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:site\" content=\"@_maurobernal\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mauro Bernal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/\"},\"author\":{\"name\":\"Mauro Bernal\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"headline\":\"Como especificar el Puerto en el SQL Server Management Studio\",\"datePublished\":\"2014-06-28T13:47:45+00:00\",\"dateModified\":\"2020-09-16T02:00:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/\"},\"wordCount\":154,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"image\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/062814_1347_Comoespecif1.png\",\"keywords\":[\"sql\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/\",\"name\":\"Como especificar el Puerto en el SQL Server Management Studio &#183; devops Mauro Bernal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/062814_1347_Comoespecif1.png\",\"datePublished\":\"2014-06-28T13:47:45+00:00\",\"dateModified\":\"2020-09-16T02:00:51+00:00\",\"description\":\"Como especificar el Puerto en el SQL Server Management Studio\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/062814_1347_Comoespecif1.png?fit=429%2C323&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/062814_1347_Comoespecif1.png?fit=429%2C323&ssl=1\",\"width\":429,\"height\":323},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/como-especificar-el-puerto-en-el-sql-server-management-studio\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como especificar el Puerto en el SQL Server Management Studio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\",\"name\":\"devops Mauro Bernal\",\"description\":\"Cuando tu trabajo es hacer que las cosas funcionen bien...\",\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\",\"name\":\"Mauro Bernal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\",\"width\":1740,\"height\":1740,\"caption\":\"Mauro Bernal\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-maurobernal.png?fit=1740%2C1740&ssl=1\"},\"description\":\"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman\",\"sameAs\":[\"https:\\\/\\\/maurobernal.com.ar\",\"https:\\\/\\\/x.com\\\/_maurobernal\",\"https:\\\/\\\/youtube.com\\\/maurobernal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como especificar el Puerto en el SQL Server Management Studio &#183; devops Mauro Bernal","description":"Como especificar el Puerto en el SQL Server 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:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/","og_locale":"es_ES","og_type":"article","og_title":"Como especificar el Puerto en el SQL Server Management Studio &#183; devops Mauro Bernal","og_description":"Como especificar el Puerto en el SQL Server Management Studio","og_url":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/","og_site_name":"devops Mauro Bernal","article_published_time":"2014-06-28T13:47:45+00:00","article_modified_time":"2020-09-16T02:00:51+00:00","og_image":[{"url":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif1.png","type":"","width":"","height":""}],"author":"Mauro Bernal","twitter_card":"summary_large_image","twitter_creator":"@_maurobernal","twitter_site":"@_maurobernal","twitter_misc":{"Escrito por":"Mauro Bernal","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#article","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/"},"author":{"name":"Mauro Bernal","@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"headline":"Como especificar el Puerto en el SQL Server Management Studio","datePublished":"2014-06-28T13:47:45+00:00","dateModified":"2020-09-16T02:00:51+00:00","mainEntityOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/"},"wordCount":154,"commentCount":1,"publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"image":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif1.png","keywords":["sql"],"articleSection":["MSSQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/","url":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/","name":"Como especificar el Puerto en el SQL Server Management Studio &#183; devops Mauro Bernal","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#primaryimage"},"image":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif1.png","datePublished":"2014-06-28T13:47:45+00:00","dateModified":"2020-09-16T02:00:51+00:00","description":"Como especificar el Puerto en el SQL Server Management Studio","breadcrumb":{"@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#primaryimage","url":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif1.png?fit=429%2C323&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2014\/06\/062814_1347_Comoespecif1.png?fit=429%2C323&ssl=1","width":429,"height":323},{"@type":"BreadcrumbList","@id":"https:\/\/maurobernal.com.ar\/blog\/como-especificar-el-puerto-en-el-sql-server-management-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/maurobernal.com.ar\/blog\/"},{"@type":"ListItem","position":2,"name":"Como especificar el Puerto en el SQL Server Management Studio"}]},{"@type":"WebSite","@id":"https:\/\/maurobernal.com.ar\/blog\/#website","url":"https:\/\/maurobernal.com.ar\/blog\/","name":"devops Mauro Bernal","description":"Cuando tu trabajo es hacer que las cosas funcionen bien...","publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/maurobernal.com.ar\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283","name":"Mauro Bernal","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","url":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1","width":1740,"height":1740,"caption":"Mauro Bernal"},"logo":{"@id":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2023\/07\/logo-maurobernal.png?fit=1740%2C1740&ssl=1"},"description":"Desarrollo de Sistemas en .Net, IT Callcenters, DBA de SQL Server, Mikrotik, Pentest y T\u00e9cnico consultor de Sistemas Bejerman","sameAs":["https:\/\/maurobernal.com.ar","https:\/\/x.com\/_maurobernal","https:\/\/youtube.com\/maurobernal"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":4,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"predecessor-version":[{"id":763,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/141\/revisions\/763"}],"wp:attachment":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}