Any assistance you can provide would be appreciated. Here are the steps I went through:
Backed up content and config databases.
Removed the Web Applications in the Sharepoint Admin site (leaving the content databases).
Reran the Sharepoint Technologies Configuration Wizard. Here is where things started not performing as expected. Previously when I have done this, it would give the option to disconnect from the farm, but this time it acted as if it was repairing the installation, and gave me no options at all.
I restored a snapshot, and began again, doing the same thing, but leaving the Web Applications in tact after the backup of the SQL databases. Same effect with the configuration wizard.
Restored again, and attempted to use the built in 'Backup' and 'Restore' functionality. This seems like it would have worked, but when restoring the backup, and selecting the new SQL server name, it was unable to connect, and never prompted me for the password. If I reattached the databases on the new server, and ran the restore again, it seemed to get farther, but was trying to pass the DOMAIN\COMPUTERNAME$ as the credentials, and I am not aware of a way to grant permissions to a SQL database to a machine account. So ultimately, this failed as well.
Restored one last time, and physically moved the databases over in SQL. This worked fine, as expected. I removed and re-added the content databases fine using stsadm, and removed the config database fine, but when I tried to read the config database using stsadm -o setconfigdb, it gave back an 'Access Denied' error every time. This didn't appear to be a password issue, as when I used the wrong password or user account for any field, it immediately failed with and error such as 'invalid user or password'.
If you have any suggestions or can point me in the right direction, I would truly appreciate it.
Start Free Trial
