connection to sqlserver 2012 using msolap

StatusIDPriorityType
Open35867MajorQuestion
ProfileReply
syedjahangir SardarClient

Hi team

we are exploring the ranet olap controls.facing the issue when connecting sqlserver 2008 r2 or sqlserver 2012
Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, MEDUSIND\user, does not have access to the AdventureWorks2008R2 database, or the database does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IDiscoverProvider.Discover(String requestType, IDictionary restrictions, DataTable table)
at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.PopulateSelf()
at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Microsoft.AnalysisServices.AdomdClient.IObjectCache.Populate()
at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.PopulateCollection()
at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.get_Count()
at Microsoft.AnalysisServices.AdomdClient.CubesEnumerator.MoveNext()
at Microsoft.AnalysisServices.AdomdClient.CubeCollection.Enumerator.MoveNext()
at System.Linq.Enumerable.d__95`1.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at Ranet.Olap.Core.Providers.OlapMetadataProvider.GetCubes()
at Ranet.Analytics.PivotGrid.Controllers.DataSourceController.CheckConnection(ConnectionCheckingRequestModel request)

Replies

UserDescriptionPosted On
syedjahangir SardarClient

I have solved this issue.We are exploring galaktika soft software .Would like to know the SLA on the tickets

PetrAdministrator

Hi Syed!

According to information from the description of the exception: Either the user, MEDUSIND\user, does not have access to the AdventureWorks2008R2 database, or the database does not exist.

You need to check the Connection string settings (in Ranet App) and Cube Security settings (in Management Studio, Roles permissions for Database).

The SLA is governed by a license agreement, warranty, or supplemental service contract.

Best regards
Ranet dev team

Vyacheslav SemenkovAgent

Hi Syed.

Please accept our apology for such a delay in answer. We'll do our best to prevent this in future.

syedjahangir SardarClient

Thank you team ..Would like to know the TAT of the Ticket during trial period and after obtaining the license.This will really help us to decide on the next steps..

Vyacheslav SemenkovAgent

Tickets are usually answered in 1-2 working days no matter do you have licence or not.

Write US