More in this section

Forums / Bugs & Issues / Select permission error on voa_keygen

Select permission error on voa_keygen

2 posts, 0 answered
  1. OakTree Digital
    OakTree Digital avatar
    27 posts
    06 Sep 2012
    11 May 2011
    Link to this post
    I am trying to get a existing site up and running in a test environment and am currently seeing the following error whether navigating to the front-end or the admin interface:

    SELECT permission was denied on the object 'voa_keygen'...

    SiteFinity 4.0.1210.0 Professional Edition license
    IIS 7/ App Pool .net 4.0 Classic
    .Net 4.0
    SQL Server 2008

    The user that I am accessing with has been verified as being in the dbo role. One thing I should say is the database created using the SQL Server Mgmt Studio export functionality to copy the database from the live SQL Server instance to the test instance. I did not have access permissions to restore from a backup or to use the copy functionality of mgmt studio.

    Thanks in advance for any and all help!
  2. Boyan Barnev
    Boyan Barnev avatar
    1429 posts
    30 Oct 2017
    16 May 2011
    Link to this post
    Hello Stuart Peschka,

    This error might be because the user that you are using for connecting to the database    is not granted access to the table. You should grant permissions to the user or put him in a SQL Server users collection which has the appropriate permissions.) It is s SQL SERVER side setting that is not controlled by Sitefinity. Another thing you might try is to give NETWORK SERVICE user a dbo rights and associate him  to the dbo role. If the problems persist, please try changing the connection string settings in DataConfig.config to
    <add connectionString="data source=YourServerName ;Integrated Security=SSPI;initial catalog=YourDBName" providerName="System.Data.SqlClient" dbType="MsSql" name="Sitefinity" />
    If the problems persist, please let us know.

    All the best,
    Boyan Barnev
    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
2 posts, 0 answered