Change EPM servers' names

[Turki Ben Sumih]

Dears
I have EPM small-scale environment that is outside domain. now i'm assigned
the following tasks:
1.Change application server name from A to C for example
2.Change SQL server name B to D for example
3.Join them to the domain
So dears what should i do first regarding rename the servers and what i
should do with services that are related with servers' name.
Thanks and i really appreciate your cooperation.

 

[Manmeet Chaudhari]

Hi,
Changing the name of the server is not an easy process. You can do the
following however:
Backup your databases,
Uninstall SQL,Project Server and WSS
Rename the server
Install server, restore the database
Install Project Server connecting to the existing database
Hope this helps


Thanks and Regards,
Manmeet Chaudhari

 

[Turki Ben Sumih]

WAW !
is there any altenative way without reinstall thses services ! please Help 1

 

[Manmeet Chaudhari]

Hie,
I know it is a very cumbersome method.
But i dont think there is any other way out. --

Thanks
Manmeet Chaudhari

 

[FaisalM]

The other way it far more difficult than the process what Manmeet mentioned.

I renamed one of my box few months back due to company policies. Everything
(Project/SQL/WSS/IIS) was on the same box. It took me a lot of time to fix
those issues. But now the server is running with new name without any issue.

I noted few steps in random at that time. I wish I could have saved all the
steps. Will try to replicate the scenario sometime later & will post the
document.

For now here are some random steps (you might get different errors as per
your configuration/environment):

- Backup your DBs. If possible make an image of the system (with Norton
Ghost) or something similar. That way you can always revert back to original
state.

- Note down (or make screen shots) all the configurations on the system
like. DB names, ports used, admin login, IPs, etc..

- After changing name you might get ... Project DB can't be accessed (5001)
or similar error message when you try to access PWA site.

- WSS site might give ....'Can not connect to Config DB' or simiar error.

- In SQL Enterprise Manager go to WSS DB > Tables. Check tables SERVERS &
SERVICES. Make corrections

- Use EDITSite.exe tool to update ODBC connection & update site changes.

- If using OLAP, then create OLAP Admin login in SQL > Security & assign it
to Analysis DB.

- Open Analysis Services Manager > Right clikc Server name & select Edit
Repository Connection String. Make sure string shows the new server name.

- If you have Portfolio Analyzer views, then go to PWA > Admin > Manage
Views. Modify each Portfoliio Analyzer view & correct the name of Analysis
Server in each view.

- I remember I also changed / removed references of old name in registry.

- For error messages always check Event Viewer.

In my case the server was renamed within the same domain.

Let us know about your endeavour.

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Turki Ben Sumih]

thanks Dears,
i will try your solution and please inform me if you found an easy way to
overcome my isssue.