Power Pivot Data Refresh Error Using Power pivot unattended account SharePoint 2013 & Sql 2014

Question

Getting following error while refreshing power pivot data in excel sheet,

we installed power pivot perfectly but somewhere some permission is missing but could not able to find it,

when i check event viewer, found following error though i m able to connect sql server instance from SharePoint box and able to ping,

can some one help me to fix this?

"OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001."

Thanks,

Deepak Patel

Answer 1

I fixed this issue by restoring AdventureWorks2012 database on sql server 2014 and it works now.

it does not work with AdventureWorks2014 db with sql 2014.

Answer 2

Hi,

Thanks for your sharing. It would be helpful to those who meet the similar issue.

Best Regards,

Dean Wang

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].