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.




Ongoing Error after setup

web-app

I've read thru the manual, set Gemini up as it states using Windows Auth and I still get the error

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I checked the SQL Server (its 2000) and it's using Mixed Authentication.  Here is the connection string the config file:

      <add key="hibernate.connection.connectionstring" value="data source=xxxx ;initial catalog=GEMINI;TrustedConnection=true"/>

So why is Gemini trying to use a SQL Server connection when it's defined to use Windows Security..

Oh, BTW: During installation, the connection test passed.

Any help is appreciated... thnx.

mgnat
· 1
mgnat
Replies (3)
helpful
0
not helpful

It is trying to use windows authentication, however, the asp.net process is not associated with one and therefore can not connect. It worked during the install becuase it has used your credentials.

I suggest you use sql user name and password.

 


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

No can do w/Sql Server Auth.. We have Active Directory that is configured with all right needed... I'll figure it out.. There's a better answer than just use SQL Server Auth.

Thx.


mgnat
· 1
mgnat
helpful
0
not helpful

If I understand you correctly, you want the connection to be user based. If that is the case you will need to use impersonate = true in the web.config file.


Saar Cohen
· 5000
Saar Cohen