Hi All,

I want to assign static port through TSQL command or OS command to a named instance as i have some issue to launch SQL server configuration Manager.

Please let me know the way to assign the static port other than through SQL server confirguration Manager.

Thanks

Kumar

Hi Kumar,

See this link on how to enable TCP/IP on SQL server using WMI

http://stackoverflow.com/questions/9138172/enable-tcp-ip-remote-connections-to-sql-server-express-already-installed-database

I would rather fix my configuration manager and do things from there. It is easy as

Hope this helps

Thanks

Bhanu

• Edited by bhanu_nz 3 hours 26 minutes ago

You can use powershell:

http://geekswithblogs.net/TedStatham/archive/2014/06/13/setting-the-ports-for-a-named-sql-server-instance-using.aspx

http://www.sqltechnet.com/2013/06/assign-static-port-to-sql-services.html

HI Bhanu and Dave_gona,

Thank you for your replies.

I have done it by editing the regedit without using Configuration Manager.

Reason for not using Configuration Manager is due to 'Cannot connect to WMI provider' error while launching configuration Manager. Windows team confirmed that the WMI is corrupted. They are going to rebuild it soon. In between i was checking for the alternative methods for setting the static port.

Thanks

Kumar

• Marked as answer by K735 2 hours 11 minutes ago