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

Forums / Set-up & Installation / EXECUTE permission denied on object 'sf_DataAccessVariables_ins'

EXECUTE permission denied on object 'sf_DataAccessVariables_ins'

5 posts, 0 answered
  1. Dean Shoesmith
    Dean Shoesmith avatar
    4 posts
    Registered:
    28 Nov 2005
    02 Sep 2008
    Link to this post
    There has to be a way to chage the users / owners of the database tables and stored procs, yes?

    I'm getting this error during set up and configuration:

    EXECUTE permission denied on object 'sf_DataAccessVariables_ins'
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    02 Sep 2008
    Link to this post
    Hi Dean Shoesmith,

    Please run the application as an administrator on the machine you use. Your database user should be member of  db_owner role on the database server.

    Hope this helps.

    Regards,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. Dean Shoesmith
    Dean Shoesmith avatar
    4 posts
    Registered:
    28 Nov 2005
    02 Sep 2008
    Link to this post
    Thanks, maybe I should be more precise.

    I've subscribed to shared hosting.  I don't know if the user I was able to create for my MS SQL 2000 database is a db_owner or not.  If it's not, if I change all the ownership of the tables to my user, could / should that allow me to use Sitefinity in a shared hosting environment?

    What other options would I have?  I don't have a local SQL Server.
  4. Dean Shoesmith
    Dean Shoesmith avatar
    4 posts
    Registered:
    28 Nov 2005
    02 Sep 2008
    Link to this post
    Oooops.  Never mind.  I managed to find out that I can assign my created user to the db_owner role.  Which worked.

    Thanks.
  5. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    02 Sep 2008
    Link to this post
    Hello Dean Shoesmith,

    We are pleased to know that this issues has been sorted out. Let us know if you have any other questions.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Register for webinar
5 posts, 0 answered