Changing SQL Passwords for Project Server

C

Cameron McShane

I have just taken over the administration of a Project Server 2003
server. I am in the process of migrating the server to a new Windows
2003 server. Unforuntately, the person that installed it originally
cannot recall the passwords used for the SQL connections using the
following accounts - MSProjectServerUser & MSProjectUser. During the
install on the new server when using the existing databases, these
passwords are required. Is there a way to retrieve or change these
passwords by directly manipulating the database tables?

If anyone can help, it would be greatly appreciated.

Cheers


Cameron
 
S

Steve

Use the EditSite tool in conjunction with SQL Enterprise Manager to
change the passwords stored by EPM and the passwords themselves,
respectively.
 
M

MZeeshan

I have exactly the same problem as I had to recreate the database environment
and somehow the passwords were not transferred correctly.

What is this EditSite tool? Can someone please explain?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Initialsetup issue - repost 0
SQL Authentication may fail when migrating from SQL 2000 to SQL 20 0
Project Portfolio Server 2007 - Active Directory Authentication? 2
Prevent access to Old Project Server 2
Outlook disconnected from Exchange 1
Reset Permissions for Project Web Access Site 3
Project Server 2003 Install 1
project tracking 7

Top