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.




DB server and application location

web-app

Is it necessary that the SQL Server and the Web server running the Gemini be running the same machines?

Enn
· 1 		Enn
Thursday, June 3, 2010, 2:06:44 PM
Replies (3)
helpful
0
not helpful

No, you can modify the connection string in the web.config file to point to the database server.
Mark Wing
· 9108 		Mark Wing
Thursday, June 3, 2010, 3:20:02 PM
helpful
0
not helpful

I get error like"Login failed for domain\machinename" when I try to run the application. The machinename is the host name of my machine.

Details:

- Gemini is installed on the freshly formatted machine (hostname : machinename)

- Gemini DB is available on another machine. The scripts have been run and there are no errors ( I migrated from 2.0.2 to 3.6.5)

- The DB administrator has given me <domain name>\<loginname> permissions (below securit\logins in SQL server) for the Gemini DB as dbowner and dbadmin. Apart from me there is a sa account and nothing else.

- I try connecting using trusted connection = true.

Do I need to ask DB admin to add NETWORK_SERVICE as well?

Anything else I should be doing to bring the application up?
Enn
· 1 		Enn
Friday, June 4, 2010, 2:43:10 PM
helpful
0
not helpful

Becasuse you are using windows authentication to connect to SQL you will need to run Gemini (application pool user) using an account that can connect to your SQL box.
Otherwise, simply use SQL username / password instead in the connection string.
Mark Wing
· 9108 		Mark Wing
Friday, June 4, 2010, 3:29:16 PM