• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1945
  • Last Modified:

can`t refresh data connection in excel services

hello,
i have an excel with SQL data connection.
sharepoint 2013 enterprise,
target DB in this question - SQL 2008R2

I have secure store and it is working (I have external content types using it), also when i`m creating the excel and changing the data to embedded & specifying the secure store service ID (I prefer not to use the SQL unateended or ODC file) I can refresh the data but when I open the file in excel services when I try to refresh I get the error:
"an error occured whie accesing secure store service, the following connections failed to refresh: server.dbname.table

i tried with SQL login & with AD login (I created another secure store ID and granted permissions on SQL - I checked the login and it worked directly from excel)

also i gave permissions to use the store for all domain users & even to everyone in order to debug it - still can`t refresh inside the excel services (http:////***.xlviewer.aspx.....)

didn`t saw anything special in the event viewer - any other place to look for the logs ?
any ideas ?

Thanks In Advance
0
FiremanFpG
Asked:
FiremanFpG
  • 2
2 Solutions
 
Rainer JeschorCommented:
Hi,
normally you should find something in the SharePoint ULS logs - mainly on the server where Excel Services are running (app server):
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\Logs
HTH
Rainer
0
 
FiremanFpGAuthor Commented:
after digging in the logs I found the solution.
I create the excel services unattended account -> gave permissions on it (in the secure store) for target users
created a new SQL login with the domain user I created for the acct.
and they I gave access to it in the local server group for accessing the SQL.

finally it is working either by using the secure store authentication or by using the unattended service account

Best Regards
0
 
FiremanFpGAuthor Commented:
the answer with the location of the logs assisted me in finding the solution
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now