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.




Installation Problem

web-app

 We are currently in the process on evaluating Gemini but having problems getting the application / site to work.

I have followed the installation instructions and set the WEB.CONFIG and IIS settings as specified but when I try to load-up the site I get the following error:

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

The connection string in web.config is as follows:

<add name="Gemini" connectionString="Server=DEV-SQL; Initial Catalog=CounterSoftGemini; trustedconnection=true"/>

Thank you
midlandsco-op
· 1 		midlandsco-op
Monday, May 10, 2010, 1:21:15 PM
Replies (1)
helpful
0
not helpful

You have configured to connect to SQL using a trusted connection (windows authentication).
However, your Gemini application pool is not associated with a windows user. Please amend Gemini's  application pool identity and set it to a valid network user or use SQL username / password to connect eg:
<add name="Gemini" connectionString="Server=MyServer; Initial Catalog=CounterSoft_Gemini; uid=sa; pwd=gemini" />
Mark Wing
· 9108 		Mark Wing
Monday, May 10, 2010, 1:34:22 PM