May 4, 2004 at 12:57 pm
I'm new to AS. At this point I have created about a half dozen cubes and I've made local connections to cubes using Visual Studio and the Report development tool that comes with Reporting Services.
I've just set up new cubes on a development server. In order to create the cubes on the development server, I logged on locally to the server to authenticate to AS (my network login is a member of the OLAP Admin group).
My laptop is not a member of the domain and unlike SQL Server/Query Analyzer, I cannot just log in to AS with the sysadmin ID. As far as I can tell, the only way to authenticate to AS is if you are logged in to the domain where AS lives.
Do I understand this correctly or is there another solution? I need to use Visual Studio on my laptop to create reports against the cube and the laptop is not part of the domain.
Thanks for your help
May 5, 2004 at 12:00 am
You're right in assuming that Windows security is the only way to authenticate/connect to an AS server.
A work-around you could try is to create a user account with identical name and password on the domain (as you have on your local machine) and then you may get 'pass-through' security working.
Steve.
May 5, 2004 at 12:01 am
I've not tried it, and your domain admin might have a fit, but if your local account gets seen as 'guest' on the domain, you could always change the security role/s on the DB/cubes to allow access to the guest account/group.
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply