Skip to main content

How to shift or transfer complete sharepoint from one computer to another

Dear All,
Today I face a problem to shift the sharepoint farm and site collection from one Server to another I have virtual machines i made the virtual machine copy but i need to change the name of server because my existing and new both machines is  a part of network, because of it the server and datbase name has changed and SharePoint stop with the following error:

could not connect with the database. 

 After the detail study i found the following solution

SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name

(But the orginal URL is not full solution i made the changes in step 3 to work properly) 

Here are the fixing points
1) Open the windows command prompt by Start > Run >CMD

2) Locate to following location
C:\cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN
(Note: make sure in my case its 14 directory some time it's 12 or 15 or 16 please make sure the directory name after web server extensions through your local drive) 

3) Put the following command 
stsadm.exe -o setconfigdb -databaseserver yoursqlserverinstance\sqlusername -farmuser yourdomainName\username -farmpassword yourserverpassword


3. Go to IIS, All Programs>>Administrative Tools>>Internet Information Service (IIS) Manager.
Remove the Central Administration Collection Site & The Application Pool 

4) Rerun the Central Administration Configuration Wizard through 
Programs>>Microsoft Office Server >> SharePoint Product and Technologies Configuration Wizard

After that you have new site collection ready with Fresh Central Administration 

Now you need to make the site collection backup from the existing server and restore here for backup and restore please review my previous blog http://bvs-sharepoint.blogspot.com/2014/01/sharepoint-foundation-2013-site.html

I hope it save your lot of time 

Regards 
Rashid Imran Bilgrami 
CEO Best visualization 

Comments

Post a Comment

Popular posts from this blog

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code   protected override void OnInit(EventArgs e)         {             base.OnInit(e);             InitializeControl();             // Register the ScriptManager             ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);             if (scriptManager == null)             {                 scriptManager = new ScriptManager();                 scriptManager.ID = "ScriptManager1";                 scriptManager.EnablePartialRendering = true;       ...
23 comments
Read more

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  
Post a Comment
Read more

SharePoint calculated column and hyperlink or Link (no workflows or scripts needed)

This is a process how you make the Link column in your sharepoint link original url Create a calculated column which concatenate the url text with an existing column value. This seems to be an easy task, except one thing: SharePoint doest not render hyperlink in calculated column by default. For example, I have a list with 2 columns: Search term and Google Search. Google Search is a calculated column with this formula Now, this is what I will get by default: There are a few ways to fix this problem. Usually people will recommend you to create a Hyperlink column instead and create a workflow to update the Hyperlink value ( http://social.technet.microsoft.com/Forums/ar/sharepoint2010customization/thread/32d32e47-3256-4806-8775-c250b6243038 ) . Or, you can place a script on the page that loop through the HTML nodes and replace the unfriendly html tags with a hyperlink as described here http://practicalsharepoint.blogspot.com/2011/10/dynamic-hyperlinks-in-calculated.html ...
7 comments
Read more