how to add startup parameters in cluster sql server?

  • lazy writer

    Ten Centuries

    Points: 1126

    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

    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

    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

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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply