October 14, 2008 at 11:45 pm
What i want to do is that i want a script to change the port number in sql server services in configuration manager. Though i can change manually by going directly to configuration manager but i need a script for some purpose. If anybody know, please fwd it to me.
October 15, 2008 at 12:16 pm
look at this.... although this only reads, I'm sure there is a registry method to write to the registry as well. I would take a backup of the registry before I'd go poking my fingers around in there as well as make sure I'd do this in a sandbox area too.
http://www.databasejournal.com/features/mssql/article.php/3764516
[EDIT]
upon further digging...here is a script fragment...
$protocolproperty=Get-WmiObject -namespace root\Microsoft\SqlServer\ComputerManagement -class ClientNetworkProtocolProperty `
-filter "PropertyName='Default Port'"
$protocolproperty.SetNumericalValue(7001)
this came from the same site I mentioned above but different article...
http://www.databasejournal.com/features/mssql/article.php/3709441
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply