• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 653
  • Last Modified:

Renaming Domain Computers, Problem with local MSDE instance.

Hello experts I'm hoping you may be able to provide some recommendations with our scenario.

The Setup:

Our company uses SQL Server 2000 SP4 as a publisher/ distributor to support custom Tools for our intranet. However, 70% of our users are mobile and as a result we have internally developed an "Offline" version of our Intranet. This allows our users to access the tools and data when they are outside the office, and allows them to update the data locally on their laptop. These users then connect to our Domain using VPN or by physically connecting in one of our offices. After connecting, they can synchronize their MSDE data with the SQL server using Merge Replication with "anonymous pull". We have approximately 100 subscribers to this service.

The question:
      We are considering renaming the clients that use the MSDE locally. We know from experience that if we rename the laptop that it will cause problems with the local MSDE database. When the offline version of our tools is installed it creates a SQL instance on the laptop (ComputerName\Instance). Also the link between the local MSDE and the SQL server is also broken for the same reason. As we would like to rename our Domain attached computers to a standard naming convention, we are wondering if it is possible to fix the SQL problems after the computer has been renamed?
      


Diagram.jpg
0
mullenm
Asked:
mullenm
1 Solution
 
Marten RuneCommented:
Use the tool cliconfg

Here you can make a alias for sql. i e tweak the connection OldComputerName\InstanceName = . and a port number.

This would do the trick. Now every time the app calls for \\OldComputerName\InsetanceName it will default to localhost and teh port number of your choice (use the port number of your instance ofcourse).

/Marten
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now