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.




SQL Connection Error

install

I have installed the service but when I try to start the web app - I get the following error can someone help please?

Server Error in '/Gemini' Application.

Please see my screenshot

ScreenShot036.png ]
User24402
· 1
User24402
Replies (7)
helpful
0
not helpful

The error suggests that the connection string is using the wrong password for the configured user (krishna). Open web.config file to set the connection string password.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I am using the windows authentication and I didnt specify anything separately - However I will check the Web.config file


User24402
· 1
User24402
helpful
0
not helpful

Hi there are two instances where I can find the UID and Password - which one should I change - By mistake Should I change the one under this:

>

<!-- ********************************************************** -->
<!-- ***** Countersoft Gemini: Database Connection String ***** -->
<!-- ********************************************************** -->

Another one is here

<!--  AUTHENTICATION  (Gemini possible modes are "Windows", "Forms") -->
        <!--trust level="Medium" originUrl=""/-->
        <authentication mode="Forms">
            <forms name=".Gemini40RTM" loginUrl="Default.aspx" timeout="60" path="/">
            </forms>
        </authentication>
        <authorization>
            <deny users="?"/>
        </authorization>
        <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
        <!--  SESSION STATE SETTINGS : InProc, SQLServer, StateServer -->
        <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=krishna;password=Mandarin79" cookieless="false" timeout="60" />
        <!--  GLOBALIZATION - This section sets the globalization settings of the application. -->
        <globalization culture="en-US" uiCulture="en-US" requestEncoding="utf-8" responseEncoding="utf-8"/>

User24402
· 1
User24402
helpful
0
not helpful

Change the first one (Countersoft Gemini: Database Connection String).


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Now I get a different error message:

Server Error in '/Gemini' Application.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to 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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to 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): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to 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) +4856727 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4867325 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +374 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +225 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +431 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117 System.Data.SqlClient.SqlConnection.Open() +122 NHibernate.Connection.DriverConnectionProvider.GetConnection() +102 NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare() +15 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper) +65 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory) +80 NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners) +599 NHibernate.Cfg.Configuration.BuildSessionFactory() +87 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a..cctor() +159

[TypeInitializationException: The type initializer for 'CounterSoft.Gemini.DataProvider.x73a34067f4cd229a' threw an exception.] CounterSoft.Gemini.DataProvider.xda48b22fffb4ce02..ctor() +14 CounterSoft.Gemini.Business.BusinessFactory.GetExceptionProvider() +20 CounterSoft.Gemini.Business.LogManager..cctor() +5

[TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.] CounterSoft.Gemini.Business.ApplicationSettings.getConfig() +0 CounterSoft.Gemini.Presenter.GeminiHttpModule.ApplicationAuthenticateRequest(Object source, EventArgs e) +183 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75


User24402
· 1
User24402
helpful
0
not helpful

Can you please help me to resolve this issue. I am struggling to install it from the beginning.


User24402
· 1
User24402
helpful
0
not helpful

Seems like your have changed the sql server's name which doesn't exist.


Mark Wing
· 9108
Mark Wing