title: Changing SQL Server settings programmatically
body: <p>I request you to read my question carefully. </p>
  
  <p>You might know when you install VS2005/2008 with SQL Server Express edition, the SQL Server operates in Windows authentication mode by default. You can use the SQL Server Management Studio to change the mode to Mixed mode (Windows and SQL Server Authentication mode).</p>
  
  <p>Similarly to allow the SQL Server remote connection through TCP/IP, you need to use SQL Server Configuration Manager then select Protocol for SQLEXPRESS and then change the setting for Tcp/IP option. </p>
  
  <p>What i need is to automate this process programmatically using C#. That is, i need to write a c# program to change the mode or change the tcp/ip settings etc.</p>
  
  <p>Can anyone provide me help on this, how could i do that?</p>
  
  <p>Thank you for sharing your valuable time.</p>