error:
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."
Solution;
Power pivot has been installed successfully. it was issue with Sql server adventureworks2014 db sample.
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 as of now.
Thanks,
No comments:
Post a Comment