Alvin,

I tried running this on both the DB engine and the SSAS instance. The SSAS instance said The syntax for 'OPENQUERY' is incorrect.

The DB engine returned this error: Could not...

SSIS might work but I wouldn't know where to start with that.

Erland,

Crikey, you're right. I made too many changes and missed that one.

Thanks so much for your help! You made my day.

Thanks, so much, Erland! That did it! What I don't understand is why granting select to the Reporting role didn't give the user select permission.

This is what I added in...

I dropped the original view and created the same view in the dbo schema. Now I get 2 SELECT permission was denied error messages.

Anja, your script is really helpful! I'm working on fixing the autogrowth settings on our servers and your script is very helpful. It's a good script because it's using current...

Thanks! I'll look at that one.

I've found a really good basic tutorial of SSAS from one of my favorite sites: http://www.mssqltips.com/sqlservertutorial/2000/sql-server-analysis-services-ssas/

Thanks for the link, I'll look at it. I've also find some good links on SSAS:

https://www.simple-talk.com/sql/reporting-services/five-basic-steps-for-implementing-an-analysis-services-database/

http://www.sqlservercentral.com/articles/Analysis+Services+%28SSAS%29/69468/

Well this was a bear but I've got it now. The customer support from Pragmatic Works is great. They helped me get the package encryption set correctly. Here's the synopsis.

•I...

Eirikur Eiriksson (8/1/2014)

---

Unfortunately I do not have BIDS 2K8 at hand so I'm going by my...

I'm sorry, I don't know what you mean. Can you give me more information?

This is awesome. Thanks for the links. We're still trying to figure out when tabular makes more sense so those links will hep.

Thanks very much for the link! I'll read it right away.

sqlmunkee (1/16/2014)

---

Have you considered mirroring the source DB, then snapshotting the mirror to make the data readable ? Mirroring DOES let you use a backup / restore to establish the...