{"id":2937,"date":"2013-02-21T01:22:00","date_gmt":"2013-02-21T00:22:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/"},"modified":"2013-02-21T01:22:00","modified_gmt":"2013-02-21T00:22:00","slug":"sql-server-2012-configuring-your-tcp-port-via-powershell","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/","title":{"rendered":"SQL Server 2012: Configuring your TCP Port via Powershell"},"content":{"rendered":"<p>Changing the default TCP port 1433 for SQL Server is an important step for securing your SQL Server.\u00a0I have written a script in PowerShell to modify the port number that helps me perform this task. This blog posting will show you how to do it. Please note that the code in this article is for SQL Server 2012 on Windows Server 2012.<\/p>\n<h3>Initialization<\/h3>\n<p>Run SQLPS to launch the SQL PowerShell in a command prompt.<\/p>\n<p>First you have to initialize the Microsoft.SqlServer.Management.Smo namespace that contains the classes representing the core SQL Server database engine objects:<\/p>\n<p><code>$smo = 'Microsoft.SqlServer.Management.Smo.'<\/code><\/p>\n<p>Then, you have to set the ManagedComputer object that represents a Windows Management Instrumentation (WMI) installation on an instance of Microsoft SQL Server.<\/p>\n<p><code>$wmi = new-object ($smo + 'Wmi.ManagedComputer')<\/code><\/p>\n<p>Let me show you my instance information with $wmi (sample):<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerShellChangePort01.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/PowerShellChangePort01.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort01.jpg\" alt=\"\" \/><\/a><\/p>\n<p>You will notice that in ClientProtocols, I have the tcp protocol.<\/p>\n<h3>Searching the port value<\/h3>\n<p>The next step is to find the Tcp Protocol settings:<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">$uri = \"ManagedComputer[@Name='']\/ ServerInstance[@Name='']\/ServerProtocol[@Name='Tcp']\"\n$Tcp = $wmi.GetSmoObject($uri)<\/pre>\n<p>This is my $tcp variable (sample):<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerShellChangePort02.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/PowerShellChangePort02.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort02.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Please not that IsEnabled is set to true. If you have IsEnabled on false, you can set it up to true with this command:<\/p>\n<p><code>$Tcp.IsEnabled = $true<\/code><\/p>\n<p>And do not forget to validate this change with an Alter:<\/p>\n<p><code>$Tcp.Alter()<\/code><\/p>\n<p>To check the port, you need to go to the\u00a0IPAll characteristics:<\/p>\n<p><code>$wmi.GetSmoObject($uri + \"\/IPAddress[@Name='IPAll']\").IPAddressProperties<\/code><\/p>\n<p>Like in the SQL Server configuration manager, two sections will appear: One is for the TcpDymanicPorts and the second for the fixed TcpPort (sample):<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerShellChangePort03.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/PowerShellChangePort03.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort03.jpg\" alt=\"\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Changing the TCP port<\/h3>\n<p>To change the value, it\u2019s very simple, the field is simply named Value:<\/p>\n<p><code>$wmi.GetSmoObject($uri + \"\/IPAddress[@Name='IPAll']\").IPAddressProperties[1].Value=\"xxxxx\"<\/code><\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerShellChangePort04.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/PowerShellChangePort04.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort04.jpg\" alt=\"\" \/><\/a><\/p>\n<p>If you look at the characteristics with your precedent command&#8230;<\/p>\n<p><code>$wmi.GetSmoObject($uri + \"\/IPAddress[@Name='IPAll']\").IPAddressProperties<\/code><\/p>\n<p>&#8230;the port has changed, but in the Sql Server Configuration Manager, the port still is 1433:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerShellChangePort05.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/PowerShellChangePort05.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort05.jpg\" alt=\"\" \/><\/a><\/p>\n<p>But why???\u00a0 \ud83d\ude41<\/p>\n<h3>Validating the change<\/h3>\n<p>Yes, of course&#8230; you need to validate the change with the Alter command!<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerShellChangePort06.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/PowerShellChangePort06.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort06.jpg\" alt=\"\" \/><\/a><\/p>\n<p>And now, if you look at the SQL Server Configuration Manager, the change is applied:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerShellChangePort07.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/PowerShellChangePort07.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort07.jpg\" alt=\"\" \/><\/a><\/p>\n<p>To finish, do not forget to restart your services to activate the port change.:-D<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Changing the default TCP port 1433 for SQL Server is an important step for securing your SQL Server.\u00a0I have written a script in PowerShell to modify the port number that helps me perform this task. This blog posting will show you how to do it. Please note that the code in this article is for [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":2938,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[203,272,51,54],"type_dbi":[],"class_list":["post-2937","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-command-lines","tag-powershell","tag-sql-server","tag-sql-server-2012"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2012: Configuring your TCP Port via Powershell - dbi Blog<\/title>\n<meta name=\"description\" content=\"Changing the default TCP port 1433 for SQL Server is a first step to securing your SQL Server. To help me to do this by my customers, I have writed a script in Powershell to change the port number to another\" \/>\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.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012: Configuring your TCP Port via Powershell\" \/>\n<meta property=\"og:description\" content=\"Changing the default TCP port 1433 for SQL Server is a first step to securing your SQL Server. To help me to do this by my customers, I have writed a script in Powershell to change the port number to another\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-21T00:22:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"158\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2012: Configuring your TCP Port via Powershell\",\"datePublished\":\"2013-02-21T00:22:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/\"},\"wordCount\":332,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_PowerShellChangePort01.jpg\",\"keywords\":[\"Command lines\",\"PowerShell\",\"SQL Server\",\"SQL Server 2012\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/\",\"name\":\"SQL Server 2012: Configuring your TCP Port via Powershell - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_PowerShellChangePort01.jpg\",\"datePublished\":\"2013-02-21T00:22:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Changing the default TCP port 1433 for SQL Server is a first step to securing your SQL Server. To help me to do this by my customers, I have writed a script in Powershell to change the port number to another\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_PowerShellChangePort01.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_PowerShellChangePort01.jpg\",\"width\":500,\"height\":158},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-configuring-your-tcp-port-via-powershell\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012: Configuring your TCP Port via Powershell\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012: Configuring your TCP Port via Powershell - dbi Blog","description":"Changing the default TCP port 1433 for SQL Server is a first step to securing your SQL Server. To help me to do this by my customers, I have writed a script in Powershell to change the port number to another","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.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012: Configuring your TCP Port via Powershell","og_description":"Changing the default TCP port 1433 for SQL Server is a first step to securing your SQL Server. To help me to do this by my customers, I have writed a script in Powershell to change the port number to another","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/","og_site_name":"dbi Blog","article_published_time":"2013-02-21T00:22:00+00:00","og_image":[{"width":500,"height":158,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort01.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2012: Configuring your TCP Port via Powershell","datePublished":"2013-02-21T00:22:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/"},"wordCount":332,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort01.jpg","keywords":["Command lines","PowerShell","SQL Server","SQL Server 2012"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/","name":"SQL Server 2012: Configuring your TCP Port via Powershell - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort01.jpg","datePublished":"2013-02-21T00:22:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Changing the default TCP port 1433 for SQL Server is a first step to securing your SQL Server. To help me to do this by my customers, I have writed a script in Powershell to change the port number to another","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort01.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_PowerShellChangePort01.jpg","width":500,"height":158},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-configuring-your-tcp-port-via-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012: Configuring your TCP Port via Powershell"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2937","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2937"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2937\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2938"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2937"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}