Home Home
  login

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.




Problem after manual setup

add-ons

After installing Gemini issue tracker, I keep having problem using it to view and create issues. the error I get is a db connection. What should I do in the config file to solve this? The error message is as below. I am using SQL server 2005. Thanks in advance for your help. 

 

Stack Trace:


[SqlException (0x80131904): Login failed for user 'sa'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +456
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
   System.Data.SqlClient.SqlConnection.Open() +162
   System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
   System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +199
   System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +736
   System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +430
   System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +410
   System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +112
   System.Configuration.SettingsBase.getItem(String propertyName) +91
   System.Web.Profile.ProfileBase.GetInternal(String propertyName) +37
   System.Web.Profile.ProfileBase.getItem(String propertyName) +70
   System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) +4
   CounterSoft.Gemini.Business.Profile.getMaxIssuesPerPage() +62
   CounterSoft.Gemini.IssuesWeb.PageLoad(Object sender, EventArgs e) +8513
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
   System.Web.UI.Control.OnLoad(EventArgs e) +80
   CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e) +4
   System.Web.UI.Control.LoadRecursive() +49
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3744

 

 
Ermias
· 1 		Ermias
Tuesday, May 8, 2007, 6:11:29 PM
Replies (4)
helpful
0
not helpful

You need to setup the connection strings in the web.config.
Mark Wing
· 9108 		Mark Wing
Tuesday, May 8, 2007, 6:20:14 PM
helpful
0
not helpful

Thanks for your reply. below is what I have in the config file for db connection. Can you tell me what I should change. I am using sql server 2005.

 

Thanks again

<nhibernate>
    <!-- The SQL Server dialect (Gemini supports "MsSql2005Dialect" or "MsSql2000Dialect" or "MsSql7Dialect") -->
    <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql7Dialect"/>
    <!-- The SQL Server database connection string -->
    <add key="hibernate.connection.connectionstring" value="data source=localhost;initial catalog=GEMINI;user id=sa;password=Nov119"/>
    <!-- Misc -->
    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
    <add key="hibernate.connection.driverclass" value="NHibernate.Driver.SqlClientDriver"/>
  </nhibernate>
  <GeminiLocalisation>
    <GeminiLocalisation defaultCulture="en-GB" languageFilePath="Language"/>
  </GeminiLocalisation>
  <connectionStrings>
    <add name="ProfilesServer" connectionString="data source=localhost;initial catalog=GEMINI;user id=sa;password=Nov119" providerName="System.Data.SqlClient"/>
  </connectionStrings>
Ermias
· 1 		Ermias
Tuesday, May 8, 2007, 10:07:13 PM
helpful
0
not helpful

The connection strings seems to be ok. Can you try and restart the web app?

I presume you have setup the profile database within the Gemini one.
Saar Cohen
· 5000 		Saar Cohen
Tuesday, May 8, 2007, 10:12:38 PM
helpful
0
not helpful

Yes, it is working now.

Thanks a lot!
Ermias
· 1 		Ermias
Wednesday, May 9, 2007, 4:24:34 PM