Prod/QA mixup in WSS

[Billg_sd]

I copied our production ProjectServer DB to the QA box for some testing.
On the QA Box, I reconfigured the 'Connect to Sharepoint Server' options to
point to QA's WSS site. It works fine.

However, in PROD ProjectServer, people are now getting errors when they try
to upload documents/issues or other sharepoint contributions. They get the
'Windows Sharepoint Services cannot access info from Project Server..."

Project Server URL :http://QABox/ProjectServer/
Sharepoint URL: http://PROD Box/

How could the PROD configuration point to QA? I searched the config/content
databases in PROD and cannot find any reference to the QA box. Any ideas as
to how this happened? How to fix it?

 

[Rick Roszko]

As for how to move the MSPS and SPS correctly, you need to follow some
stringent rules for moving the databases, see:

http://support.microsoft.com/kb/905386

Your move broke some connections and kept old ones. There's no "undo" so
you will have to figure what went wrong where... The doc above should give
you pointers.

Also, make sure your MSPS copy on the QA server points to the QA SQL server
or you will have a mess with the OLAP cube build also...