Can you authenticate into SSAS with AD LDS (ADAM) accounts?

Posted by Jaxidian on Stack Overflow See other posts from Stack Overflow or by Jaxidian
Published on 2010-03-16T15:41:35Z Indexed on 2010/03/20 3:51 UTC
Read the original article Hit count: 578

Filed under:

sqlserver-2008

|

active-directory

|

ssas

|

adam

I'm very new to AD LDS and experienced but not qualified with SSAS, so my apologies for my ignorances with these.

We have a couple implementations where we expose SSAS via an HTTPS proxy (msmdpump.dll) and currently we have a temporary domain setup handling this (where our end-users have a second account+creds to manage because of this = non-ideal). I want to move us towards a more permanent solution which I'm thinking of moving all authentication to AD LDS for our web apps, SSAS, and others. However, SSAS is where I'm concerned about this.

I know SSAS requires Windows Authentication and to play nicely, and that this ultimately means Active Directory will be involved.

Is there a way to get this done with AD LDS instead of having to use a full AD DS implementation? If so, how?

© Stack Overflow or respective owner

Related posts about sqlserver-2008

SQLServer 2008 BIDS On Windows 7 - 64bit

as seen on Server Fault - Search for 'Server Fault'
Hello, I am trying to install Sql Server 2008 Business Intelligence Development Suite on VS2008 in a Windows 7 (64bit) machine. The installer is aborting with an unspecified error for which I have not been able to find any error anywhere. Has anyone had the same problem with BIDS? Thanks, Eduardo… >>> More
Setup of SQLServer 2008 want to reboot

as seen on Server Fault - Search for 'Server Fault'
I want to setup a sqlserver 2008 developeredition on my windows-vista notebook but the setup-check want me to reboot first. But this doesn't help after reboot the setup want a reboot again. I got the tip: You can open Regedit, and modify this key"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet?\Control\Session… >>> More
SQLServer 2008 Fails to start under NT AUTHORITY/NETWORK SERVICE account

as seen on Super User - Search for 'Super User'
Not sure what changed but looks like my security credentials have been monkeyed with. Since yesterday evening after I disconnected from our corporate network and rebooted my laptop at home, I am unable to start the instance of SQL2K8. The service is set to run under NT AUTHORITY\NETWORK SERVICE account… >>> More
SQLServer 2008 FailOver and Load Balancing

as seen on Server Fault - Search for 'Server Fault'
I have a project with a 2TB database ( 450.000.000 rows). I need to provide to the proyect a solution that gives FailOver and load Balacing, what do you recommend? We are going to use a NetApp Filer for the Data Files and for the File System of the Proyect. I read that SQl Clustering does not provide… >>> More
Multiple rows with a single INSERT in SQLServer 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I am testing the speed of inserting multiple rows with a single INSERT statement. For example: INSERT INTO [MyTable] VALUES (5, 'dog'), (6, 'cat'), (3, 'fish) This is very fast until I pass 50 rows on a single statement, then the speed drops significantly. Inserting 10000 rows with batches of 50… >>> More

Related posts about active-directory

Can't join OS X Mavericks to AD Domain

as seen on Server Fault - Search for 'Server Fault'
I'm attempting to join an OS X Mavericks (10.9) client to a Windows Server 2008 Active Directory domain, however the bind fails with this error in the OS X client's system.log: Oct 24 15:03:15 host.domain.com com.apple.preferences.users.remoteservice[5547]: -[ODCAddServerSheetController handleOtherActionError:… >>> More
Retrieve user details from Active Directory using SID

as seen on Server Fault - Search for 'Server Fault'
Hi, How can I find a user in my AD when I have his/her SID. I don't want to rely on other attributes, since I am trying to detect changes to these. Example: I get a message about a change to user record containing: Message: User Account Changed: Target Account Name: test12 Target… >>> More
Retrieve user details from Active Directory using GUID

as seen on Server Fault - Search for 'Server Fault'
Hi, How can I find a user in my AD when I have his/her GUID. I don't want to rely on other attributes, since I am trying to detect changes to these. >>> More
Retrieve user details from Active Directory using GUID [closed]

as seen on Super User - Search for 'Super User'
Hi, How can I find a user in my AD when I have his/her GUID. I don't want to rely on other attributes, since I am trying to detect changes to these. >>> More
Office365 DirSync Active Directory Integration

as seen on Server Fault - Search for 'Server Fault'
I am preparing to deploy Office365 for my organization. We have an on premise Active Directory Domain Controller (Windows Server 2012 R2). We would like to leverage our Active Directory for: automatic user provisioning in Office365, and password synchronization, using the DirSync tool. Our Active… >>> More