Thursday, January 10, 2013

Deployment issue’s in SSAS cube

After configuring and installing SQL Server when we try deploy our first sample cube it throws error regarding the access to data source.
 The error message says that the connection to data source is not valid or data source is not able to connect database. These all error occurs as the account with which data source trying to access the database has not appropriate permissions.
Solution:
To resolve the issue go to the database engine, expand logins tab and check the access to your account and provide sys.admin right to your account. If user doesn’t exist in logins create new login then assign it the appropriate rights.

No comments:

Post a Comment