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.




Errors upgrading 2.0.5 to 2.1.1

web-app

While trying to upgrade Gemini 2.0.5 to 2.1.1 using the automated installer, I get the following errors:

Error executing Upgrade_v2-1.sql script.  Please consult Gemini documentation.

I get similar errors for InstallCommons.sql and InstallProfile.sql.

Once the installation completes, I get the stack trace below when trying to access Gemini.  I have tried adding the NT AUTHORITY\NETWORK SERVICE account to the GEMINI database as a user, but the problem persists.  Thanks in advance for any help.

Server Error in '/' Application.

Cannot open database requested in login 'GEMINI'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'GEMINI'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[SqlException (0x80131904): Cannot open database requested in login 'GEMINI'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
CounterSoft.Gemini.Commons.GeminiHelper.LogEx(Exception ex, String strOtherInfo) +56

[ADOException: cannot open connection]
CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +469
CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14
CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89
CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1565
CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() +48
CounterSoft.Gemini.Business.Initialiser..cctor() +20

[TypeInitializationException: The type initializer for 'Initialiser' threw an exception.]
CounterSoft.Gemini.Business.DatabaseApplicationSettings.getGetInstance() +14
CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() +5
CounterSoft.Gemini.Business.ApplicationSettings..cctor() +5

[TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.]
CounterSoft.Gemini.Business.ApplicationSettings.get
ShowUserRegistrationLink() +0
CounterSoft.Gemini.Default.Page_Load(Object sender, EventArgs e) +285
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

tomaddox
· 1
tomaddox
Replies (6)
helpful
0
not helpful

You need to give database access to the NT user.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

You know, I would swear that I tried that before, but I guess I didn't.  It's working now, thanks!


tomaddox
· 1
tomaddox
helpful
0
not helpful

I now receive the same basic error for the database GEMINI_ASPNETDB when clicking on the "All projects issue reporting" link (Issues.aspx?PROJID=-2&m=1).  I would add the Network Service account to this database, but the database does not seem to exist.


tomaddox
· 1
tomaddox
helpful
0
not helpful

You need to create it and run the installcommon.sql and installprofile,sql scripts or you can run them on the Gemini database. Make sure you change the profile connection string in the web.config file.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Great, thanks.  What is the minimum permission level needed by the Network Service account?


tomaddox
· 1
tomaddox
helpful
0
not helpful

We recommend db_owner.


Saar Cohen
· 5000
Saar Cohen