Notifications
Announcements
No record found.
Hi all,
I am getting this error whyle trying to deploy analysis services via wizard
Please help me on this.
*This post is locked for comments
You are getting error message when the cube is processing after the deployed.
Please increase the ExternalCommandTimeout value the SSAS server instance properties.
Right click on the server name in Management Studio > Properties. Then check “Show Advanced (All) Properties”. Then adjust the ExternalCommandTimeout setting.
Please uncheck the process checkbox in the SSAS deployment wizard and deploy the cube and try to process the cube directly on the SQL server management studio, by right click on the cube and select process.
The message says that the database server can't be reached and gives you some suggestions what to do. Please follow them.
HI Hariharan Thanks for reply
When I am trying Files>>Tools>>BI tools>>SQL server analysis services project wizard ... Then I am facing the issue/error.. And i don't have writes to open the properties as u said ..
Thanks
Can you able to deploy the cube without process? (uncheck the process checkbox and try)
Once it is deployed, please check the impersonation info.
connect the SSAS server -> select the database -> expand the Data Sources -> go to properties by right click on the Dynamics Database and enter the username and password and try to process the cube again.
Please refer this link for more information blogs.msdn.com/.../analysis-services-cube-processing-fails-with-error-quot-ole-db-error-ole-db-or-odbc-error-operation-canceled-hy008-quot.aspx
HI Martin, Thanks for reply...
I have followed the steps given there
"Check if instance name is correct and if SQL Server is configured to allow remote connections"
and i found that there is a mismatch in database Instance (Name) was i corrected that checked the setting for remote connection... Now I am facing this..
"OLE DB error: OLE DB or ODBC error: Login failed for user 'AOSOPHC\AOSOPHCSVR0006$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'."
Any suggestion ?
Check if the DB name is correct. Then whether the login name is correct. If so, check whether the logic have permissions for the database.
HI Martin
Database name is correct .. Login name is also correct ..in database engine the user has rights ..If you r telling me apart from database engine server role rights kindly let me know how do i get that?
If you can access the server and not the database, it's still not very useful, therefore you need permissions for the database as well. Consult the documentation for details - I'm now what you're doing, so I don't know what you exactly need.
Martin,
My requirement is to deploy standard EP dashboards... So I followed the path Files>>Tools>>BI tools>>SQL server analysis services project wizard to deploy the analysis services ... And on last stage of this process i was getting the error which i posted first then I checked Instance etc as to asked me to follow the suggestions it was mismatch and i corrected that.... after all this i am facing this issue "OLE DB error: OLE DB or ODBC error: Login failed for user 'AOSOPHC\AOSOPHCSVR0006$'.; 28000.
M i clear now?
The answer is still the same. The error says that the account can't access the database, therefore it either doesn't exist or the account doesn't have permissions to work with it.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
Sukrut Parab 2 Moderator
