how to add startup parameters in cluster sql server?

• lazy writer

  Ten Centuries

  Points: 1126

  More actions

  April 23, 2010 at 5:17 am

  #144251

  Hi All,

  how to add start-up parameters like (-g) in clustered SQL Server? do i need to add on both nodes or loging into active node and just add the parameter in the configuration manager for SQL Server 2005

  please help on this.

  Thanks in advance.

  Regards,

  Kris

• NJ-DBA

  SSChampion

  Points: 13832

  More actions

  April 23, 2010 at 6:53 am

  #1156787

  Just the active node is fine. Notice that in configuration manager, the Advanced values include "is clustered". It's smart enough to make the change on both nodes.

• NJ-DBA

  SSChampion

  Points: 13832

  More actions

  April 23, 2010 at 6:56 am

  #1156789

  out of curiousity, why are you considering using the -g parameter? Have you encountered errors calling extended stored procedures?

• lazy writer

  Ten Centuries

  Points: 1126

  More actions

  April 23, 2010 at 7:47 am

  #1156847

  no i am unable to create CLR assemblies in sql server 🙁