Advertisement

12.18.2007 at 01:10PM PST, ID: 23031932
[x]
Attachment Details

MSDE Subscriber uses DHCP

Asked by wskorski in MS SQL Server, Dynamic Host Configuration Protocol (DHCP)

Tags: Microsoft, SQL Server, SQL Server 2000, MSDE/DHCP Client Replication

Here is the scenario.

We are a multilocation WAN.

Main Server is SQL 2000 with a db using Merge replication with several subscriber db's  (MSDE and SQL2k).

A new system must be configured that is a laptop.   It will have MSDE.  It will be a suscriber to the merge replication.  It will use DHCP to get it's IP address depending on where in the WAN it is plugged into.

What is the best way to configure the replication to work with the laptop?

The issues:
-On Publisher, all the db's have an Alias set up with there name and IP address.  If DHCP, then nothing to set.
-The laptop is not part of the AD/Domain structure.
-Forcing the user to manually set the ip to a static IP when they are in the office is not feasible.

Suggestions?



Start Free Trial
[+][-]12.19.2007 at 08:30AM PST, ID: 20500711

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.19.2007 at 06:23PM PST, ID: 20504522

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.24.2007 at 02:07AM PST, ID: 20524071

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.24.2007 at 07:46AM PST, ID: 20524999

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.27.2007 at 01:21AM PST, ID: 20533040

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, Dynamic Host Configuration Protocol (DHCP)
Tags: Microsoft, SQL Server, SQL Server 2000, MSDE/DHCP Client Replication
Sign Up Now!
Solution Provided By: twoboats
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628