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.




Select Permission Denied on GeminiAppSettings

web-app

When I try to launch the Gemini App I keep getting the error:
Select permission denied on 'Geminiappsettings', database 'gemini' owner 'dbo'.....

- I am connecting to SQL using SQL authentication
- I've granted the user DBOwner privileges on the Gemini db
- I've confirmed the user has Select privileges on the table geminiappsetings

My SQL db is on a different machine than the Gemini App, don't know if that causes a problem.

Don't know what else to look for....please help.

Thanks,

Ethan
ethb
· 1 		ethb
Friday, August 31, 2007, 5:59:04 AM
Replies (3)
helpful
0
not helpful

Can you please double check the connection string in the web.config?
Mark Wing
· 9108 		Mark Wing
Friday, August 31, 2007, 10:23:40 AM
helpful
0
not helpful

Yes. I've doubled checked the connection string. It is the same userid and password as the login and user on my SQL server. The only odd thing is in the ProfileServer connection string, the catalog is listed as GEMINI_ASPNETDB....

Ethan
ethb
· 1 		ethb
Friday, August 31, 2007, 6:42:10 PM
helpful
0
not helpful

Did you setup a Profile database? If you are on 2.2.x (using installer) then the profile database is within Gemini by default, so you will have to amend that connection string.

But it has nothing to do with the error you are getting. Can you use SQL profiler to check?
Saar Cohen
· 5000 		Saar Cohen
Saturday, September 1, 2007, 9:50:21 AM