none
Erro ao tentar configurar o Analisys Services no Project Server 2007 +SQL Server 2005 Ent - Ajudem pls RRS feed

  • Pergunta

  • ola Amigos

     

    estou com um problema e gostaria da ajuda de voces.

     

    Acabamos de implementar o Project Server 2007 em um servidor VM para homologacao.

    01- Server Windows Server 2003 R2 SP2 + SharePoint + project Server 2007

    01- Server Windows Server 2003 R2 SP2, Microsoft SQL Server 2005 SP2 Ent.

    Obs: O banco esta em outro servidor conforme descrevi.

    Quando abro a tela de gerenciamento do Project server 2007,

     

    Recebo a seguinte mensagem de erro:

    Build Status

    Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server NA1000SPDEV23 . Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0

     

    Build Tracking Comments

    Detailed logging of the cube building process

    ===== Initiating cube build process =====
    [5/28/2010 10:13 AM] Cube build request message has been added to the Project Server queue
    ===== Verifying and running pre-build server event handler =====
    [5/28/2010 10:13 AM] Verifying and running pre-build server event handler
    ===== Determining database and cube structure =====
    [5/28/2010 10:13 AM] Cube build initialization started
    [5/28/2010 10:13 AM] OLAP database and cube structure was determined successfully
    ===== Building database and cubes =====
    [5/28/2010 10:13 AM] Cube build session started
    [5/28/2010 10:13 AM] Analysis Services session started
    [5/28/2010 10:13 AM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server NA1000SPDEV23 . Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).
    ===== Process Completed =====
    [5/28/2010 10:13 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server NA1000SPDEV23 . Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

     

    Grato


    Julio Vaz
    sexta-feira, 28 de maio de 2010 15:33

Respostas

  • Ola Hércules Garcia

    meu amigo, eu consegui resolver o problema, estava com falta de permissoes no, segue este link http://technet.microsoft.com/pt-br/library/cc197552(office.12).aspx

     

    Apos ter efetuado estas alteracoes, estou conseguindo sem maiores problemas.

     

    veja o log agora como esta bem diferente:

    ===== Initiating cube build process =====
    [6/9/2010 3:25 PM] Cube build request message has been added to the Project Server queue
    ===== Verifying and running pre-build server event handler =====
    [6/9/2010 3:25 PM] Verifying and running pre-build server event handler
    ===== Determining database and cube structure =====
    [6/9/2010 3:25 PM] Cube build initialization started
    [6/9/2010 3:25 PM] OLAP database and cube structure was determined successfully
    ===== Building database and cubes =====
    [6/9/2010 3:25 PM] Cube build session started
    [6/9/2010 3:25 PM] Analysis Services session started
    [6/9/2010 3:26 PM] Analysis Services session completed successfully
    ===== Verifying and running post-build server event handler =====
    [6/9/2010 3:26 PM] Verifying and running post-build server event handler
    ===== Processing OLAP database =====
    [6/9/2010 3:26 PM] Process OLAP database session started
    [6/9/2010 3:26 PM] Analysis Services session started
    [6/9/2010 3:26 PM] Analysis Services session completed successfully
    ===== Verifying and running post-process server event handler =====
    [6/9/2010 3:26 PM] Verifying and running post-process server event handler
    ===== Process Completed =====
    [6/9/2010 3:26 PM] Cube build request completed successfully.

    Valeu por sua ajuda amigo.

    Sua resposta ja esta classificada.

     

    Atenciosamente

     


    Julio Vaz
    • Marcado como Resposta Richard Juhasz quarta-feira, 10 de novembro de 2010 21:01
    quarta-feira, 9 de junho de 2010 20:27

Todas as Respostas

  • Olá Julio.

    Para que o EPM consiga processar/acessar o cubo é preciso ter instalado no servidor de aplicação os componentes do DSO. Você já os instalou?

    Pela mensagem parece que não. Instale-os e tente criar o cubo novamente. Os componente que deve ser instalados são:

    • Microsoft SQL Server Native Client (sqlncli.msi)
    • Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi)
    • Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi) 

    Até mais.


    Hércules Garcia hgagarcia@hotmail.com
    terça-feira, 8 de junho de 2010 17:09
  • Ola Hércules Garcia

    meu amigo, eu consegui resolver o problema, estava com falta de permissoes no, segue este link http://technet.microsoft.com/pt-br/library/cc197552(office.12).aspx

     

    Apos ter efetuado estas alteracoes, estou conseguindo sem maiores problemas.

     

    veja o log agora como esta bem diferente:

    ===== Initiating cube build process =====
    [6/9/2010 3:25 PM] Cube build request message has been added to the Project Server queue
    ===== Verifying and running pre-build server event handler =====
    [6/9/2010 3:25 PM] Verifying and running pre-build server event handler
    ===== Determining database and cube structure =====
    [6/9/2010 3:25 PM] Cube build initialization started
    [6/9/2010 3:25 PM] OLAP database and cube structure was determined successfully
    ===== Building database and cubes =====
    [6/9/2010 3:25 PM] Cube build session started
    [6/9/2010 3:25 PM] Analysis Services session started
    [6/9/2010 3:26 PM] Analysis Services session completed successfully
    ===== Verifying and running post-build server event handler =====
    [6/9/2010 3:26 PM] Verifying and running post-build server event handler
    ===== Processing OLAP database =====
    [6/9/2010 3:26 PM] Process OLAP database session started
    [6/9/2010 3:26 PM] Analysis Services session started
    [6/9/2010 3:26 PM] Analysis Services session completed successfully
    ===== Verifying and running post-process server event handler =====
    [6/9/2010 3:26 PM] Verifying and running post-process server event handler
    ===== Process Completed =====
    [6/9/2010 3:26 PM] Cube build request completed successfully.

    Valeu por sua ajuda amigo.

    Sua resposta ja esta classificada.

     

    Atenciosamente

     


    Julio Vaz
    • Marcado como Resposta Richard Juhasz quarta-feira, 10 de novembro de 2010 21:01
    quarta-feira, 9 de junho de 2010 20:27