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
mullenmAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.