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
Use the EditSite tool in conjunction with SQL Enterprise Manager to change the passwords stored by EPM and the passwords themselves, respectively.
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? -- Regards, MZeeshan "Steve" wrote: > Use the EditSite tool in conjunction with SQL Enterprise Manager to > change the passwords stored by EPM and the passwords themselves, > respectively. > >
You can find documentation on it in the Microsoft Project Server 2003 Installation guide. The editsite.exe download is: http://www.microsoft.com/downloads/details.aspx?FamilyID=6dc2c83e-54e1-40a9-9bb8-2dd293226b6f&DisplayLang=en -- Jonathan Sofer - MCP PM Consultant PCubed - Program Planning Professionals -- "MZeeshan" <mzeeshan@community.nospam> wrote in message news:48C5E611-75AF-4731-AB52-84E63BEA9148@microsoft.com... >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? > -- > Regards, > MZeeshan > > > "Steve" wrote: > >> Use the EditSite tool in conjunction with SQL Enterprise Manager to >> change the passwords stored by EPM and the passwords themselves, >> respectively. >> >>