{"id":203,"date":"2015-07-21T16:05:17","date_gmt":"2015-07-21T19:05:17","guid":{"rendered":"https:\/\/maurobernal.com.ar\/blog\/?p=203"},"modified":"2024-02-19T12:12:29","modified_gmt":"2024-02-19T15:12:29","slug":"averiguar-el-puerto-del-sql-server","status":"publish","type":"post","link":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/","title":{"rendered":"Averiguar el Puerto del SQL Server"},"content":{"rendered":"\n<p class=\"\">\u00bfC\u00f3mo saber en que puerto est\u00e1 corriendo nuestro motor SQL Server? Primero que nada es conveniente entender porque es que no esta en su puerto default. Si eres novato en el tema, seguramente tienes la instalaci\u00f3n est\u00e1ndar del motor de Microsoft, y nunca te has preguntado porque deber\u00eda cambiarlo de puerto. Si es tu caso te dejo este art\u00edculo donde te contamos como es la seguridad del MS SQL Server y que cosas debes tener en cuenta. (<a href=\"https:\/\/maurobernal.com.ar\/blog\/blog\/consejos-para-asegurar-tu-ms-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/maurobernal.com.ar\/blog\/blog\/consejos-para-asegurar-tu-ms-sql-server\/<\/a>)<\/p>\n\n\n\n<p class=\"\">Para aquellos que entendemos el porqu\u00e9 debemos cambiarlo, y no sabemos como hacerlo, te dejo este otro art\u00edculo. (<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 class=\"\">Y para aquellos que sabemos lo anterior, pero por diferentes motivos nos toca implementar una aplicaci\u00f3n, y no sabemos en que puerto est\u00e1 corriendo, a continuaci\u00f3n te damos una idea de como averiguarlo.<\/p>\n\n\n\n<p class=\"\"><\/p>\n\n\n<h1><strong>Averiguar el Puerto en el que est\u00e1 funcionando el SQL Server: <\/strong><\/h1>\n<p>Por defecto el motor <strong>SQL Server<\/strong> trabaja en los siguientes <strong>puertos<\/strong> de manera predeterminada:<\/p>\n<ul>\n<li>TCP:1433<\/li>\n<li>UDP:1433<\/li>\n<\/ul>\n<p>Pero puede ocurrir que esto al tener varias instancias, o por otros motivos que no\u00a0vienen al caso,\u00a0no sean los puertos en los que est\u00e1 funcionando nuestro Motor. Para averiguar el puerto podemos utilizar los siguientes 3 m\u00e9todos:<\/p>\n<ol>\n<li>Registros de errores de lectura de SQL Server<\/li>\n<li><span class=\"notranslate\"><span class=\"google-src-text\">Usando el\u00a0<\/span>Administrador de configuraci\u00f3n de SQL Server (<strong>SQL Server Configuration Manager\u00a0<\/strong>)<\/span><\/li>\n<li><span class=\"notranslate\"><span class=\"google-src-text\">Usando el visor de\u00a0sucesos (o Eventos)\u00a0de\u00a0Windows\u00a0(<strong>Windows Application Event Viewer<\/strong><\/span>)<\/span><\/li>\n<\/ol>\n<h2><strong>1-Registros de errores de lectura de SQL Server:<\/strong><\/h2>\n<pre title=\"Averiguar Puerto de SQL Server\" class=\"lang:tsql decode:true\">USE master\nGO\nxp_readerrorlog 0, 1, N'Server is listening on' \nGO<\/pre>\n<p><a href=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-207\" src=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number-300x77.png?resize=300%2C77&#038;ssl=1\" alt=\"port_number\" width=\"300\" height=\"77\" srcset=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number.png?resize=300%2C77&amp;ssl=1 300w, https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number.png?w=503&amp;ssl=1 503w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/p>\n<p><span class=\"notranslate\">Los par\u00e1metros que puede utilizar con <em><strong>XP_READERRRORLOG<\/strong> <\/em>se mencionan a continuaci\u00f3n para su referencia:<\/span><\/p>\n<ol>\n<li><span class=\"notranslate\">\u00a01. <strong>Valor de los archivos de registro de errores que quieran leer:<\/strong> 0 = actual, 1 = Archivo # 1, 2 = Archivo # 2, etc &#8230;<\/span><\/li>\n<li><span class=\"notranslate\">T<strong>ipo de archivo:<\/strong> 1 o NULL = log de \u200b\u200berrores, 2= registro de Agente SQL\u00a0<\/span><\/li>\n<li><span class=\"notranslate\"><strong>Cadena de b\u00fasqueda 1:<\/strong> Primer cadena de texto que se quiere buscar<\/span><\/li>\n<li><span class=\"notranslate\"><strong>Cadena de b\u00fasqueda 2:<\/strong> Segunda cadena de texto a buscar<\/span><\/li>\n<li><span class=\"notranslate\"><strong>Fecha de Inicio para la b\u00fasqueda<\/strong><\/span><\/li>\n<li><span class=\"notranslate\"><strong>Fecha Fin para la b\u00fasqueda<\/strong><\/span><\/li>\n<li><span class=\"notranslate\"><span class=\"google-src-text\"><strong>Orden de los Resultados<\/strong>\u00a0: N&#8217;asc&#8217; = Ascendente, N&#8217;desc&#8217; = Descendiente<\/span><\/span><\/li>\n<\/ol>\n<h2><strong>2-Usando el Administrador de Configuraci\u00f3n del SQL Server:<\/strong><\/h2>\n<p>Se debe ir a INICIO \\ Todos los Programas \\ Microsoft SQL Server 200X \\ Configuration Tools \\ <strong>SQL Server Configuration Manager<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/configuration_manager_port.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-209\" src=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/configuration_manager_port-300x288.png?resize=300%2C288&#038;ssl=1\" alt=\"configuration_manager_port\" width=\"300\" height=\"288\" srcset=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/configuration_manager_port.png?resize=300%2C288&amp;ssl=1 300w, https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/configuration_manager_port.png?w=676&amp;ssl=1 676w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<h2>\u00a0<strong>3-Usando el Visor de Eventos de Windows:<\/strong><\/h2>\n<p>Se deben filtrar los eventos cuyo ID es <strong>26022<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-210\" src=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql-300x100.png?resize=300%2C100&#038;ssl=1\" alt=\"visor_port_sql\" width=\"300\" height=\"100\" srcset=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql.png?resize=300%2C100&amp;ssl=1 300w, https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql.png?resize=1024%2C340&amp;ssl=1 1024w, https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql.png?w=1302&amp;ssl=1 1302w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql_number.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-211\" src=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql_number-300x109.png?resize=300%2C109&#038;ssl=1\" alt=\"visor_port_sql_number\" width=\"300\" height=\"109\" srcset=\"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql_number.png?resize=300%2C109&amp;ssl=1 300w, https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/visor_port_sql_number.png?w=584&amp;ssl=1 584w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n\n\n<p class=\"\">Video Explicando todo este proceso<\/p>\n\n\n\n<figure class=\"wp-embed-aspect-16-9 wp-has-aspect-ratio wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Averiguar puerto de SQL Server \ud83d\udc48 como saber en donde est\u00e1 trabajando tu motor\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/6zBYnhKguO8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfC\u00f3mo saber en que puerto est\u00e1 corriendo nuestro motor SQL Server? Primero que nada es conveniente entender porque es que no esta en su puerto default. Si eres novato en&#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":[1,3],"tags":[8,83,84,85,29,86],"class_list":["post-203","post","type-post","status-publish","format-standard","hentry","category-blog","category-t-sql","tag-mssql-2","tag-port","tag-puerto","tag-tcp","tag-tsql","tag-ucp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Averiguar el Puerto del SQL Server &#183; devops Mauro Bernal<\/title>\n<meta name=\"description\" content=\"Averiguar el puerto de su MS SQL Server en el c\u00faal esta funcionando a trav\u00e9s de TSQL o las interfaces gr\u00e1ficas.\" \/>\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\/averiguar-el-puerto-del-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Averiguar el Puerto del SQL Server &#183; devops Mauro Bernal\" \/>\n<meta property=\"og:description\" content=\"Averiguar el puerto de su MS SQL Server en el c\u00faal esta funcionando a trav\u00e9s de TSQL o las interfaces gr\u00e1ficas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"devops Mauro Bernal\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-21T19:05:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T15:12:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number-300x77.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=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/\"},\"author\":{\"name\":\"Mauro Bernal\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"headline\":\"Averiguar el Puerto del SQL Server\",\"datePublished\":\"2015-07-21T19:05:17+00:00\",\"dateModified\":\"2024-02-19T15:12:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/\"},\"wordCount\":405,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#\\\/schema\\\/person\\\/09c4dbdfb59b20e015c703fd19713283\"},\"image\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/port_number-300x77.png\",\"keywords\":[\"mssql\",\"port\",\"puerto\",\"tcp\",\"tsql\",\"ucp\"],\"articleSection\":[\"Blog\",\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/\",\"url\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/\",\"name\":\"Averiguar el Puerto del SQL Server &#183; devops Mauro Bernal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/port_number-300x77.png\",\"datePublished\":\"2015-07-21T19:05:17+00:00\",\"dateModified\":\"2024-02-19T15:12:29+00:00\",\"description\":\"Averiguar el puerto de su MS SQL Server en el c\u00faal esta funcionando a trav\u00e9s de TSQL o las interfaces gr\u00e1ficas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/port_number.png?fit=503%2C129&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/maurobernal.com.ar\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/port_number.png?fit=503%2C129&ssl=1\",\"width\":503,\"height\":129},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/averiguar-el-puerto-del-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/maurobernal.com.ar\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Averiguar el Puerto del SQL Server\"}]},{\"@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":"Averiguar el Puerto del SQL Server &#183; devops Mauro Bernal","description":"Averiguar el puerto de su MS SQL Server en el c\u00faal esta funcionando a trav\u00e9s de TSQL o las interfaces gr\u00e1ficas.","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\/averiguar-el-puerto-del-sql-server\/","og_locale":"es_ES","og_type":"article","og_title":"Averiguar el Puerto del SQL Server &#183; devops Mauro Bernal","og_description":"Averiguar el puerto de su MS SQL Server en el c\u00faal esta funcionando a trav\u00e9s de TSQL o las interfaces gr\u00e1ficas.","og_url":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/","og_site_name":"devops Mauro Bernal","article_published_time":"2015-07-21T19:05:17+00:00","article_modified_time":"2024-02-19T15:12:29+00:00","og_image":[{"url":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number-300x77.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":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#article","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/"},"author":{"name":"Mauro Bernal","@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"headline":"Averiguar el Puerto del SQL Server","datePublished":"2015-07-21T19:05:17+00:00","dateModified":"2024-02-19T15:12:29+00:00","mainEntityOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/"},"wordCount":405,"commentCount":1,"publisher":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#\/schema\/person\/09c4dbdfb59b20e015c703fd19713283"},"image":{"@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number-300x77.png","keywords":["mssql","port","puerto","tcp","tsql","ucp"],"articleSection":["Blog","T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/","url":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/","name":"Averiguar el Puerto del SQL Server &#183; devops Mauro Bernal","isPartOf":{"@id":"https:\/\/maurobernal.com.ar\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number-300x77.png","datePublished":"2015-07-21T19:05:17+00:00","dateModified":"2024-02-19T15:12:29+00:00","description":"Averiguar el puerto de su MS SQL Server en el c\u00faal esta funcionando a trav\u00e9s de TSQL o las interfaces gr\u00e1ficas.","breadcrumb":{"@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#primaryimage","url":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number.png?fit=503%2C129&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maurobernal.com.ar\/blog\/wp-content\/uploads\/2015\/07\/port_number.png?fit=503%2C129&ssl=1","width":503,"height":129},{"@type":"BreadcrumbList","@id":"https:\/\/maurobernal.com.ar\/blog\/averiguar-el-puerto-del-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/maurobernal.com.ar\/blog\/"},{"@type":"ListItem","position":2,"name":"Averiguar el Puerto del SQL Server"}]},{"@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\/203","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=203"}],"version-history":[{"count":5,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/203\/revisions"}],"predecessor-version":[{"id":1101,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/posts\/203\/revisions\/1101"}],"wp:attachment":[{"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/categories?post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maurobernal.com.ar\/blog\/wp-json\/wp\/v2\/tags?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}