Home Forums SQL Server 2008 SQL Server 2008 - General db_creator permission not working on SQL Server 2008 r2 RE: db_creator permission not working on SQL Server 2008 r2

  • August 31, 2012 at 9:19 am

    #1532468

    dbadude78 (8/31/2012)

    Hi

    Thanks for the quick reply. As a test i executed the whole script on my local instance. But got a the following message "Msg 297, Level 16, State 1, Procedure Audit_Server, Line 13

    The user does not have permission to perform this action"

    I can confirm the login has been created with the dbcreator rights.

    You received that error when running Lowell's script, as it's posted? Have you got a DDL trigger on CREATE DATABASE that's manually preventing this?

    Edit: Ha, Lowell's just spotted the same