Restoring SharePoint 2007 on a new server

This is my scenario.

I have one server running AD, SQL 2008, MOSS 2007 SP2 and wanted to separate the AD into one server and MOSS into a new server. This is what I did (and definitely not as simple as I thought it would be!)

  • Leave the AD server as it is
  • Install Windows, SQL, MOSS on the new machine
  • Format and install AD on the first server
  • Re-join the MOSS server to the Domain
  • Create all required SharePoint accounts in the AD
  • Now, you will have your SharePoint site giving an HTTP 404 error mostly
  • If you check the EventVwr, you will have "Cannot open database...Login Failed" error for the SharePoint content access account
  • You need to delete this user from the AdminContent database and re-add by giving that respective login
  • After that, you need to re-create the Schema as well (Ensure the particular admin account for example domain\spadmin is scripted in a notepad and kept
  • Once you do the above, you will have both the Central Admin and Sites opening properly but not the SSP Admin
  • After this - it is best for you to create the SSP using stsadm command instead of the Central Admin UI - because Central Admin UI creation invariably might time out!
  • Once you do this and attach your applications to the SSP, you should just be fine!


Popular posts from this blog

HTTPS Site InfoPath Issue : You do not have permissions to access a web service that provides data required for this form to function correctly

Using External Content Types with Stored Procedures with Input Parameters

Windows 7 Blue Screen because of ConnectiFy