database name is changing as well as the SQL server name and alias

[Gina]

This is actually a two part question.

In about a week, our database name is going to change. Currently it is
ProjectServer0000 and will be changing to something else. I noticed on the
Project Server, there is a system DSN that was automatically created during
installation called PC11DSN. It is configured with a SYSTEM account;
therefore, when I want to change the default database to connect to, I cannot
access that window where it needs to be changed.

Does anyone know how I can change this?

The second part of the question is that we will be changing the server name
and instance name. I know how I can change this in the system dsn; however,
I'm wondering what impact that will have on web server and/or the desktops
that connect to the database.

Thanks in advance for any help.
Gina

 

[Gary L. Chefetz [MVP]]

Gina:

You'll want to go to Microsoft downloads and grab a copy of the EditSite
utility, aka Site Editor. Make sure you download the 2003 version. This
utility will allow you to edit site attributes in the registry as well as
recreate a DSN.

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

 

[Gina]

Excellent. I just did this and it appears it will allow me to do everything
I will need to do to accomodate the server name, database name and alias
changes.

Thanks!