1
votes

As before I post question to stack here :

How Can I pass EffectiveUserName to SSAS through Excel Service using FBA(Forms based authentication) in SharePoint 2013

Finally I decided to use claim based windows authentication, because this mode send EffectiveUserName to ssas from excel service.

Now we need to create a custom claim based windows authenticated login page in SharePoint 2013 without another authentication method. picture below shows popup window:

I exactly want to create a custom aspx page that works like this popup page. when users want to login , this aspx shows instead of pop up windows security.

There are a little references to do this like

https://blogs.msdn.microsoft.com/chunliu/2010/09/21/creating-a-custom-login-page-for-windows-authentication/

but it is not work and is not complete and does not help. users want to login to system using only and only this authentication method. how to customize it?

1
What did you tried so far?STORM
We first use FBA to login users. everything was good until our project employer wants to show only subset of data from SSAS cube for each user based on their role which has already been defined in SSAS side. We test alot of things, like sss(Secure store box) but none of them pass EffectiveUserName to SSAS. because of this, roles dont apply on cube and an error raised in excel service in sharepoint 2013. but when i use Windows Auth, Effective user name passed to SSAS. Thanksmahdi moghimi

1 Answers

1
votes

after plowing Internet a lot i find this. here you are : VsFile