none
services don't work correctly after changing database server and farm servers name and IP in project server 2010 RRS feed

  • Question

  • Hi every one,

    based on client request  I had to move all farm databases to a new server. also I they asked me to change names and IPs for both WFE and report server. BTW the project server instance work correctly (except from lower performance)

    now I face several issues and any help would be appreciated:

    1- when I go to "servers in this farm" in central administration, I saw the previous names of servers (database, WFE and Report)

    2-excel services doesn't work. I delete previous excel service and create a new one but the problem exists (I think ODCs are the source of problem and their connection string are for previous database server)

    3- project server performance is extremely low and processes in project server queue take longer time to be executed

    just for more information I followed this procedure to move farm databases (http://technet.microsoft.com/en-us/library/cc512725(v=office.14).aspx ) and didn't follow any procedure for changing names and IPs of WFE and report server(I was surprised when SharePoint recognize new servers IP and name after server reset )

    Monday, December 22, 2014 7:08 AM

All replies

  • Hello,

    If you have renamed the SharePoint Server hostnames, look at using the Rename-SPServer PowerShell command:

    http://technet.microsoft.com/en-us/library/cc288510(v=office.14).aspx

    When you originally created the Farm / PWA did you use a SQL Alias / DNS Alias to reference the SQL Server? If so, when you did the SQL migration you should just repoint the alias then the farm including the ODC would work.

    Regarding the performance, is the spec of the new SQL server the same / better that the original SQL Server? Are you using the same storage (SAN) or are you using local disks etc.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Monday, December 22, 2014 9:51 AM
    Moderator
  • Hello,

    If you have renamed the SharePoint Server hostnames, look at using the Rename-SPServer PowerShell command:

    http://technet.microsoft.com/en-us/library/cc288510(v=office.14).aspx

    When you originally created the Farm / PWA did you use a SQL Alias / DNS Alias to reference the SQL Server? If so, when you did the SQL migration you should just repoint the alias then the farm including the ODC would work.

    Regarding the performance, is the spec of the new SQL server the same / better that the original SQL Server? Are you using the same storage (SAN) or are you using local disks etc.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    hi Paul,

    I did database migration about 1 year ago and after that I'm not sure if I check excel services working properly. On the other , I guess I did all procedure including repointing the alias because project server has worked since original database server shutdown.

    how can I ensure myself about ODCs connection and if the problem is related to ODCs or excel services configuration?

    based on the article which was mentioned by you about renaming servers, this is about stand-alone . does it work on farm environment? after renaming IP and name of servers, project server has been working for about 10 days, can I use that command?

    about sql server I'm not sure about SAN or local disk, because I wasn't responsible about it. could give me more information about both method and which one do you recommend?

    Monday, December 22, 2014 1:22 PM
  • Regarding the ODC files, what SQL server is referenced? Is it the correct one? Does it resolve to the correct SQL used today? Are these ODC files the Reporting DB ones or the OLAP cube or both?

    The Rename-SPServer command will rename a SharePoint server that is currently connected to the farm. Have a search on the internet and you will find plenty of information. I would make sure you test any steps on a non critical / non - production system first.

    It doesn't matter either way if you are using local disks or SAN, I was just trying to find out what is different about the infrastructure since the migration. If the system wasn't slow before the migration, what has changed etc. Or has it always been slow?

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Monday, December 22, 2014 1:32 PM
    Moderator