+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / CREATE DATABASE permission denied in database 'master'.

CREATE DATABASE permission denied in database 'master'.

5 posts, 0 answered
  1. Rakesh
    Rakesh avatar
    17 posts
    Registered:
    24 Feb 2012
    23 Apr 2012
    Link to this post
    Hi All,
    I have uploaded my application with the database but when I browse the website I got the error which is given below and I am struggle with this error from last 3 days so please some one help me out 

    CREATE DATABASE permission denied in database 'master'.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: Telerik.OpenAccess.RT.sql.SQLException: CREATE DATABASE permission denied in database 'master'.

    Source Error: 

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace: 

    [SQLException: CREATE DATABASE permission denied in database 'master'.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql) +420
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql) +9
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +459
    
    [OpenAccessException: SQL exception on 'CREATE DATABASE TFPDB' : CREATE DATABASE permission denied in database 'master'.]
       Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +13
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +38
       OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +639
       OpenAccessRuntime.DataObjects.tools.ant.DatabaseCreationTask.createDatabase() +1897

    Thanks & Regards
    Rakesh Parmar
  2. Andrei
    Andrei avatar
    553 posts
    Registered:
    27 Nov 2008
    23 Apr 2012
    Link to this post
    Rakesh,
    The way I do it is this way. Who is the administrator of the database, or of the SQL Server? It sounds like a permissions issue. What I do is this. I create an administrator on the domain, if you don't have a domain then on the machine that the database is on. Then make sure that administrator or Power User (if you know what you are doing with Users and Roles) is then used by the WebApplication to access the database. I usually go to the WebSite in IIS7 and under the application pools, I find the correct application pool that is for my WebApplication and in the Advanced Settings I make sure to provide the account that has all the neccessary rights. Now this might not be the best way security-wise, but it works in my case where the systems are closed from the outside world.
    Hope this helps,
    Andrei
  3. Atanas Valchev
    Atanas Valchev avatar
    414 posts
    Registered:
    04 Jan 2016
    23 Apr 2012
    Link to this post
    Hello,

    The problem comes from the fact that the system cannot find appropriate SQL login user for the database. For example if you have a specific user that is managing the database, make sure that the same user has been added to the database ( also having proper permissions as well ).

    Also please verify that the application pool identity is the same as the user managing your database and should have owner permissions over the database.

    Kind regards,
    Atanas Valchev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  4. Dhaval
    Dhaval avatar
    21 posts
    Registered:
    23 Apr 2012
    27 Apr 2012
    Link to this post
    Hey,,,
    Just Contact to your Database Admin and tell them that you want the All rights for this database
    Create ,Alter And Drop...Etc...
    Once he gives the rights this error will be discarded and not occur again.
    thanks..
  5. Tarek El-Mallah
    Tarek El-Mallah avatar
    2 posts
    Registered:
    04 Dec 2013
    14 Mar 2014 in reply to Atanas Valchev
    Link to this post

    that was useful, it's working now with me,

    thanks

5 posts, 0 answered