Hi experts - I am new to SQL2005 so please bear with me on this question. I have server that has SQL2005 and Analysis services installed on it. I have a user who wished to connect to the analysis services on this server. He has a valid SQL ligin - but he does not see any databases when he gets successfully connected to the Analysis Services.
Why is this?
If I make him a local admin on the server - he sees all the databases but dont want to gve him this much privilege if I can avoid it.