Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




EXECUTE permission denied on object 'aspnet_CheckSchemaVersion'

web-app

When clicking on certain links in GEMINI, I receive an error about permissions being denied.  They appear to be on the stored procedures created when the InstallCommon and InstallProfile scripts were ran.

My setup is a front-end webserver and a separate server running SQLServer2000.  Who 'runs' this stored proc?  Does there need to be an account added in the SQL Server database for the Windows ASPNET account?

The aspnetProfile and aspnetUsers tables were created, but there is no data in them.

 

 

dirkdglr
· 1
dirkdglr
Replies (2)
helpful
0
not helpful

What is the connection string for the profile database? (web.config file).

That users needs to be given permissions on the aspnet objects.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Giving EXECUTE permissions to the account I created in my connection string resolved the issue. 

Thanks for the speedy (and correct) answer.


dirkdglr
· 1
dirkdglr