Post reply

No permission to create database over SMO

  • November 7, 2007 at 3:57 pm

    #122197

    Hi

    We are using a tool (navision business analytics configurator) that creates databases and cubes inside sql server 2005. Now we got the error "Create database permission denied in database 'master'". The user is in sysadmin role and can create databases when logged in. The tool uses the Microsoft.SqlServer.SMO interface. The question is now: Do we have to configure the security somewhere for using the database administration over SMO?

    Thanks for help.

    Jan

  • November 7, 2007 at 6:22 pm

    #749294

    Check and see if the user has been explicitly denied permission, either to their login or a group.

  • November 8, 2007 at 5:12 am

    #749403

    No denied permission, also tried with sa, same result.

    Must security be configured by SQL Server surface configuration?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply