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.




Problems after Manual Installation

web-app

I checked the remote connection status of the SQL2K5 server and remote connections (named pipes & TCP) were allowed.  I'm using an IIS Server with Gemini on one server and SQL2K5 on another server.  Both servers have Win2K3 Server installed.  Any ideas would be appreciated.

Turning custom error messages off was a great idea from another posting; thanks.

==================================================

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  5/16/2007
Time:  3:28:57 PM
User:  N/A
Computer: ??????????????????
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/16/2007 3:28:57 PM
Event time (UTC): 5/16/2007 9:28:57 PM
Event ID: 9b43aa40ca6b4ae5a1a1a615ebca5c0e
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1858112242/Root-1-128238245207668956
    Trust level: Full
    Application Virtual Path: /
    Application Path: D:\Gemini\
    Machine name: ????????????????? 
 
Process information:
    Process ID: 5952
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: TypeInitializationException
    Exception message: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.
 
Request information:
    Request URL: http://localhost:8085/Default.aspx
    Request path: /Default.aspx
    User host address: 127.0.0.1
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at CounterSoft.Gemini.Business.ApplicationSettings.getShowUserRegistrationLink()
   at CounterSoft.Gemini.Default.PageLoad(Object sender, EventArgs e)
   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

==================================

<nhibernate>
      <!-- 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.connectionstring" value="data source=??.???.???.???;initial catalog=Gemini;user id=GeminiUser;password=???????"/>
      <!-- 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=??.???.???.???;initial catalog=GEMINIASPNETDB;user id=Gemini_User;password=W3lcome02Gemini" providerName="System.Data.SqlClient"/>
  </connectionStrings>

==================================

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

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: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

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): An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   NHibernate.Connection.DriverConnectionProvider.GetConnection() +97
   NHibernate.Impl.SessionFactoryImpl.OpenConnection() +60



[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.get_GetInstance() +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_Theme() +0
   CounterSoft.Gemini.Business.BasePage.OnPreInit(EventArgs e) +65
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +521

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

jrhoten
· 1 		jrhoten
Thursday, May 17, 2007, 12:20:05 AM
Replies (4)
helpful
0
not helpful

Are you using a named instance of SQL server?

If so, remember that you have to put the instance name: Server\Instance.
Mark Wing
· 9108 		Mark Wing
Thursday, May 17, 2007, 10:26:11 AM
helpful
0
not helpful

Yes I'm using a named instance and that clearly means the connection string is wrong.....can you tell me how to modify the connection strings to utilize a named instance please?

Thanks for replying to my question.
jrhoten
· 1 		jrhoten
Thursday, May 17, 2007, 2:56:27 PM
helpful
0
not helpful

Open the web.config file and change the following:

<add key="hibernate.connection.connectionstring" value="data source=Server Name\Instance Name;initial catalog=Gemini21;user id=sa;password=xxx"/>

 

<add name="ProfilesServer" connectionString="data source=Server Name\Instance Name;initial catalog=Gemini_21;user id=sa;password=xxx" providerName="System.Data.SqlClient"/>
Mark Wing
· 9108 		Mark Wing
Thursday, May 17, 2007, 3:09:32 PM
helpful
0
not helpful

Thanks that worked.........this was certainly a learning experience.....again, thanks
jrhoten
· 1 		jrhoten
Thursday, May 17, 2007, 6:25:32 PM