Unique Situation: Project Server connecting to WSS SharePoint Serv

[Al]

Sorry about the details and wordiness in advance (PLEASE READ)....

After three days of searching and trying to do it myself; I need help!

Dev dB = mps2K3sqldev
Prod dB = mps2K3sql

I was recently testing WSS Site Creation in a development environment
thinking it was (mps2K3sqldev). However the development WSS database
(mps2K3sql) was pointed to the production environment after a restore back in
December 2005. Learing the hard way!

I create a top level web site on http://serverdev:8082/ for the PMO
Department to test the feature. I deleted the website because I did not want
it under the /root...

Because the WSS database (mps2K3sql) is the production environment everyone
see the error message on Home Page: There is a problem establishing a
connection with the Web server running Windows SharePoint Services. Contact
your system administrator.

We'll I am the Project Server Admin and have moderate experience with
SharePoint. I did review and perform the steps outlined in the MSPS2003
Disaster Recovery Guide and Chapter 6 of the Admin Guide. Also ran Conn and
WSS Wizard Tools... Search usergroups,,, ran iisrest and the works

I can access Issues, Risks, and Documents as normal but the summary of these
items are not appearing on the homepage to let user know of any new issues
exsist. Email Notification is turned off at this point.


How do I start all over from strach with the WSS Production dB? Or get the
connection state back.. If this email is not clear please let me know..
Really need help on this one...

 

[John]

Sorry about the details and wordiness in advance (PLEASE READ)....

After three days of searching and trying to do it myself; I need help!

Dev dB = mps2K3sqldev
Prod dB = mps2K3sql

I was recently testing WSS Site Creation in a development environment
thinking it was (mps2K3sqldev). However the development WSS database
(mps2K3sql) was pointed to the production environment after a restore back in
December 2005. Learing the hard way!

I create a top level web site on http://serverdev:8082/ for the PMO
Department to test the feature. I deleted the website because I did not want
it under the /root...

Because the WSS database (mps2K3sql) is the production environment everyone
see the error message on Home Page: There is a problem establishing a
connection with the Web server running Windows SharePoint Services. Contact
your system administrator.

We'll I am the Project Server Admin and have moderate experience with
SharePoint. I did review and perform the steps outlined in the MSPS2003
Disaster Recovery Guide and Chapter 6 of the Admin Guide. Also ran Conn and
WSS Wizard Tools... Search usergroups,,, ran iisrest and the works

I can access Issues, Risks, and Documents as normal but the summary of these
items are not appearing on the homepage to let user know of any new issues
exsist. Email Notification is turned off at this point.


How do I start all over from strach with the WSS Production dB? Or get the
connection state back.. If this email is not clear please let me know..
Really need help on this one...

Al,
This question should be posted to our server newsgroup as this newsgroup
is primarily for the desktop version of Project.Try
microsoft.public.project.server

John
Project MVP

 

[Al]

I was excited to get the feedback... Maybe this is why my previous questions
were never answered,, I started posting 08/2005 and never got any assistance
but I happy to get this response...

 

[John]

I was excited to get the feedback... Maybe this is why my previous questions
were never answered,, I started posting 08/2005 and never got any assistance
but I happy to get this response...

Al,
Most of the MVPs do check all newsgroups, but not necessarily every day.
If you haven't been getting a response, it may be because the server
guys were busy with questions in the server newsgroup and therefore
haven't checked this newsgroup.

John