Home > IT Answers > SQL Server > Can I add a local SQL 2005 instance to a clus...
NetWeb
70 pts.
Q:
Can I add a local SQL 2005 instance to a clustered node
SQL Server Clustered Index, SQL Server, SQL 2005 Database
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?
ASKED: Aug 24 2009  8:01 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
NetWeb
70 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
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.
Last Answered: Aug 25 2009  5:48 AM GMT by NetWeb   70 pts.
Latest Contributors: Mrdenny   50690 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

NetWeb   70 pts.  |   Aug 25 2009  5:48AM GMT

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.

 

mrdenny   50690 pts.  |   Aug 25 2009  3:09PM GMT

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.

 <a href="http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx" title="http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx" target="_blank">http://www.microsoft.com/Sqlserver/2005/…</a>

 

NetWeb   70 pts.  |   Aug 27 2009  4:00AM GMT

I would really appreciate if you can get me this information. Thanks for your help.