Thursday, September 24, 2009

Sharepoint Migration

Currently working on migrating the databases for a MOSS 2007 install from one SQL Server to another. To be more precise, I am moving the database from one instance on one node of a clustered SQL Server to the clustered instance of the SQL Server itself. Anyway, have been working though Ammed Ammar's excellent instructions (I found them here). Had moved my Admin_Content db, and was in the process of moving the Config db when I hit a roadblock. Was using the psconfig.exe command to reconnect to my now migrated Config database and kept on getting the dreaded "The server parameter specified with the configdb command is invalid. Failed to connect to the database server or the database name does not exist. Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server. To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_9_24_2009_11_5_7_53_419108824.log. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access." error ...

Couldn't work out the appropriate username and password to connect to the database for this command ... I finally found a solution by fluke. Ammed suggest the following command to reconnect the config database:

psconfig.exe -cmd configdb -connect -server "newsql" -database "SharePoint_Config" -dbuser "mossdbcreate" -dbpassword "Aaa123456" -user "DOMAIN\USER" -password "user_password"

If that doesn't work, try running the cmd exe from your mossdbcreate account using "runas /user:Doman\mossdbcreate /noprofile cmd.exe" and then use the following simplification of the psconfig command:

psconfig.exe -cmd configdb -connect -server "newsql" -database "SharePoint_Config" -user "DOMAIN\USER" -password "user_password"

Worked for me, anyway. Let me know if it helps you out.

No comments: