Select permission error on voa_keygen - Sitefinity - Bugs & Issues

All Replies

Posted by Community Admin on 11-May-2011 00:00

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!

Posted by Community Admin on 16-May-2011 00:00

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

This thread is closed