Solved

MicroSoft, SQL Server, 2005, Large Domain, SharePoint Servers (NLB), one SQL Server, forced server(s) name change

Posted on 2008-06-19
5
194 Views
Last Modified: 2010-04-21
We have set up a development SharePointServer 2007, connected to a stand alone SQL server, which we are running in a AD Domain. Everything has been setup and is working properly. We were just advised we need to change the name of all the servers, URL's etc. , to accomodate an organizational name change.  I am only responsible for the SQL side, another team has the MOSS 2007 side. I do not have to change the names of the individual databases - those can remain the same.

The reseach I have done so far, indicates I should be able to rename the server with a stand-alone instance of SQL Server 2005. I have found information on renaming the report server. Backups are performed using LiteSpeed for SQL, and I should be able to modifiy those jobs. Am I missing anything? What else needs to be considered? Will I need to detach the databases from the old server, and reattach on the new? Is there a better way?

I would appreciate what ever help I can get. I am completely at a loss with this one.

0
Comment
Question by:chapmancd
  • 3
  • 2
5 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
Comment Utility
If you are doing a completely new server/instance a couple of things I do/use to do cutovers/moves.

1. Beyond Compare from www.scootersoftware.com. At the cost -- it has given us something like 5000 times the payback. That is how I copy the mdf/ldf files.

2. Don't detach the databases, just take them offline (best from a QA window with Alter database DBName set offline with immediate rollback)  That way your backoff is much quicker if you would have to do it.

3. Get the sp_help_revlogin (http://support.microsoft.com/kb/918992) to transfer userids between the servers.

4. Make sure you keep the BOL (books online) handy.

5. I have these KB articles memorized:
http://support.microsoft.com/kb/314546
http://support.microsoft.com/kb/224071
Good to bookmark them and refer to them. They are actually quite well written.

0
 

Author Comment

by:chapmancd
Comment Utility
jimpen,
Thanks for the assistance. Will review the recommended documents today. Looking to do move over the next week to ten days (hope closer to the ten day mark). Will comment on line again before I leave for the day with any additional questions, comments, concerns. Thanks again,

Cory
0
 

Author Comment

by:chapmancd
Comment Utility
JIMPEN, Sorry it took so long to get back - things changed in our setup almost before I was done with my last entry. I was able to use the information you provided, but on a different issue.

With my original problem, we used stsadm.exe to invoke the "renameserver" command option on the MOSS 2007 servers (frontends, index and search servers) to rename all of the servers in the SPS farm, based on information found in the following two links:

http://msdn.microsoft.com/en-us/library/ms178083.aspx

http://technet.microsoft.com/en-us/library/cc263117(TechNet.10).aspx

The process looked like this:
1) Take a backup of the SQL Database before performing the following operations.
2) Rename the SQL Server from My Computer > Properties > Computer Name > Change
3) Reboot the Server when prompted to do so.
4) After reboot of the SQL Server is complete > Open a Remote connection to the
SharePoint Server.
5) Start > Run > Cmd
6) Change to the Directory C:\Program Files\Common Files\Microsoft Shared\Web
Server Extensions\12\BIN 
7) Run the command Stsadm -o renameServer -oldservername
Old_Database_Server_Name -newservername New_Database_Server_Name 
8) After the command completes successfully > Reboot the SharePoint Server (Even if
not prompted for the reboot)
9) Once the server has rebooted > Browse to the SharePoint Central admin page and
check if the SQL Server shows up with the new name on the home page.

The only problem I was left with, I had to go back and modifiy all of my backups to accomodate the servers new names.

Thanks again for the assistance. Points have been awarded.

Cory
0
 

Author Closing Comment

by:chapmancd
Comment Utility
The information you gave was on spot. We just changed direction mid-stream. Thanks for the assistance.
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

744 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

17 Experts available now in Live!

Get 1:1 Help Now