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.




What's the connection string for windows only security?

web-app

We've recently changed our SQL server to to use Windows only authentication. What do I need to change in the web.config to get Gemini to work? When I try and connect to our Gemini site (which is on a different server to SQL) at the moment I get user whatever not associated with a trusted SQL connection.
Chappers
· 1 		Chappers
Tuesday, June 20, 2006, 9:26:39 AM
Replies (5)
helpful
0
not helpful

The problem is that the web app is running under local ASPNET user and therefore its not associated with a trusted connection on the database server.

You can try and create the ASPNET user on the database server.
Mark Wing
· 9108 		Mark Wing
Tuesday, June 20, 2006, 10:17:10 AM
helpful
0
not helpful

Thanks for responding. I can create the ASPNET user but surely I need to amend the web.config connection string as well? And maybe some other bits?
Chappers
· 1 		Chappers
Tuesday, June 20, 2006, 1:09:29 PM
helpful
0
not helpful

Yes, the connection string needs changing. Seee http://www.countersoft.com/downloads/gemini.pdf for more info (section 4.1).
Saar Cohen
· 5000 		Saar Cohen
Tuesday, June 20, 2006, 9:59:24 PM
helpful
0
not helpful

Hi Saar

I have a question regarding Windows authentication. The application is  not working and the following error was displayed:

Server Error in '/TicketSystem' Application

Login failed for user 'BRENCOURT\NYIISQA$'

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 'BRENCOURT\NYIISQA$'.

The connection string is "Data Source=WORKSTATION71;Initial Catalog=TicketSystem;Integrated Security=True"

Ticket System is the name of my virtual directory. SQL Server is on the remote machine.

I have set impersonate = true in the web.config file.

I would appreciate your help in this regard. Also, I am not sure how to create a user before turning on the windows authentication.

Thanks

Meg
meg41
· 1 		meg41
Wednesday, June 28, 2006, 10:31:13 PM
helpful
0
not helpful

http://community.countersoft.com/forums/thread/310.aspx
Mark Wing
· 9108 		Mark Wing
Thursday, June 29, 2006, 10:11:08 AM