i am trying to work through an Analysis Services tutorial for SQL Server 2005. everything has been peachy until i get to the point where i'm supposed to deploy my AdentureWorksDW cube.
when i attempt to deploy, i get the following error:
Error 3 OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object 'DimProduct', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0
i have checked and i have a log in (my domain account) with roles "public" and "sysadmin", and i'm listed as a user under AdventureWorksDW->Security->Users with default schema dbo.
i checked schemas->dbo, and i see nothing explicitly listed. is this the problem? when i look through the other schemas in other databases, i see nothing explicitly granted...
when i look under AdventureWorksDW->Security->Roles, i don't see sysadmin listed... public is there... as are the other roles like db_datareader. is this correct?
i also noticed when i look at the schemas owned by me in AdventureWorksDW->Security->users that nothing is checkmarked.... and db_denydatareader is listed... are items enabled when checkmarked? do i need to checkmark the non-deny items?
so, basically, i am a bit confused about what needs to be in place in order to fix this error... what do i need to verify?
sql server 2005 enterprise