by Oscar
31. March 2009 22:01
One of the issues I recently ran into and wanted to share with everyone; when you use SQL 2008 (which is great by the way). There are at least two things I am aware of that you should do:
- Ensure that you have added the new Data Provider for SQL 2008 for Excel Services to work properly under Trusted Data Providers.
- Install the SQL 2008 Client Components on all farm servers
FIGURE 1 – Shows MSOLAP.4 added for SQL 2008
After I made these configuration changes, I was able to use the OOTB SQL Analysis Services Filter WebPart, which was giving me an error “the connection timed out”.
-O
by Oscar
3. March 2009 23:05
It looks like the WebPart is being used! Awesome! As of now, 160 downloads. Hope people are enjoying it.
Check it out here http://cqwprce.codeplex.com/
Cheers,
Oscar
Subscribe