Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

can`t refresh data connection in excel services

Posted on 2014-01-27
3
Medium Priority
?
1,899 Views
Last Modified: 2014-02-06
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
Comment
Question by:FiremanFpG
  • 2
3 Comments
 
LVL 44

Assisted Solution

by:Rainer Jeschor
Rainer Jeschor earned 2000 total points
ID: 39813444
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
 

Accepted Solution

by:
FiremanFpG earned 0 total points
ID: 39827431
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
 

Author Closing Comment

by:FiremanFpG
ID: 39838446
the answer with the location of the logs assisted me in finding the solution
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question