Select permission error on voa_keygen
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!
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" />