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.




Unable to set the SQL Server Instance Name in installer

web-app

Windows XP SP2
IIS5.1
SQL 2000
.net 2.0 & 3.0

I am trying to install Gemini for the first time as part of an evaluation and I cannot get it to install. I have simply downloaded the installer and it works through the install as far as where I provide the SQL Server Instance. I am running SQL on the same machine as I am doing the installation. I have TCP/IP and Named Pipes enabe. I have tried entering the followign but none seem to work;
- localhost
- .
- localhost\SQL instance
- localhost\SQL instance, IP 
- machine name\SQL instance
- \SQL instance
- IP\SQL instance
- IP

In the installer I have;
database name: GEMINI (default)
SQL Server Version: SQL 2000
Populate new GEMINI database selected
Authentication Mode: Windows Auth

Each time I get the same message saying: Connection failed. Would you like to try again?

Can someone provide me with a sample of the format that the installer expects? I have seen that this problem is already on the forum but there is no resolution highlighted.

As I have not installed the product I have no gemini config files to manually edit.

I have no problem connecting 3 other products to the databases running on the SQL instance so I do not believe it si an issue with this.

Cheers,
Daryl

darylo
· 1
darylo
Replies (7)
helpful
0
not helpful

The installer expects the following:

Server Name\Instance Name

However, if this does not work for you, you can try the manual zip install: http://www.countersoft.com/Downloads/CounterSoftGeminiv226.zip

This document will explain how to install: http://www.countersoft.com/Downloads/Installing%20Gemini.pdf

 

All you have to do is create a virtual directory, set it to run under ASP.NET 2.0, copy the web files over and amend the connection strings in the web.config file.

Then run the SQL scripts on your database.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Does that mean that this is a know problem with the installer?


darylo
· 1
darylo
helpful
0
not helpful

Seems like it. The problem is that we can never replicate it.

We suspect it is to do with sql server settings regarding TCP/IP and named pipes.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I have not had time to work things through to its conclusion but I have overcome this particular problem.

To do so I manually created the database 'GEMINI' in SQL Server and then simply put a a dot as the server name (localhost). My installation of SQL Server is default and does not have a specific SQL Instance name. It then connected OK so it would seem that the installer is trying to connect to the specific database and not simply verify the path to the SQL Server Instance before it creates the database (or was it always intended that the DB be created manually in Enterprise Manager?)
This allowed the installation to progress and the installer created a number of tables in the GEMINI database. I do not know if it is the full set of course.

I can not log into the system yet but I have not had time to even try and work through the problem so it may be something small on my side. I will raise a seperate thread on it if I can not resolve it.

Daryl


darylo
· 1
darylo
helpful
0
not helpful

The Installer does not create the database. It needs an existing database to work with. It just creates the tables etc...


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

That might explain it then!
It may be a good idea if the installer were to inform you of this as it is not obvious for someone that just downloads it and installs. It is not a big ask, but it was not obvious.

Regards,
Daryl


darylo
· 1
darylo
helpful
0
not helpful

Hear Hear. Had the same problem myself

Doug


DeeBee
· 1
DeeBee