could not deploy the cube

hi guys,

i have a problem in deploying the cube in sql server 2005 ... i had no permission for creating the object in the server...

i got a response as.....

Hi Lalithak,

You would use Manage Roles option in your Analysis Services Database.

Good Coding!

but i didnt get where will i get this option in server or in client....

lalitha

Use SQL Server Management Studio to connect to your Analysis Server. See if you permission to create a database.

If not, ask for your server admin for the following:

Create a new database for you.
Add a new role to the database and grant the role DB admin permissions.
Add you as a memeber of the role.

How you should be able to deploy your cube. Make sure deployment options in your BI Dev Studio target a new database.
It is also a good idea to check your deployment is not going to override the DB admin role.

Hope this helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.