CODEWITHSUNDEEP
asp.netssasadomd.netasp.net-authenticationasp.net-authorization
Ram
Ram

Reputation: 57

ADOMD.NET connection string with user id and password

From asp.net web application connecting the SSAS cube. Need to pass user credentials to the connection string. Web application is authenticated with windows identity. Web application users doesn't have access to SSAS, need to access SSAS with a service account credentials. SSAS service is not exposed in http.

Is there any way to pass the user credentials in ADOMD.NET connection string ?

Upvotes: 0

Views: 4280

Answers (1)

ISHIDA
ISHIDA

Reputation: 4868

I have implemented the Asp.NET web page and retrieved the data from cube to asp.net/MVC page. You need to create an application pool in IIS server first and connect the ssas to IIS server using windows account credentials. In ASP.NET use local host as the DATA SOURCE in connection string.

http://www.codeproject.com/Articles/6562/Cubes-MDX-Analysis-Services-and-ADOMD-in-C

http://www.codeproject.com/Articles/28290/Microsoft-Analysis-Services-Displaying-a-grid

Upvotes: 1

Related Questions