Also if I try and use SQL Server Management studio (Analysis Services) I get a login failure as well.

I have checked the SSAS database on the server itself and my...

NOTE: Even BEFORE i get to the cube selection when creating a new connection I get an error with permissions. So I don't think it is an issue with the...

Hi,

All the services are running using a domain account that has high permissions

I tried the impersonation option on the connection within the cube, and this didn't seem to make any...

Hi,

Yes they are on the same domain, and the PC and servers are on the same SP level.

Pete

Hi Steve,

Thanks for that, yes that is a typo, only haveing problems with SSAS...

With regards to Excel, strangely when I select OLAP cube option in Excel 2003 I...

Once I have built a report in Reporting Services, can this data be automatically exported to Word format?

I've just found this post .... http://www.simple-talk.com/sql/t-sql-programming/writing-to-word-from-sql-server/

which seems to use OLE Automation to write to Word.... Has anyone had a go at using this before?

Pete

To explain my users requirement in a bit more detail....

1) A property has changed status from occupied to available to let

2) This should trigger a word document to go out...

Have you got any examples of performing mail merges, can this process be automated? I haven't used mail merge before.

Thanks

Pete

Can anyone help with this?

Thanks

Pete

Thanks Matt.. I had a little google moment to see if anyone else had the issue in Oracle world, and came up with this web page which really does explain...

Thanks Ken, that explains it... Although after reading the article I still don't understand why one row in the table has nulls then the whole set of data is...

Thanks for that Jason... But the query that runs doesn't take that long to run. What I was worried about was that the insert with the NOT IN clause was...

Are you autoshrinking any of the databases (including tempdb) it could be that the server is having to re-create the space which eventually fragments the disk.

Also what version of SQL...

Would indexed views help?

I'm more used to creating Data Warehouses, and I would always create a 'real' table during the staging process rather than a temporary table as the volumes...