sql server - Cube Processing Error - CREATE DATABASE permission denied in database 'master'.; 42000 -
these errors (repeated few times) when processing cube in sql server 2008 (on windows 8 x64 on vmware).
ole db error: ole db or odbc error: cannot attach file '\\vmware-host\shared folders\downloads\adventureworks2008r2_database\adventureworks2008r2_data.mdf' database 'adventure works'.; 42000; create database permission denied in database 'master'.; 42000. errors in high-level relational engine. connection not made info source datasourceid of 'adventure works', name of 'adventure works'. errors in olap storage engine: error occurred while dimension, id of 'address', name of 'address' beingness processed. errors in olap storage engine: error occurred while 'territory id' attribute of 'address' dimension 'multidimensionalproject1' database beingness processed.
any suggestions appreciated!
i figured out. double clicked info source, went impersonation info tab , changed utilize service business relationship utilize specific windows user name , password.
credit to: http://www.sqlservercentral.com/forums/topic1032175-17-1.aspx
sql-server odbc oledb cube olap-cube
No comments:
Post a Comment