Setting up FogBugz using Network Load Balancing
Using FogBugz on an NLB system is pretty much the same as running FogBugz on a single server.
- Choose 1 machine (M1) to be your main FogBugz server.
- Run the installer on M1 as normal, creating your database and users, etc
- Run the installer on the other machines (M2, M3, etc) except choose "Access" as your database.
- Using regedit on M1 go to
HKLM\Software\Fog Creek Software\FogBugz\[path to your install]
- Look for the value sConnectionString and copy the value.
- Go to M2, M3, etc and replace the sConnectionString on those machines with the value you copied from M1.
- Finally, you only need one FogBugz maintenance service running, so go into the Services control panel on M2, M3 and find the FogBugz Maintenance service. Stop it, then right-click choose properties and set its startup to Disabled so it does not start automatically.