February 11, 2009 at 4:45 pm
good afternoon all
My english isn't good, but I try to explain, we have a user out of domain and we want to connect to a cube with excel application, could someone tell me how I can to make this?, thanks
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
February 12, 2009 at 12:59 pm
To do this, you need to give the "Everyone" group access to the cube. This will make the AS security ignore the authentication entirely, so an un-authenticated user should be allowed.
This is about as insecure as you can get, so I would not really recommend it. A better solution may be to add a user to your domain.
February 12, 2009 at 11:27 pm
Or you could connect to your OLAP databse over http. Check Accessing the Analysis Server Over HTTPS on MSDN if you are using AS2000 or Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 if you are using AS2005.
February 13, 2009 at 4:00 pm
thank's to all, I can, there are option in other datasources in Excel where we put the AD account, I made an account in the domain to this user, modify the host and lmhost files in standalone machine, whit this fix the issue, thanks again
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply