Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  SSAS User Login

Author  Topic  rad14i Starting Member 4 Posts Posted - 2011-11-24 : 19:35:44 Hi, How can i create user login in SSAS? When im using is on localhost i just use windows authentication to connect. I create a cube then deployed it and tried to access the cube through MS EXCEL, again I use windows authentication. Now I want to connect remotely and I want to connect using user name and password. And also, how can i put security on accessing cubes on excel? What I mean is put restrictions on accessing cubes on excel depending on user name? Help, appreciate your reply, noob here :) thanks!