proejct server 2007 creating spurious extra databases

L

lynne

Hi all
We have very recently installed Project Server 2007. Originally it
was installed with the default sql express thingy rather than the full
on SQL 2005, and as we wanted Analysis Services we purchased the full
SQL but have yet to install it.
We've got a spot of bother now in that somehow there are extra
databases being created! So far we have 3, 2 of which we have no idea
of their origin. This results in us not being able to see the PWA,
getting an Access Denied error.
Please can you help?
We'd like to know how this has happened so we can prevent it happening
again, and we'd like to know how we can point the PWA at the correct
database so we can see it all again.
Many thanks
lynne
 
N

Nico Oosthuysen

Hi Lynne,

It does seem as if you have gotten yourself in a bit of a mess. to start
off with, the following is a list of databases that is probably in every
installation by default:

SharePoint_Config
SharePoint_AdminContent<GUID>
WSS_Content
WSS_Content<GUID>
SharedServices1_DB
WSS_Search_<Servername>
ProjectServer_Archive
ProjectServer_Draft
ProjectServer_Published
ProjectServer_Reporting.

So its a couple of databases. Secondly, you will need someone who is good
with SQL Server to upgrade your installlation from Express to Standard. I
am not sure how to do that, but my first inclination would be to try and
backup\restore the DBs from Express to the Standard, or perhaps a
Detach\Attach between the 2.

In terms of your access denied error, perhaps try logging on with the
acocunt that was used to install project server initially?

regards,
Nico
 
Top