AdomdConnection Error

Hi~

I write a web service by using ADOMD.

When I excute the program under debug mode in my computer for testing,it's ok.

But when I establish this web in the server,and browse(In Server) it to use, the error is happened.

follow is my code & error messahe

Code Snippet

<WebMethod()> _
Public Function Test2() As String
Dim UserIdPwd As String = "Data Source = olapdw;Catalog = STATION;"
Dim advwrksConnection As New AdomdConnection(UserIdPwd)
Dim tmp

advwrksConnection.Open()
tmp = advwrksConnection.Database.ToString + advwrksConnection.Cubes.Count.ToString + advwrksConnection.ConnectionString
advwrksConnection.Dispose()
Return tmp

End Function

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, NT AUTHORITY\NETWORK SERVICE, does not have access to the STATION database, or the database does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.GetPropertyFromServer(String propName, Boolean sendNSCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.get_Database()
at Service.Test2() in C:\Inetpub\wwwroot\Service\App_Code\ASAdminService.vb:line 709

Could some tell me why? or how to check?

Thanks~

This is the same issue as your AMO question:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2032042&SiteID=1

The web service is running under an account that does not have rights to access SSAS, you need to either run the web service under a different account which does have rights to the cube or grant access in SSAS to the account which the web service is currently running under.

If SSAS and IIS are on different machines, the setting up a domain account for the web service and giving it access is probably the way to go. If they are on the same machine your could put the NETWORK SERVICE account in a role in SSAS so that it has rights to access the cubes.

|||

Thanks for your answer~

The problem has already resolved.