tsql - Enabling TCP/IP protocol through t-sql script?

Question

How to enable tcp/ip through t-sql script on sql server 2008?

Answer 1

In order to do that using a t-sql script, you might have to fiddle with the registry settings. I haven't done that before myself using t-sql so can't be of much help. But you may like to look up for xp_instance_regread and xp_instance_regwrite. They are extended stored procedures which allow you to read/write registry values.

Here is an example which might be of some help - http://codebetter.com/blogs/raymond.lewallen/archive/2005/09/12/131869.aspx

The following links should help you locate the whereabouts of TCP/IP settings in the registry. http://support.microsoft.com/kb/315236

http://www.pctools.com/guides/registry/detail/1171/

cheers