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.




Gemini 2.2.2 & SQL 2005

web-app

Sorry for the newbie question here, but the only guy that knows Gemini here left.

I am trying to install Gemini 2.2.2, using an existing Gemini 2.0 database on a SQL 2005 server.

During the install, I specify the server instance, database name, userID and password. I enter all the information (which I know is correct as I have used it to set up and ODBC on another machine). However, the connection always fails.

Does Gemini need to be installed on the same physical server the database is installed on? That seemed to be the only way I got a successful connection.
MarkDBA
· 1 		MarkDBA
Tuesday, September 25, 2007, 10:27:43 PM
Replies (9)
helpful
0
not helpful

The install should work with any server setup. I don't suppoe that you have put localhost as the server?

Either way, you can simply change the connection strings in the web.config file to point to the correct SQL server instance.
Saar Cohen
· 5000 		Saar Cohen
Wednesday, September 26, 2007, 1:04:02 AM
helpful
0
not helpful

I think you misunderstood me. The installation itself is what is failing, not the application.

The installation is not able to run because the install package doesn't recognize the database server information being used. Since the application isn't yet installed, there is no web.config file.

However, if I install directly on the database server it will install normally.
MarkDBA
· 1 		MarkDBA
Wednesday, September 26, 2007, 7:06:56 PM
helpful
0
not helpful

I see. Are you sure that the web server can see the SQL server?

You can download the zip and do the manual install if it still fails.
Saar Cohen
· 5000 		Saar Cohen
Wednesday, September 26, 2007, 8:25:05 PM
helpful
0
not helpful

Hello !

i have exactly the same problem with this params :
- localhost
- localhost\SQL instance
- machine name\SQL instance
- \SQL instance
- IP\SQL instance
- IP

no way to finish the setup, always the same message : ConnectionFailed

Thanks 4 help !
Regards
SillyJoe
· 1 		SillyJoe
Wednesday, October 3, 2007, 4:07:38 PM
helpful
0
not helpful

Did you enable TCP/IP in SQL Server?
Mark Wing
· 9108 		Mark Wing
Wednesday, October 3, 2007, 4:59:34 PM
helpful
0
not helpful

Same problem here (with 2.2.5 installer).

  • Remote connections are enabled (for both TCP/IP and named pipes)
  • SQL Server Browser is running
  • Other applications (like CommunityServer) install without problems
  • Tried connecting bij instance name, IP address, etc.
  • Tried using Windows and SQL authentication

The error message is: Connection failed. Would you like to try again? [Retry, Cancel]

All help is appreciated.
Stouthart
· 1 		Stouthart
Saturday, November 3, 2007, 10:01:42 AM
helpful
0
not helpful

Can you try the manual installation (zip file)?

 
Saar Cohen
· 5000 		Saar Cohen
Saturday, November 3, 2007, 10:57:16 AM
helpful
0
not helpful

Any resolution for this.  I am having the same issues.  I have tried both the manual and automated installations. 

Environment: Win2003, SQL2005

The sqlserver is on a different box that IIS
Bander
· 1 		Bander
Thursday, January 3, 2008, 3:11:21 PM
helpful
0
not helpful

did you set the connection string in the web.config file?

If so, what error do you get?
Saar Cohen
· 5000 		Saar Cohen
Thursday, January 3, 2008, 3:19:42 PM