Migrating Sharepoint and databases
We are migrating WSS 3.0 to a new server and the SQL Databases from SQL 2005 to another server running SQL Server 2008. When we run the following: stsa dm -o addcontentdb -url http://<sharepoint site> -databasename wssintranet_content - databaseserver <Server Name>\Instance-databaseuser <User> -databasepasswo rd <password> Gives the following error: [SPManager] [ERROR] [3/26/2010 9:01:05 AM]: Cannot find the object "DatabaseInformation" because it does not exist or you do not have permissions. Any ideas? Bill Lugaila william.lugaila@state.co.us
March 30th, 2010 4:53pm

Hi William, Assumptions The dbs have been restored to the new server, The db server is your default db server for the farm, you are logged in as the Farm Administrator stsadm -o addcontentdb -url "http://YourWebApp" -databasename YourdDatabaseName if not the default db server for the farm but all other assumptions are true stsadm -o addcontentdb -url "http://YourWebApp" -databasename YourdDatabaseName -databaseserver YourDbServerName Cheers, Ivan Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2010 10:39pm

William, I got the same error while trying to upgrade to WSS 3.0 SP2. The issue was related to having different WSS versions in farm. Make sure that the WSS version is exactly same on both the source and destination servers. Let me know if it helps. Thanks, Praveen http://www.praveenmodi.com
March 31st, 2010 2:16am

Isn't what I used the same? stsadm -o addcontentdb -url http://<sharepoint site> -databasename wssintranet_content -databaseserver <Server Name>\Instance -databaseuser <User> -databasepassword <password> Yours: stsadm -o addcontentdb -url "http://YourWebApp" -databasename YourdDatabaseName -databaseserver YourDbServerName The database server is on a different server than the web server hosting SharePoint. I have checked all permissions and all accounts.
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2010 3:53pm

They are both the same version.
March 31st, 2010 3:54pm

Hi William, Its hard to tell from your syntax the use of <>, username, and password. If you are pasting exactly what you enter except the names have been changed to protect the innocent, then your syntax is incorrect.... If your using -username it sholuld be "DomainName\UserName" -password "Password" the quotes are important. Dont use <> these are just used for documentation and your use of <> is inconsistent, if used in documentation the <> should encapsulate the entire parameter, whenever a parameter has special characters // \: etc always use quotes. You can always use the GUI.... Central Administration > Application Management > Content Databases -Ivan Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2010 7:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics