Changing SQL Server Settings in code

Hi,

Has anybody written code or know of a way of changing SQL server settings . Of particualr importance are the sql server protacols (named pipes and TCP/IP) . Also port numbers.

Thanks for clicking, reading and if you can help, look foward to your reply.
KBannerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
I haven't done this myself, but you can take a look at using the WMI providers from Microsoft:
http://msdn.microsoft.com/en-us/library/ms180606.aspx

If you follow some links through, you will eventually find this:
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.managedcomputer(SQL.90).aspx

Per this document, client protocols and connection settings are in the list of WMI accessible items.
0
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Here is an example of reading port number value:
http://msdn.microsoft.com/en-us/library/ms179354(SQL.90).aspx
0
 
KBannerAuthor Commented:
My apologies for late points allocation
0
 
Kevin CrossChief Technology OfficerCommented:
Not a problem.  Glad that helped!
0
All Courses

From novice to tech pro — start learning today.