Forums

Skip Navigation LinksHome / Developer Network / Forums / Sitefinity Older Versions (3.x): Set-up & Installation > CREATE TABLE permission denied in database

CREATE TABLE permission denied in database

Feed from this thread
  • Jason Beck avatar

    Posted on Jan 12, 2010 (permalink)

    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>

    Reply

  • Ivan Dimitrov Ivan Dimitrov admin's avatar

    Posted on Jan 12, 2010 (permalink)

    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.

    Reply

  • Jason Beck avatar

    Posted on Jan 12, 2010 (permalink)

    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?

    Reply

  • Jason Beck avatar

    Posted on Jan 12, 2010 (permalink)

    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.

    Reply

  • Michael Kellogg avatar

    Posted on Apr 22, 2010 (permalink)

    Thanks, I had the exact same problem, changed the permissions and kept hitting F5 to no avail.  Restarting IIS solved it.

    -mike

    Reply

  • Garvit avatar

    Posted on Nov 4, 2011 (permalink)

    As I am a beginner Can you please give Step by Step Instruction of what you did ??

    Reply

    • Register for webinar
Skip Navigation LinksHome / Developer Network / Forums / Sitefinity Older Versions (3.x): Set-up & Installation > CREATE TABLE permission denied in database