Post reply

how to add startup parameters in cluster sql server?

  • 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

  • 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.

  • 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?

  • April 23, 2010 at 7:47 am

    #1156847

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

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

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