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

Forums / Set-up & Installation / CREATE TABLE permission denied in database

CREATE TABLE permission denied in database

6 posts, 0 answered
  1. Jason Beck
    Jason Beck avatar
    9 posts
    Registered:
    12 Jan 2010
    12 Jan 2010
    Link to this post
    I have installed the Trial version. The database server is NOT on the same machine as the installation. The database has a user which has been set as db_owner role. However, I still get the error.

    Configuration Error

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: CREATE TABLE permission denied in database 'projectdatabase_dev'.

    Source Error:

    Line 108:        <clear />
    Line 109:        <add connectionStringName="DefaultConnection" applicationName="/"
    Line 110:          name="Sitefinity" type="Telerik.DataAccess.AspnetProviders.TelerikRoleProvider, Telerik.DataAccess" />
    Line 111:      </providers>
    Line 112:    </roleManager>

  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    12 Jan 2010
    Link to this post
    Hi Jason Beck,

    The error is clear and it states that you do not have needed permissions to create an database. You should get the same error if you just try to make a simple query

    CREATE DATABASE Test
        GO

    Please login to you SQL server and make sure that the user you use is dbo and it has been mapped to the problematic database.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. Jason Beck
    Jason Beck avatar
    9 posts
    Registered:
    12 Jan 2010
    12 Jan 2010
    Link to this post
    Using Microsoft SQL Server Management Studio, I ran the test script

    CREATE DATABASE Test
    GO

    The result was

    Msg 262, Level 14, State 1, Line 1
    CREATE DATABASE permission denied in database 'master'.

    However, I do not see why dbo would be able to create databases, and the error we are seeing is for creating a table, not a database. As a test, I right clicked Tables, New Table... added a column, saved, and was able to create the table "Test" as my database user. Therefore, the user does have table creation permissions. Also, the error is not related to invalid credentials. So what's left?
  4. Jason Beck
    Jason Beck avatar
    9 posts
    Registered:
    12 Jan 2010
    12 Jan 2010
    Link to this post
    I believe I found the issue. The user did not have the db_owner role the first time I ran the wizard. I corrected this and made several subsequent attempts with the same error. I even restarted the Default Web Site instance to no avail.

    After all this, I restarted IIS entirely on the web server (since it is my local development machine), and this corrected the issue.
  5. Michael Kellogg
    Michael Kellogg avatar
    6 posts
    Registered:
    01 Oct 2009
    22 Apr 2010
    Link to this post
    Thanks, I had the exact same problem, changed the permissions and kept hitting F5 to no avail.  Restarting IIS solved it.

    -mike
  6. Garvit
    Garvit avatar
    1 posts
    Registered:
    04 Nov 2011
    04 Nov 2011
    Link to this post
    As I am a beginner Can you please give Step by Step Instruction of what you did ??
Register for webinar
6 posts, 0 answered