I am using SQL Server Data tools. I have been working on a Microsoft tutorial on teaching you build SSAS cubes. I have now go the point where I want to browse the cube via Excel. When I clicked on the Analyze in Excel button I saw the message:
"Initialization of the data source failed. Check the database server or contact your database administrator. Make sure that the external database is available, and then try the operation again"
I googled the message and found a solution which was:
Checked if the 9.0 Ole DB provider was properly registered on the client pc. I decided not to take any risk and just re-register the dll-file. I used the following command in the command line to accomplish this step:
regsvr32 "c:\windows\program files\common files\system\ole db\msolap90.dll"
This final step solved the issue, after re-registrating the dll-file on the client computer, the user was able to open the pivottable of the SQL server cube.
So after following those instruction I got the message:
The module cd failed to load. Make sure the binary is stored at the specified path or debug
it to check for problems with the binary or dependent .DLL files.
The specified module could not be found.
I searched the directory and noticed that the actual file msolap90.dll wasn't there.
I am using Windows 8 64bit. Does anyone know where I can obtain this file from?