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.




Installer couldn't authenticate with DB server.

web-app

In our company we have a SQL server were we have Gemini DB, at the current time we have Gemini 2.0.5 working in, yesterday we were trying to upgrade to 2.1.1 version, and the installer was giving us error that could not connect to the database by using the 'sa' login information, we used a different database user and the same it would say that couldn't connect.

Then we tried with the windows authentication, using my user which has administrator rights in the database, and started the installation until it got to the part that it wanted to run the sql scripts to modify the database and then started script failure for every single one. I'm not sure what happened there, but i was expecting to be more smooth, so we have to cancel the upgrade. In my test site the installation went very well, but the difference is that in this case the IIS server is separate from the DB server; in my test site I had both on the same computer.

So if you have a work around I surelly like to hear it.

ricardito
· 1
ricardito
Replies (3)
helpful
0
not helpful

You can run the scripts manually. They should be installaed under the database folder.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I was checking the instructions in the manual, and it says to run "Create-Procs.sql" am I needed to run "Upgradev2-0.sql" and "Upgradev2-1.sql" before that?, this part its not so clear because of a paragraph that says the next:

"2.7.3 Version 2.0.2 to Version 2.0.5
The following steps should be executed in the order specified to ensure that your existing
Gemini installation is ported to the new Gemini release:
1. Execute the "CREATE_PROCS.SQL" script in your existing Gemini database. This
script can be found in the " Database" folder.
Configuration File Changes
• New configuration items:
o IssueLinkQualifier"

please advice.


ricardito
· 1
ricardito
helpful
0
not helpful

You need to run UpgradeV21.sql followed by createview.sql and creaprocs.sql


Saar Cohen
· 5000
Saar Cohen