jskfan
asked on
MSSQL 2005 Standard edition clustering Requirements.
I would like to know what operating system version and edition is required in order to install MSSQL MSSQL 2005 Standard edition clustering?
Would that be installed on windows 2003 standard edition?
thanks
Would that be installed on windows 2003 standard edition?
thanks
ASKER
I don't see on the link where it says SQL server 2005 Standard edition can be installed in windows 2003 standard edition
FYI, we have several SQL Server 2005 Standard editions installed on Windows 2003 Standard Edition.
No need to worry about that and by following both links, you can successfully set Clustering environment.
No need to worry about that and by following both links, you can successfully set Clustering environment.
ASKER
I have been requested to provide an official link that says the SQL server 2005 standard edition can be installed in windows 2003 standard edition.
Can you provide the link?
Can you provide the link?
ASKER
Microsoft should have the link, but couldn't find one.
ASKER
I know it's hard to find.
The link you sent me is for SQL2005 standard edition Not in a cluster environment.
That's odd though.....How come Microsoft the owner of the product doesn't have a link for something like "System Requirement for MSSQL 2005 Standard edition in win
The link you sent me is for SQL2005 standard edition Not in a cluster environment.
That's odd though.....How come Microsoft the owner of the product doesn't have a link for something like "System Requirement for MSSQL 2005 Standard edition in win
Some links to prove that Clustering is possible in Windows 2003 Standard edition
http://technet.microsoft.com/en-us/library/cc757731(WS.10).aspx
http://technet.microsoft.com/en-us/library/cc758523.aspx
Are you referring to Cluster Service or Network Load Balancing (NLB) clusters.
I am referring to NLB clusters in Standard Edition of Windows 2003 and hope you mean Cluster Service.
To make it clear, NLB Clusters are available in Windows 2003 Standard Edition to Support SQL Server Clustering but Cluster Service is not available in Standard Edition.
If you want both NLB Cluster and Cluster Service then you have to go for either Windows 2003 Enterprise Edition or Datacenter Edition.
Hope I clarified you.
If I haven't understood your exact requirements, Kindly clarify more on your exact requirements.
http://technet.microsoft.com/en-us/library/cc757731(WS.10).aspx
http://technet.microsoft.com/en-us/library/cc758523.aspx
Are you referring to Cluster Service or Network Load Balancing (NLB) clusters.
I am referring to NLB clusters in Standard Edition of Windows 2003 and hope you mean Cluster Service.
To make it clear, NLB Clusters are available in Windows 2003 Standard Edition to Support SQL Server Clustering but Cluster Service is not available in Standard Edition.
If you want both NLB Cluster and Cluster Service then you have to go for either Windows 2003 Enterprise Edition or Datacenter Edition.
Hope I clarified you.
If I haven't understood your exact requirements, Kindly clarify more on your exact requirements.
ASKER
1- The windows Clustering I am aware of is the one that has for instance 2 Nodes(I mean 2computers)
Windows server is installed on both nodes, and the nodes have 2 NICs, one is attached to the Storage(Caled Private) and one attached to the Network(Called Public). This Clustering provides Fail Over, but not load balancing.
2-Regarding the NLB that I am aware consists of 2 computers with 2 NIC, one is connected to th network and one connect to another NIC of the other computer. The NLB service configures the Same IP address for both NICs that are attached to each other. In this case it load balance the traffic.
But I was talkin about the first clustering technology. Does it support MSSQL 2005?
Windows server is installed on both nodes, and the nodes have 2 NICs, one is attached to the Storage(Caled Private) and one attached to the Network(Called Public). This Clustering provides Fail Over, but not load balancing.
2-Regarding the NLB that I am aware consists of 2 computers with 2 NIC, one is connected to th network and one connect to another NIC of the other computer. The NLB service configures the Same IP address for both NICs that are attached to each other. In this case it load balance the traffic.
But I was talkin about the first clustering technology. Does it support MSSQL 2005?
ASKER
BTW the second technology, does it use Active/Passive which I doubt it, OR it always uses Active/Active.
Or there is no such thing Active /Passive or Active/Active in NLB.
Or there is no such thing Active /Passive or Active/Active in NLB.
NLB is just Network Load Balancing and hence if both two machines are up / Active then Load will be shared across or if any machine is down / Passive Load will be carried over only by the Active machine.
Hope I clarified you out.
Hope I clarified you out.
ASKER
the question was about MSSQL 2005 Standard Edition if it can be installed on windows 2003 Standard edition Clustering Services.
I need a Link that says, yes it can be installed on Windows 2003 Standard edition Clustering services.
In other words, the step #1 I described in the previous post is able to support MSSQL 2005 Standard Edition
I need a Link that says, yes it can be installed on Windows 2003 Standard edition Clustering services.
In other words, the step #1 I described in the previous post is able to support MSSQL 2005 Standard Edition
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
assuming the link is trustful.....
http://www.vi.net/hosting/database_hosting.html
Excellent Clarification
http://www.vi.net/hosting/database_hosting.html
Excellent Clarification
Yes.. For enabling Clustering in Windows 2003 Standard edition, steps below
http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx
And then Install SQL Server 2005 Clustering as given below:
http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx