Hello,

I have been trying to figure out from the 2.2.6 documentation how I should edit the web.config to reflect a remote sql instance holding the gemini db and accessing this db with a windows AD account with a gemini virtual directory in c:\inetpub\virtualdirname\

I have looked through the forum here and am not much clearer on what to do after referring to the sections in the 2.2.6 ( sections 9.5; 9.51;9.52 in the 2.2.6 docs )) gemini documentation.

I think my issue may relate to the worker process trying to make a connection as the IUSR_hostname account rather than the domain\user account I have specified.

I tried looking at msdn and some other pages such as

http://www.feed-squirrel.com/index.cfm?evt=viewItem&ID=39092

The problem is when trying to read up on identity impersonation most developer based pages seems to just say "insert string X between the <system.web> tags "

As the gemini web.config seems to have quite a few of these tags I am finding it rather difficult to determine where these entries should go.

My web config connection strings read something like this :

..data source=SQLSERVERNAME;initial catalog=Gemini;user id=domainname\username;password=userspassword"/>

 I want to make the connection to the DB server as the AD user but preferably would like to still run the site under the IUSR_machinename account.

My dialect is set for sql2005 to match the DB server, the gemini DB exists; the scripts were run on the db,  the domain user I want to use for the connection has some rights on the DB and at the very least should be able to authenticate.

 
Many thanks if you are able to assist.