?
Solved

MSSQL 2005 Standard edition clustering Requirements.

Posted on 2009-05-19
14
Medium Priority
?
430 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:jskfan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24423117
SQL Server 2005 Standard Edition supports two nodes of clustering.

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
0
 

Author Comment

by:jskfan
ID: 24423160
I don't see on the link where it says SQL server 2005 Standard edition can be installed in windows 2003 standard edition
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24423196
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.
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

Author Comment

by:jskfan
ID: 24423252
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?
0
 

Author Comment

by:jskfan
ID: 24423256
Microsoft should have the link, but couldn't find one.
0
 

Author Comment

by:jskfan
ID: 24423917
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
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24428108
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.
0
 

Author Comment

by:jskfan
ID: 24431136
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?
0
 

Author Comment

by:jskfan
ID: 24431164
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.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24431365
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.
0
 

Author Comment

by:jskfan
ID: 24431482
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
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 24431552
Ok.. Making it more clear

Load Balancing Cluster can be done with SQL Server 2005 Standard edition in Windows 2003 Standard edition as it uses NLB

Failover Clustering cannot be done with SQL Server 2005 Standard edition in Windows 2003 Standard edition as it requires Cluster Service which is not available in Windows 2003 Standard edition.

An reference for this
http://www.vi.net/hosting/database_hosting.html
0
 

Author Comment

by:jskfan
ID: 24452421
assuming the link is trustful.....
http://www.vi.net/hosting/database_hosting.html

Excellent Clarification
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question