Network Load Balancing Service & Sql Server

• JohnMarks

  Newbie

  Points: 0

  More actions

  August 6, 2004 at 11:38 am

  #88371

  Currently we use transactional replication to push data from a OLTP server to a single reporting server (both using Sql Server 2k Ent Edit).  I want to add another subscriber to the replication topology so that 2 db servers are able to handle the reporting requests. 

  Our reports are written in ASP.Net and we use IIS 6.  We also are using Reporting Services on another server.  I would like the IIS server and the Reporting Services to utilize the 2 db servers equally.   Ideally I would like to put a load balancer between the 2 reporting servers and the 2 db servers but budget contraints prohibit that.  Is it possible to use the Windows 2003 network load balancing service on the 2 db servers so that data requests comming from the 2 reporting servers are split across the 2 db servers? 

  Thanks

   

• salim

  Newbie

  Points: 0

  More actions

  August 8, 2004 at 12:21 am

  #518105

  I am not sure w2003 loadbalancing is meant to works with sql servers.

  What you can do is :

  1 - Make the 2 db servers are identical in schema and data

  2 - Run win2003 network loadbalancing on the 2 IIS machines and make IIS 1 point to DB 1 while IIS 2 points to DB 2

   

• sa24

  Newbie

  Points: 0

  More actions

  August 8, 2004 at 8:08 pm

  #518114

  SQL Server does not support network load balancing. Yukon also does not have this feature. I think we might have to wait for the next product release.