Steps to Migrate a Web Application between SharePoint 2013 Farms

  1. Create a new web application on the target farm;
  2. Run this command under SharePoint 2013 Management Shell of target farm server with administrator privilege:

Get-SPContentDatabase -WebApplication <url> | Dismount-SPContectDatabase

  1. Delete or detach the related database of this application of target farm;

  2. Attach or restore the database of the source web application to the SqlServer of target farm;

  3. Run this command under SharePoint 2013 Management Shell of target farm server with administrator privilege:

Mount-SPContentDatabase <DBName> -DatabaseServer <DBServerName> -WebApplication <url>

Sharepoint Database Permission

If you wanna deploy Sharepoint 2010 with a SqlServer 2008 R2 ON ANOTHER SERVER, make sure that the domain account which will be used as Sharepoint Service has the dbcreator and securityadmin permission in the target SqlServer.

If securityadmin is not selected, you may have trouble to setup a search service application. All you need is delete the deployed search service application, add permission to SqlServer and re-create a new search service application.

ProjectServer 2007 安装助记

安装ProjectServer 2007时应注意:
1 如果安装的ProjectServer与操作系统的语言版本不同,需将操作系统的区域、语言等相关设置修改为与ProjectServer语言版本相同,否则PWA配置会出错(错误为某数据库唯一键错误)。
2 在安装成功后,如只有本机可以访问而外部访问均提示“发生意外错误”,请操作以下步骤:
a.进入SharePoint 3.0管理中心,左侧选择“操作”;
b.在全局配置中选择“备用访问映射”;
c.将需要被访问的地址(例如IP地址等)在此添加