// using Microsoft.SqlServer.Management.Smo.Wmi; public static void SetStaticPort(string ServiceName = "MSSQL$SQLEXPRESS", string InstanceName = "SQLEXPRESS", int PortNumber = 2433) { try { ManagedComputer c = new ManagedComputer(); c.ConnectionSettings.ProviderArchitecture = ProviderArchitecture.Use32bit; int count = 0; foreach (ServerInstance si in c.ServerInstances) { count++; } if (count == 0) { c = new ManagedComputer(); c.ConnectionSettings.ProviderArchitecture = ProviderArchitecture.Use64bit; foreach (ServerInstance si in c.ServerInstances) { count++; } } if (count == 0) throw new Exception("Unable to locate SQL Instances, Please contact support."); Service svc = c.Services[ServiceName]; var state = svc.ServiceState; if (state == ServiceState.Running) svc.Stop(); ServerInstance s = c.ServerInstances[InstanceName]; if (null == s) throw new Exception("Unable to locate SQL Service, Please contact support."); ServerProtocol prot = s.ServerProtocols["Tcp"]; foreach (ServerIPAddress ip in prot.IPAddresses) { if (ip.Name == "IPAll") { ip.IPAddressProperties["TcpPort"].Value = PortNumber.ToString(); ip.IPAddressProperties["TcpDynamicPorts"].Value = String.Empty; } } prot.Alter(); svc.Start(); } catch (Exception ex) { throw; } }
Technical blog with tips and tricks for everything and more...
Featured Post
Organize and rename photos by EXIF data with PowerShell
This PowerShell script organizes and renames all photos in a selected folder using EXIF data. It will also create thumbnails of the images i...
Friday, May 2, 2014
Configure SQL Server IPAll Static Port using C#
Note: You will need to add references for a few Microsoft.SqlServer dll's
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment