We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

General Information regarding SSAS configuration

The following link has the information to configure SSAS:

http://www.accelebrate.com/sql_training/ssas_2008_tutorial.htm

The following are the general information regarding SSAS configuration:

  1. SSAS supports only Windows Authentication. To resolve authentication issue you need to providing access to the NT AUTHORITY\IUSR by setting the user credential for corresponding application pool resolves this authentication issue.

 

  1. The following steps helps to set the user credential in the application pool

a. Navigate to the corresponding Application pool at IIS and check whether it has right authentication or not.

(i) Click Application pool and follow the link “Set Application Pool Defaults” present in the right tree view.

(ii) Navigate to the Identity tab present under Process Model tree.

(iii) Choose your SSAS account type whether predefined or configured for specific user (In this scenario we have chosen “Local System” under Built-in account).

(iv)Press OK.

  1. When a WCF service trying to access SSAS data if the proper settings are not made in IIS, WCF Service cannot access the data from the SSAS (SQL Server Analysis Services) as SSAS may run on Windows authentication mode. For example, if SSAS installed through a user login and when trying to access it by another user login (consider this user doesn’t belongs to Admin/SSAS user group), then the user might not have a proper access to it.

Reference Links:

http://technet.microsoft.com/en-us/library/cc771170(WS.10).aspx

http://www.advancedinstaller.com/user-guide/iis-app-pool-identity.html

http://support.thycotic.com/KB/a94/running-secret-server-iis-application-pool-with-service.aspx

http://social.msdn.microsoft.com/Forums/en-US/wcf/thread/4a3e1060-f4ed-4533-aa7a-fea7b81de481

 

Article ID: Published Date: Last Revised Date: Platform: Control:
2742 11/20/2014 11/25/2014 Silverlight OlapClient
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.