SharePoint 2007 - need to change IP address on database server on a virtual machine.

Posted on 2011-04-18
Last Modified: 2012-05-11
Hi All,

I'm wondering if anyone might be able to offer suggestions about how I would go about the following:

I have a MOSS 2007 test farm with 2 WFEs and one database server.  The database server needs to move to a new location and get a new IP address.  I don't need to change the machine name.  Here is the problem:  the database server is attached to the farm by IP address and not the server name.  When I look in CA at the farm topology, I see the IP address under server, and "Windows SharePoint Services Database" under Services running.

Here is what I am thinking of doing:
1.  Remove the server from the farm by running the sharepoint products and technologies wizard on that server.
2.  Migrate the virtual machine to it's new home and change the IP address.
3.  Add the server back to the farm using the SharePoint products and technologies wizard.

Will this work or is there something I am missing here?

Question by:brl8
    LVL 38

    Accepted Solution

    Obviously this its not good to attach via IP, but you know that now.

    I would try running this command to change to the name BEFORE changint the IP.  Once you are up and running on the name instead of the IP, you can just change the IP no prob.
    LVL 1

    Author Comment

    Thanks, I am trying this, I am running into issues migrating the virtual server.  I will get back to you once I have those resolved.


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
    The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    734 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

    21 Experts available now in Live!

    Get 1:1 Help Now