We have a C# win Form app called "Installer" that silently installs various 3rd party software on client's system like IIS, SQL Server, AVG-Free; along with our own product. I need to automatically enable Named Pipes & TCP/IP protocols which also require a restart of SQL Server (SQLEXPRESS) Service using a batch file; OR C# win Form app; OR while installing SQL Server through command line by providing appropriate switches.
I have searched but this is very unique requirement.
I have found a solution, tried it. The protocol info of SQL Server in registry is store here:
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer\SuperSocketNetLib
This is for MSSQLSERVER instance, in case of different instance the registry path in bold gets replaced by name of that instance.
It needs restart of "SQLServer Service" of that instance.