{"id":8539,"date":"2016-07-12T13:06:45","date_gmt":"2016-07-12T11:06:45","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/"},"modified":"2016-07-12T13:06:45","modified_gmt":"2016-07-12T11:06:45","slug":"set-the-sql-native-client-default-port-with-powershell","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/","title":{"rendered":"Set the SQL Native Client Default Port with PowerShell"},"content":{"rendered":"

I written an article about “SQL Server 2012: Configuring your TCP Port via PowerShell”<\/a> and I received a question from PaulJ:
\n“How do you set the port for the SQL Native Client 11.0 Configuration (32bit) \u2013 as seen in the SQL Configuration Manager?”<\/em><\/p>\n

This is a very good question and I decide to write this blog as an answer to this question.
\nThe first step is always the same, initialization of my object:<\/p>\n

[reflection.assembly]::LoadWithPartialName(\"Microsoft.SqlServer.SqlWmiManagement\") | Out-Null\n\n$wmi = New-Object (\"Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer\")<\/pre>\n
The second step is used to know for which client protocol the setting belongs to.
\nIn the class \u201cMicrosoft.SqlServer.Management.Smo.Wmi.ManagedComputer\u201d, you find a property \u201cClientProtocols\u201d as you can see in the msdn web page<\/a>:
\n\"tcpnativeclient01\"<\/a>
\nI display the name and the protocol Properties with this command:<\/p>\n
$wmi.ClientProtocols | Select displayname -ExpandProperty ProtocolProperties<\/pre>\n
\"tcpnativeclient02\"<\/a>
\nAs you can see, I have 4 client protocols (Named Pipes, default port, KEEPALIVE and KEEPALIVEINTERVAL).
\nThe next step is to select the default port:<\/p>\n
$tcp_list = $wmi.ClientProtocols\u00a0 | Where-Object {$_.displayname -eq \"TCP\/IP\"}\n$default_tcp = $tcp_list.ProtocolProperties | Where-Object {$_.Name -eq \"Default Port\"}\n$default_tcp<\/pre>\n
\"tcpnativeclient03\"<\/a>
\nAs you can see, the default client port is set to 1433 and now, I will set another value for this port:<\/p>\n
$default_tcp.value=50100<\/pre>\n
Note: The port has a System.Int32 type<\/em>
\nValidate this change with an Alter:<\/p>\n
$tcp_list.alter()<\/pre>\n
To finish, do not forget to restart your services to activate the port change:<\/p>\n
$sql_service = ($wmi.Services | Where-Object { $_.Type -eq \"SqlServer\" })\n$sql_service.alter()\n$sql_service.stop()\n$sql_service.start()<\/pre>\n
\"tcpnativeclient04\"<\/a>
\nEt voil\u00e0! The default port for the client protocol is changed!<\/p>\n","protected":false},"excerpt":{"rendered":"
I written an article about “SQL Server 2012: Configuring your TCP Port via PowerShell” and I received a question from PaulJ: “How do you set the port for the SQL Native Client 11.0 Configuration (32bit) \u2013 as seen in the SQL Configuration Manager?” This is a very good question and I decide to write this […]<\/p>\n","protected":false},"author":15,"featured_media":8544,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[49,272,51],"type_dbi":[],"class_list":["post-8539","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-microsoft","tag-powershell","tag-sql-server"],"acf":[],"yoast_head":"\nSet the SQL Native Client Default Port with PowerShell<\/title>\n<meta name=\"description\" content=\"How do you set the default port for the SQL Native Client 11.0 Configuration (32bit)\" \/>\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\/set-the-sql-native-client-default-port-with-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Set the SQL Native Client Default Port with PowerShell\" \/>\n<meta property=\"og:description\" content=\"How do you set the default port for the SQL Native Client 11.0 Configuration (32bit)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-12T11:06:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"879\" \/>\n\t<meta property=\"og:image:height\" content=\"373\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"Set the SQL Native Client Default Port with PowerShell\",\"datePublished\":\"2016-07-12T11:06:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/\"},\"wordCount\":212,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png\",\"keywords\":[\"Microsoft\",\"PowerShell\",\"SQL Server\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/\",\"name\":\"Set the SQL Native Client Default Port with PowerShell\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png\",\"datePublished\":\"2016-07-12T11:06:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"How do you set the default port for the SQL Native Client 11.0 Configuration (32bit)\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png\",\"width\":879,\"height\":373},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Set the SQL Native Client Default Port with 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 & 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":"Set the SQL Native Client Default Port with PowerShell","description":"How do you set the default port for the SQL Native Client 11.0 Configuration (32bit)","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\/set-the-sql-native-client-default-port-with-powershell\/","og_locale":"en_US","og_type":"article","og_title":"Set the SQL Native Client Default Port with PowerShell","og_description":"How do you set the default port for the SQL Native Client 11.0 Configuration (32bit)","og_url":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/","og_site_name":"dbi Blog","article_published_time":"2016-07-12T11:06:45+00:00","og_image":[{"width":879,"height":373,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"Set the SQL Native Client Default Port with PowerShell","datePublished":"2016-07-12T11:06:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/"},"wordCount":212,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png","keywords":["Microsoft","PowerShell","SQL Server"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/","url":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/","name":"Set the SQL Native Client Default Port with PowerShell","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png","datePublished":"2016-07-12T11:06:45+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"How do you set the default port for the SQL Native Client 11.0 Configuration (32bit)","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tcpnativeclient04-1.png","width":879,"height":373},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/set-the-sql-native-client-default-port-with-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Set the SQL Native Client Default Port with 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 & 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\/8539","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=8539"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8539\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8544"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8539"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}