none
How to instal and configured Project Server 2010,SQLSerevr2008 with DNS Name and SQl alians Name RRS feed

  • Question

  • Hi All,

    I have plan
    to implement Disaster recovery site in futre,I need take care all things during
    production installation of SharePoint and Project server 2010.

    So I need
    to know how to use SQL server DNS name and how to configure SQL alias name.

    and how to use
    DNS name of sql server and alias name of sql server during installation of SharePoint
    2010 and Project server 2010.

    Help is appreciated



    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS



    Sunday, June 9, 2013 7:59 AM

Answers

  • Hi Hassan,

    I hope Following will help you:

    http://msdn.microsoft.com/en-us/library/ms190445.aspx

    http://splog.cairo.ag/2011/02/22/using-sql-server-alias-names-with-sharepoint-server-2010/

    http://support.microsoft.com/kb/168322

    But For Project Server 2010 I would always recommend using a network DNS Alias, the reason creating Excel Services reports.

    Thanks,


    Shafqat Balouch MCT, MCITP, MCPD, Microsoft Partner


    Tuesday, June 11, 2013 6:25 PM
  • When installing Project Server 2010 it is always best practice to use an alias name for the SQL server as this makes life easier should you want to move SQL servers at a later date. This raises the question, SQL alias (using SQL cliconfg utility – pic below) or a network DNS Alias name (CNAME or HOST Record).

    For Project Server 2007 I would have said there weren’t really any advantages for one method over the other but for Project Server 2010 it’s different. For Project Server 2010 I would always recommend using a network DNS Alias, the reason being is to do with creating Excel Services reports.

    When a user either creates a new or edits an existing report in Excel, their Excel client will connect directly to the data source (either Reporting database, custom database or OLAP cube). The ODC file will contain the connection details, SQL server name (alias name if Project Server was installed with an Alias for SQL), and database or cube name. If you installed Project Server 2010 with a SQL Alias on the Application Server, the user’s client machine will not know anything about the SQL Alias name unless you set up the same SQL Alias on all users machines who will create Excel Reports. This is because SQL Alias are only local to the machine that is it created on. Using a network DNS Alias to alias the SQL server will remove this issue


    Alim

    Wednesday, June 12, 2013 10:40 AM
  • I would go with default SQL instance and use DNS Alias.

    Paul


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

    Tuesday, June 11, 2013 8:32 AM
    Moderator

All replies

  • HI Hasan, 

    Just mention the alias name only when running PS Config, 
    no hostname or DNS name just give Alias only-----------Alias nam eg SHAREPOINT-DB

    Thanks 

    Aleem


    Alim

    Sunday, June 9, 2013 11:28 AM
  • Thanks Aleem,

    In future i need change production environment location,like now i have working on DR site location ,but few month later need to shift same environment on Production location.

    On that time same one  will act as disaster recovery site and new one is used as DC(production site).

    Then how DNS name is used there or SQl alia name.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    • Proposed as answer by mafab Monday, December 23, 2013 12:17 PM
    Sunday, June 9, 2013 12:11 PM
  • Hello, I would use a DNS Alias (CNAME or HOST record) rather than a SQL Alias. See this post for explanation: http://pwmather.wordpress.com/2011/07/06/sql-alias-vs-dns-alias-for-project-server-2010-install-ps2010-epm-projectserver/ Paul

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

    • Proposed as answer by mafab Monday, December 23, 2013 12:17 PM
    Sunday, June 9, 2013 4:05 PM
    Moderator
  • Hi Paul.

    this link is not open..

    Not Found, Error 404


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Sunday, June 9, 2013 4:58 PM
  • Hi Paul,

    Can you give me brief description,how to configure DNS Alias with SQL and project server 2010,

    Now I have two box,one for app and ne for DB. and both have DNS name.

    So now I need to install SQL server 2008 first with DNS

    and Alias name.

    And I have DNS name as EPM2010DB,how using  this DNS name

    Kindly guide me.

    Help is Appreciable


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS


    Monday, June 10, 2013 5:44 AM
  • Hello,

    SQL Server is installed as normal. When installing SharePoint / Project Server and you are asked to enter a SQL Server, use the DNS Alias you created.

    Thanks

    Paul


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

    Monday, June 10, 2013 9:34 PM
    Moderator
  • Thanks Paul,

    Means no need to any configuration on sql server box for DNS.

    One more question,Can i create new instance for sql server or use default instance

    is it good if also i use sql instance name with DNS name installation.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    • Proposed as answer by mafab Monday, December 23, 2013 12:17 PM
    Tuesday, June 11, 2013 5:41 AM
  • If you can you the default SQL instance I would do. You can't really use DNS Alias with SQL instance name properly, it would be <dnsalias\sqlinstance> Thanks Paul.

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

    Tuesday, June 11, 2013 6:03 AM
    Moderator
  • ok Paul,

    best practice is go with only DNS name "dnsalias"

    i have requirement after  4 month i need to shift my production environment from one location to new location. In these case i will be create new environment for new production environment and use old one database.and also i have many BI reports and SSRS report 

    In this concept I need only DNSAlias is preferable or  <dnsalias\sqlinstance>.

    suggest me.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS


    Tuesday, June 11, 2013 6:22 AM
  • I would go with default SQL instance and use DNS Alias.

    Paul


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

    Tuesday, June 11, 2013 8:32 AM
    Moderator
  • Hi Hassan,

    I hope Following will help you:

    http://msdn.microsoft.com/en-us/library/ms190445.aspx

    http://splog.cairo.ag/2011/02/22/using-sql-server-alias-names-with-sharepoint-server-2010/

    http://support.microsoft.com/kb/168322

    But For Project Server 2010 I would always recommend using a network DNS Alias, the reason creating Excel Services reports.

    Thanks,


    Shafqat Balouch MCT, MCITP, MCPD, Microsoft Partner


    Tuesday, June 11, 2013 6:25 PM
  • When installing Project Server 2010 it is always best practice to use an alias name for the SQL server as this makes life easier should you want to move SQL servers at a later date. This raises the question, SQL alias (using SQL cliconfg utility – pic below) or a network DNS Alias name (CNAME or HOST Record).

    For Project Server 2007 I would have said there weren’t really any advantages for one method over the other but for Project Server 2010 it’s different. For Project Server 2010 I would always recommend using a network DNS Alias, the reason being is to do with creating Excel Services reports.

    When a user either creates a new or edits an existing report in Excel, their Excel client will connect directly to the data source (either Reporting database, custom database or OLAP cube). The ODC file will contain the connection details, SQL server name (alias name if Project Server was installed with an Alias for SQL), and database or cube name. If you installed Project Server 2010 with a SQL Alias on the Application Server, the user’s client machine will not know anything about the SQL Alias name unless you set up the same SQL Alias on all users machines who will create Excel Reports. This is because SQL Alias are only local to the machine that is it created on. Using a network DNS Alias to alias the SQL server will remove this issue


    Alim

    Wednesday, June 12, 2013 10:40 AM