Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Setting up a SQL cluster under MS VS2005 R2 Part1 Expand / Collapse
Author
Message
Posted Wednesday, May 13, 2009 12:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 6,291, Visits: 13,552
Comments posted to this topic are about the item Setting up a SQL cluster under MS VS2005 R2 Part1

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #715689
Posted Wednesday, May 13, 2009 7:20 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
Great article Perry! And very useful given the trend toward virtualization these days.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #715947
Posted Wednesday, May 13, 2009 9:02 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 25, 2012 8:14 AM
Points: 567, Visits: 512
Thank you so much Perry. This is one of best articles written in a while. VERY RELEVANT!!
Post #716085
Posted Wednesday, May 13, 2009 9:16 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Very well written step by step article. I for some reason always like articles / SOP with screen shots. They are easy to understand and for a good presentation.

SQL DBA.
Post #716106
Posted Wednesday, May 13, 2009 9:18 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
SanjayAttray (5/13/2009)
Very well written step by step article. I for some reason always like articles / SOP with screen shots. They are easy to understand and for a good presentation.


And another reason, Screen shots make SOP longer and Manager's always love to see them.


SQL DBA.
Post #716109
Posted Wednesday, May 13, 2009 10:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 15, 2009 11:12 PM
Points: 1, Visits: 4
Thanks Perry for great article. Awaiting for second part
Post #716632
Posted Thursday, May 14, 2009 1:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 30, 2014 4:30 AM
Points: 174, Visits: 179
When host machine attached to existing domain you don't really need third machine running domain controller.

Loopback adapter provides sufficient utility to configure public network for cluster and expose Virtual Instance IP through route built to host external adapter.

An inconvenience is when connecting to SQL Server Instance need to specify port in the connection string ( alternately one could configure an alias on the client )

It would be really nice if Browser service could be installed separately and bound to an IP ( or FQDN ) with Port ( an address as opposed to installed SQL Server Instance ). Would be very helpful in solving above inconvenience.
Post #716695
Posted Thursday, May 14, 2009 3:05 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 1:42 AM
Points: 448, Visits: 322
Excellent article Perry and here is another set of articles that might be an interesting read for the users on the same topic. Hope you guys find these articles useful.

ArticleName: SQL Cluster Setup Checklist
Link:cluster setup checklist


ArticleName: How to create SQL 2005 Cluster on a virtual server (5 part series)
Link:Part1

Link:Part2

Link:Part3

Link:Part4

Link:Part5

Regards,


-Hope is a heuristic search ~Hemanth
Post #716728
Posted Friday, May 15, 2009 10:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 6,291, Visits: 13,552
thank you for all the +ve comments, i just hope this is useful to you all somehow. Its great for testing and if you blow away the cluster you dont have to get embarrassed and start typing your resume (leaving out the bit about hosing the companies sql server cluster )

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #718096
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse