I'm running SQL Server 2000 Enterprise Edition with Analysis Services installed. I've made some cubes and added a couple of roles to the cubes.
The problem that I have is that I want people to be able to access these cubes over the web with a user name and password that I assign them. Is this possible?
Excel 2000 doesn't ask me for a user name or password when establishing a new connection to an OLAP cube. Is there any way to force it to ask me for one, or to specify one in the connection file?
Thanks in advance.