Hello experts I'm hoping you may be able to provide some recommendations with our scenario.
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.
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?