How to Connect to Analysis Services from Client Management Studio?

Dave Wickert wrote:

Like AS2K (and in fact all previous versions of OLAP and Analysis Services), we only support trusted connections from users to AS (both for queries and for administration/operators). When Analysis Services itself connects to the backend RDBMS, that can be either trusted or SQL logins. _-_-_ Dave

Dave, thanks for the reply. So how do I enable "trusted" logins for AS, if that's possible that is?

JawKnee at 2007-10-6 >

Dear Dave ,

I am slightly less experienced , and wonder if you could answer some questions for me .

I am running MsSQL2005 and AS on a server .I have built cubes in server .Have had great difficulty in browsing the cube from any remote machine .

Initial problems were associated with the AS server not being able to authenticate the client .

I then put the server and client into the same domain .

I registered an existing user in the domain , into the server users , as member of the various sql groups (olap and other ) .

In the server (AS) user groups , should there be an OLAP administrator group.? I see only an OLAP user group ?

I also granted this domain user login to the sqlserver .

The client is now able to connect to the sqlserver and the Analysis server , using "windows authentication" with one catch .(Previously the cliebnt could connect to the sqlserver using username -pwd authentication .

There are no AS databases listed , no cubes shown etc . The client also has no authority to create a new database in the analysis server .

I am just wondering , what are all the prerequisites to get the client to be able to view the analysis service cubes ?

How can one verify that you have correctly setup the windows authentication required for AS , while you are logged into the server and sql manager ?

What is the correct setting for datasource property ?

Sorry for making such a long story .

any comments appreciated

slippery at 2007-10-6 >