Error appears while accessing the application in Adventure Works 2012

Asked By Anthony D Renda 20 points N/A Posted on - 05/14/2014

Hi all,

I got this weird error message while I am trying to work in a project in SQL2012. The error appears while accessing the application in Adventure Works 2012. Do I need to change any setting in configuration? Does anyone know how to fix this problem? Please help. Thanks.

 

External Data Refresh Failed

An error occurred while accessing application id AdventureWorks from Secure Store Service. The following connections failed to refresh.

SQL2012B AdventureWorks2012

vEmployee

Learn more about data refresh

• Status: Open
• Question Views: 680
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office

Answered By Bailey Jonathan 0 points N/A #168902

Error appears while accessing the application in Adventure Works 2012

You can fix this issue if you move the mdf file to some folder and don't work directly in the root oF your disk. Just configure the security in the folder properties creating some folder, so the server account can use the folder without any problem.

Second solution is that you run SSMS and right click the databases and delete the log file entry in the attach dialog using attach data base.

I hope it works. Thanks! 

About Bailey Jonathan

Questions
2

Answers
70

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/26/2014
• Question Category: Microsoft Office