Project Server Database Name

[David]

Hi,
Could someone explain why the database name changes from
ProjectServer to ProjectServer0000. How can this be
avoided & what can be done to change name back to
ProjectServer. Has anyone come across such a problem?
Regards,
David

 

[Deepu Chacko]

Hi David,

I faced a similar issue but have no clue as to why it happens ? I guess the
next re-install will make the DB name as ProjectServer0001
I assume that the DB name is stored in registry and incremented each time

 

[Lars Hammarberg]

The incremented number is a result of the MSProjectServerUser and
MSProjectUser SQL accounts not having been deleted prior to re-installation.

/Lars Hammarberg
www.camako.se

 

[David]

So, does this mean that ProjectServer0000 database is
created only on reinstalling Project Server?
What is the option available when the database name gets
changed?

Regards,
David.

 

[Kevin Flanagan]

Before you reinstall you need top delete 2 accounts from
SQL Server 2000 Security Logins: MSProjectUser and
MSProjectServerUser. These accounts are not always
deleted when you uninstall Project Server and if found
during the install are respinsible for setting the 0000
at the end of the ProjectServer database name.

Kevin

 

[Lars Hammarberg]

You could use the EditSite tool (found on the SDK site) to point
ProjectServer to a new db - this db has to be create first, using the tools
on the CD (SUPPORT\DATABASE folder)
Otherwise, why not simply leave the db the way it is? It's only the
SQLServer admin that will ever need to see the name after install....

/Lars Hammarberg
www.camako.se