How to change sql service log on account 2008 through code

• nbs098-signup

  Grasshopper

  Points: 14

  More actions

  February 1, 2009 at 11:10 pm

  #155211

  Hi,

  I know that we can change the log on credeintails through the SQL configuration manager. However, I need to do it through code. Can someone help me with the same?

  Thanks,

  nbs

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  February 1, 2009 at 11:53 pm

  #936262

  Hello,

  You should be able to do this via PowerShell scripting. Take a look at the following article (although it applies to SQL 2005):-

  http://www.databasejournal.com/features/mssql/article.php/3709441/Microsoft-Windows-PowerShell-and-SQL-Server-2005-WMI-Providers--Part-1.htm

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group