Renaming Domain Computers, Problem with local MSDE instance.

Posted on 2008-11-17
Last Modified: 2012-05-05
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?

Question by:mullenm
    1 Comment
    LVL 20

    Accepted Solution

    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).


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now