Access OLAP

I have many users who have access the OLAP. For each one of them I have that to create an account in Windows? It is necessary to create account on account? Exists another way (Without using user GUEST)?

If all of your users are coming outside of windows domain, you will have to find a way to map every user to some windows domain account.

You can go with one-to-one mapping.
You can go with many to one mapping- all accounts will be impersonated under single windows domain account.
Or you can have many-to-many mapping , you will create few windows domain accounts and map your users to them.

Not knowing exactly your application or business cases it hard to suggest anything more specific about the solution.

For instance you could implemet HTTP conectivity and give each user set of credentials.

Or you can run IIS vitual directory under single windows account.

Or you can have several IIS virtual directories.

Or you can have few sets of windows credentials you pass around between users.

Hope that helps

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.