Can I add a local SQL 2005 instance to a clustered node

70 pts.
Tags:
SQL 2005 Database
SQL Server
SQL Server Clustered Index
I have a 2 nodes (Active/Active) SQL 2005 Standard cluster. Since SQL STD only support two clustered instances, can I add a local instance to each node? I don't need this local instance to fail over. Is it possible to have the two clustered instances an two local instance one on each node?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes you can install a SQL Instance on one of the nodes without setting it up for fail over. You have to set it up on either local storage, or on its own SAN storage so that the storage doesn’t fail over.

The instance name will need to be unique from the clustered instances.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • NetWeb
    How can I install it. When I run setup it detect that SQL is clustered and that I already have 2 instances of SQL on the cluster and since SQL 2005 STD only support two instances the installation can't continue.
    70 pointsBadges:
    report
  • Denny Cherry
    This is the first I've ever heard of that limitation. I'm checking with some people to see if they've seen that before. There's nothing about that in the feature list. http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
    66,010 pointsBadges:
    report
  • NetWeb
    I would really appreciate if you can get me this information. Thanks for your help.
    70 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following