Olá Vitor, bom dia.
Qual o log do visualizador de eventos do Windows do seu servidor de aplicação relacionado a este problema? Chega a registrar alguma informação?
Para que o serviço consiga funcionar o usuário de serviço precisa ter permissões de leitura e gravação no banco de dados.
Outro ponto chega dar alguma mensagem de erro ao executar os relatórios de exemplo do BI? Se sim, post aqui.
Hezequias Vasconcelos
Boa tarde Hezequais.
O eventvwr não gera log relacionado.
O Secure Store está corretamente configurado e a conta do Application ID em "Set Credential" é uma DataAccess com Permissão db_reader na base Reporting. Não dei permissão de escrita, pois quero que estes usuários apenas vejam os relatórios. detalhe
que nem mesmo o FarmAdmin consegue abrir esses relatórios de exemplo, sendo que ele é dono da base e administrador dessa target application.
Eu nem criei relatórios no Excel. Todas as tentativas de funcionamento estão sendo feitas nos relatórios de exemplo, sem sucesso.
Apanhando e aprendendo...
Nos logs ULS, encontrei isso (pus negrito no que me chamou a atenção):
07/04/2012 14:52:48.93
w3wp.exe (0x1514)
0x2B00
Excel Services Application
Excel Calculation Services
6k4q
Medium
ConnectionManager.GetConnection: Failed to create new connection, exception=Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException'
was thrown. at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId), sessionId=1.V21.10WF4sEveVG4ZCgp8Vn1P90.5.pt-BR5.pt-BR73.+0180#0000-02-06-03T23:59:59:0999#+0000#0000-10-06-03T23:59:59:0999#-006036.2e799c40-cccd-4952-99c7-90229f69ee671.N,
connectionString=Provider=SQLOLEDB;Data Source=SEPM2010H1.sp.local;Integrated Security=SSPI;Initial Catalog=ProjectServer_Reporting;Packet S...
c46f489b-b692-4fce-98e1-e38d0e69fb1c
07/04/2012 14:52:48.93*
w3wp.exe (0x1514)
0x2B00
Excel Services Application
Excel Calculation Services
6k4q
Medium
...ize=8000 pool count=0
c46f489b-b692-4fce-98e1-e38d0e69fb1c
07/04/2012 14:52:48.93
w3wp.exe (0x1514)
0x2B00
Excel Services Application
External Data
3238
Information
Unable to establish a connection using credentials retrieved from SSS. This could be because the Unattended Service Account is not configured or because the credentials retrieved from SSS are not valid. [Session: 1.V21.10WF4sEveVG4ZCgp8Vn1P90.5.pt-BR5.pt-BR73.+0180#0000-02-06-03T23:59:59:0999#+0000#0000-10-06-03T23:59:59:0999#-006036.2e799c40-cccd-4952-99c7-90229f69ee671.N
User: 0#.w|sp\tc3783]
c46f489b-b692-4fce-98e1-e38d0e69fb1c
07/04/2012 14:52:48.94
w3wp.exe (0x1514)
0x2B00
Excel Services Application
Excel Calculation Services
eq3m
High
ConnectionManager.GetConnection: Caught an exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException' was thrown.
at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnectionAndAddToList(ConnectionRequest
connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Boolean auditConnection, Int32 keyLcid, ConnectionInfo connectionInfo, ConnectionKey connectionKey, AutoReaderWriterLock autoPoolLoc...
c46f489b-b692-4fce-98e1-e38d0e69fb1c
07/04/2012 14:52:48.94*
w3wp.exe (0x1514)
0x2B00
Excel Services Application
Excel Calculation Services
eq3m
High
...k, Connection& connection, ConnectionList& connectionList) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.GetConnection(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials
credentials, Int64 privateConnectionId, Boolean auditConnection)
c46f489b-b692-4fce-98e1-e38d0e69fb1c
07/04/2012 14:52:48.94
w3wp.exe (0x1514)
0x2B00
Excel Services Application
External Data
2051
Information
Refresh failed for 'Project Server - Capacidade de Recurso' in the workbook 'http://sepm2010h1/PWA/ProjectBICenter/Sample Reports/Português (Brasil)/CapacidadoRecurso.xlsx'. [Session: 1.V21.10WF4sEveVG4ZCgp8Vn1P90.5.pt-BR5.pt-BR73.+0180#0000-02-06-03T23:59:59:0999#+0000#0000-10-06-03T23:59:59:0999#-006036.2e799c40-cccd-4952-99c7-90229f69ee671.N
User: 0#.w|sp\tc3783]
c46f489b-b692-4fce-98e1-e38d0e69fb1c
07/04/2012 14:52:48.95
w3wp.exe (0x1514)
0x2B00
Excel Services Application
Excel Calculation Services
3slr
Medium
ExternalSource.ValidateConnection: Authentication failure. sessionId=1.V21.10WF4sEveVG4ZCgp8Vn1P90.5.pt-BR5.pt-BR73.+0180#0000-02-06-03T23:59:59:0999#+0000#0000-10-06-03T23:59:59:0999#-006036.2e799c40-cccd-4952-99c7-90229f69ee671.N,
externalSource=Project Server - Capacidade de Recurso
c46f489b-b692-4fce-98e1-e38d0e69fb1c
