Adding SQL Server startup parameters from the command line

• Joe Wagner

  Ten Centuries

  Points: 1394

  More actions

  September 19, 2011 at 9:32 am

  #244019

  Good day.

  We have the need to add the -g parameter to SQL Server Express instances that are deployed as part of our released product. The SSE instances run basically unattended, and using the SQL Server Configuration Manager GUI isn't an option, because the change has to be automated.

  I know where the registry entries are that contain the startup parameters, but I don't really like the idea of modifying them directly. I'll do it, though, if necessary.

  I've looked at sac.exe, but it doesn't seem to do what I want.

  Any suggestions would be appreciated.

  Regards,

  Joe

• NJ-DBA

  SSChampion

  Points: 13834

  More actions

  September 19, 2011 at 1:38 pm

  #1383465

  Joe Wagner (9/19/2011)

  ---

  Good day.

  We have the need to add the -g parameter to SQL Server Express instances that are deployed as part of our released product. The SSE instances run basically unattended, and using the SQL Server Configuration Manager GUI isn't an option, because the change has to be automated.

  I know where the registry entries are that contain the startup parameters, but I don't really like the idea of modifying them directly. I'll do it, though, if necessary.

  I've looked at sac.exe, but it doesn't seem to do what I want.

  Any suggestions would be appreciated.

  Regards,

  Joe

  How about using powershell... something like this: http://www.sqlservercentral.com/blogs/erichumphrey/archive/2011/03/31/change-sql-startup-parameters-with-powershell.aspx

• Joe Wagner

  Ten Centuries

  Points: 1394

  More actions

  September 19, 2011 at 3:24 pm

  #1383524

  Thanks for the reply.

  Unfortunately, our deployments don't have Powershell yet. I'll keep this in mind for later.

  Can this be morphed into something that would be called from a VBScript/bat file, that uses WMI?