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.




Configure web.config file to point to a database in separate physical SQL server

web-app

I'm doing a fresh installation of Gemini 3.0.4.  I did the step 1 2, and 3 of Peforming a New Installation (page 7) on the Installation Guide.  I have problem with step 5 since my database is in a separate physical SQL server.  How do i modify the web.config to point to that database? Currently i'm having:

    <!-- The SQL Server dialect (Gemini supports "MsSql2005Dialect" or "MsSql2000Dialect" or "MsSql7Dialect") -->
        <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2005Dialect"/>
        <!-- The SQL Server database connection string -->
        <add key="hibernate.connection.connection_string" value="data source=localhost;initial catalog=Gemini;user id=sa;password=sapassword" />

My database name is: Gemini
My SQL server name is: SQL2005serv

When i go to IIS GUI, Right click on the Gemini Web Sites (under website folder), and Browse.  It gave me this error:  You are not authorized to view this page

Is there anything I did wrong or miss?  Any help is greatly appreciated!
-Kim-

kha
· 1
kha
Replies (2)
helpful
0
not helpful

Well, actually I don't see above error any more after changing the source= to source=sql2005serv

Additional info if it helps:
1) I took the backup of existing gemini database from SQL 2000 server and restored it to SQL2005 server which i'm using right now
2) Installed Gemini 3.0.4 on a new physical server (not reusing existing gemini server with old version 2.0.3)
3) NOTE: my new configuration has a separate physical server for gemini 3.0.4, a separate physical server for SQL2005

However, now i'm seeing this error:

Invalid object name 'gemini_applicationsettings'. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

Server Error in '/Gemini' Application.

Invalid object name 'geminiapplicationsettings'.

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: Invalid object name 'gemini
applicationsettings'.

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): Invalid object name 'geminiapplicationsettings'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
   System.Data.SqlClient.SqlDataReader.getMetaData() +62
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9
   NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) +32
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) +182
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +175
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +56
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +30

[ADOException: could not execute query [ SELECT this.settingid as settingid300, this.settingname as settingn2300, this.settingcategory as settingc3300, this.settingvalue as settingv4300, this.settingdesc as settingd5300, this.tstamp as tstamp300 FROM geminiapplicationsettings this WHERE this.settingname = ? ] Positional parameters: 0 EnableHTMLPosts [SQL: SELECT this.settingid as settingid300, this.settingname as settingn2300, this.settingcategory as settingc3300, this.settingvalue as settingv4300, this.settingdesc as settingd5300, this.tstamp as tstamp300_ FROM geminiapplicationsettings this WHERE this.settingname = ?]] NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +110 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) +78 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results) +324 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria) +42 NHibernate.Impl.CriteriaImpl.List() +12 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, ISession x45b53be31e53d68b, Object[] xdbd7e0681bb13f72) +55 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +53 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14 CounterSoft.Gemini.DataProvider.x99c4b1798e19cb2e.x1a95834709519378(String x2335cd6458013014) +89 CounterSoft.Gemini.Business.ApplicationSettings.GetGeminiConfiguration() +3362 CounterSoft.Gemini.Business.ApplicationSettings.getConfig() +74 CounterSoft.Gemini.Presenter.GeminiHttpModule.Application_AuthenticateRequest(Object source, EventArgs e) +370 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64


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


kha
· 1
kha
helpful
0
not helpful

Make sure that you are connecting to the correct instance and database. Also, check the owner of the gemini database objects.


Saar Cohen
· 5000
Saar Cohen