Thursday, 15 January 2015

sql server - Cube Processing Error - CREATE DATABASE permission denied in database 'master'.; 42000 -



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