SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Perry Whittle / Setting up a SQL cluster under MS VS2005 R2 Part1 / Latest Posts

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

Perry Whittle — Fri, 15 May 2009 10:29:57 GMT

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 :-) )

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

hemanth.damecharla — Thu, 14 May 2009 03:05:39 GMT

[size="2"][font="Verdana"]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.[b]ArticleName: SQL Cluster Setup Checklist[/b][b]Link:[/b][u][url=http://blogs.msdn.com/blakhani/archive/2008/06/09/sql-2005-cluster-setup-checklist.aspx]cluster setup checklist[/url][/u][b]ArticleName: How to create SQL 2005 Cluster on a virtual server (5 part series)[/b][b]Link:[/b][u][url=http://blogs.msdn.com/blakhani/archive/2007/12/31/how-to-create-sql-20005-cluster-on-virtual-server.aspx]Part1[/url][/u][b]Link:[/b][u][url=https://blogs.msdn.com/blakhani/archive/2008/01/19/how-to-create-sql-server-2005-clustering-with-virtual-server-2005-part-2.aspx]Part2[/url][/u][b]Link:[/b][u][url=http://blogs.msdn.com/blakhani/archive/2008/01/23/how-to-create-sql-server-2005-clustering-with-virtual-server-2005-part-3.aspx]Part3[/url][/u][b]Link:[/b][u][url=http://blogs.msdn.com/blakhani/archive/2008/06/12/how-to-create-sql-server-2005-clustering-with-virtual-server-2005-part-4.aspx]Part4[/url][/u][b]Link:[/b][u][url=http://blogs.msdn.com/blakhani/archive/2008/06/13/how-to-create-sql-server-2005-clustering-with-virtual-server-2005-part-5.aspx]Part5[/url][/u]Regards,[/font][/size]

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

Miron Berlin — Thu, 14 May 2009 01:56:12 GMT

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.

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

kekerode — Wed, 13 May 2009 22:17:54 GMT

Thanks Perry for great article. Awaiting for second part :-):-)

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

SanjayAttray — Wed, 13 May 2009 09:18:21 GMT

[quote][b]SanjayAttray (5/13/2009)[/b][hr]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.[/quote]And another reason, :-D Screen shots make SOP longer and Manager's always love to see them.

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

SanjayAttray — Wed, 13 May 2009 09:16:26 GMT

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.

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

einman33 — Wed, 13 May 2009 09:02:22 GMT

Thank you so much Perry. This is one of best articles written in a while. VERY RELEVANT!!

RE: Setting up a SQL cluster under MS VS2005 R2 Part1

RBarryYoung — Wed, 13 May 2009 07:20:25 GMT

Great article Perry! And very useful given the trend toward virtualization these days.

Setting up a SQL cluster under MS VS2005 R2 Part1

Perry Whittle — Wed, 13 May 2009 00:26:07 GMT

Comments posted to this topic are about the item [B]Setting up a SQL cluster under MS VS2005 R2 Part1[/B]