Hi,
I want to ask you how to use XmlaDataSource.Credentials with Windows Authentication ?
My connection is like :
XmlaDataSource _XmlaDataSource = new XmlaDataSource()
{ ServerUri = new Uri(objApp.ExternalServerUri),
Database = XmlaDataSource.GenerateInitialDatabase(objApp.Database),
Cube = XmlaDataSource.GenerateInitialCube(CubeName),
Columns = XmlaDataSource.GenerateInitialItems(objApp.Columns),
Rows = XmlaDataSource.GenerateInitialItems(objApp.Rows),
Measures = XmlaDataSource.GenerateInitialItems(objApp.Measures)
};
A problem to use the method XmlaDataSource.Credentials is that the system during runtime doesn't know the password, but only know the Username and the domain.
Regards,
D.
Hello,
I believe you will need to set up an application-specific login, have the user put in his/her password, and then pass that to the Credentials.
Per our Engineering team:
The XamPivotGrid supports ICredentials interface as a security credentials for connection to SSAS. Basically they are NetworkCredential, which provides credentials for password-based authentication schemes such as basic, digest, NTLM, and Kerberos authentication.
The Windows Authentication is not supported directly. The idea of Windows Authentication is to create an application-specific login form and perform authentication using your own code. So after the application has authenticated user, user should be impersonate and then can be mapped with user from the appropriate olap database.
I hope this helps....please let me know if you have further questions.
Thank you for your answer. We use Windows authentication and we also have for each user a record in the supporting database. The user is recognized as authenticated and its corresponding record is read from the db in order to apply its application roles.
In SSAS we have defined users and their roles which we want to access in order to allow or not access to data.
Can we use _XmlaConnectionSettings.Credentials and pass the username, domain and password ? Is this a way to make it work and if yes is there an example ?
Dimitris
Hi
Yes, you can use XmlaConnectionSettings.Credentials to pass username, domain and password of users which exist in your SSAS database.
RegardsTodor