x

Windows 2008 and SQL 2005 NLB clustering - will it work or can it?

Hi we have 2 Windows 2008 standalone servers that we want to cluster with nlb and then install SQL Server 2005 on. Will or can this work with SQL Server 2005? We don't want to create a domain to create a failover cluster. I know this is a weird setup, but that is how it needs to be configured. Thanks in advance

more ▼

asked Nov 05, 2009 at 01:27 PM in Default

avatar image

Danie
21 1 1 3

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Microsoft claim that this will work, and promote peer-to-peer replication as the mechanism.

The peer-to-peer article in the SQL Server 2005 Books Online -- http://msdn.microsoft.com/en-us/library/ms151196(SQL.90).aspx -- shows the layout for using an NLB cluster in front of two, or more, SQL Server 2005 servers that use peer-to-peer replication to stay synchronized.

more ▼

answered Nov 05, 2009 at 11:00 PM

avatar image

KenJ
24.5k 3 10 19

(comments are locked)
10|1200 characters needed characters left

What are you trying to achieve?

A load-balanced SQL Server? It won't work like that.

High-availability solution - see this question for an alternative.

more ▼

answered Nov 05, 2009 at 01:45 PM

avatar image

Kev Riley ♦♦
64k 48 61 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2018
x106

asked: Nov 05, 2009 at 01:27 PM

Seen: 5862 times

Last Updated: Nov 05, 2009 at 02:11 PM

Copyright 2016 Redgate Software. Privacy Policy