Solved

can`t refresh data connection in excel services

Posted on 2014-01-27
3
1,833 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 44

Assisted Solution

by:Rainer Jeschor
Rainer Jeschor earned 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

623 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