Connection Error to SQL 2000 (v2.1)

web-app

I'm trying to upgrade my Gemini installation to 2.1. I've created a new website to have it run under asp.net 2.0 (manual install). Have created a new database and run all the scripts as well as upgrading an existing database and I get the same error trying to connect to either database.

Appropriate bits in web.config:
<nhibernate>
      
      <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
      
      <add key="hibernate.connection.connectionstring" value="data source=192.168.1.12;initial catalog=Gemini;user id=sa;password=XXXXXXXXX" />
        
      <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
      <add key="hibernate.connection.driverclass" value="NHibernate.Driver.SqlClientDriver"/>
</nhibernate>
<GeminiLocalisation>
    <GeminiLocalisation defaultCulture="en-US" languageFilePath="Language"/>
</GeminiLocalisation>
<connectionStrings>
    <add name="ProfilesServer" connectionString="data source=192.168.1.12;initial catalog=Gemini;user id=sa;password=XXXXXXXX" providerName="System.Data.SqlClient"/>
</connectionStrings>

The error message I get is:

        <span><h1>Server Error in '/' Application.<hr color="silver" size="1" width="100%"></h1>

        <h2> <i>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)

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>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.

        <b> Exception Details: </b>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)

        <b>Source Error:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code>

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.

              </td>
           </tr>
        </tbody></table>

        <br>

        <b>Stack Trace:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre>[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)]<br>   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734867<br>   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188<br>   System.Data.SqlClient.TdsParser.Connect(Boolean&amp; useFailoverPartner, Boolean&amp; failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820<br>   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628<br>   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170<br>   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359<br>   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28<br>   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424<br>   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66<br>   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496<br>   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82<br>   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105<br>   System.Data.SqlClient.SqlConnection.Open() +111<br>   NHibernate.Connection.DriverConnectionProvider.GetConnection() +97<br>   NHibernate.Impl.SessionFactoryImpl.OpenConnection() +60<br><br>[ADOException: cannot open connection]<br>   CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +465<br>   CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14<br>   CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89<br>   CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1669<br>   CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() +48<br>   CounterSoft.Gemini.Business.Initialiser..cctor() +20<br><br>[TypeInitializationException: The type initializer for 'Initialiser' threw an exception.]<br>   CounterSoft.Gemini.Business.DatabaseApplicationSettings.get_GetInstance() +14<br>   CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() +5<br>   CounterSoft.Gemini.Business.ApplicationSettings..cctor() +5<br><br>[TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.]<br>   CounterSoft.Gemini.Business.ApplicationSettings.get_ShowUserRegistrationLink() +0<br>   CounterSoft.Gemini.Default.Page_Load(Object sender, EventArgs e) +255<br>   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15<br>   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34<br>   System.Web.UI.Control.OnLoad(EventArgs e) +99<br>   System.Web.UI.Control.LoadRecursive() +47<br>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061<br></pre>

              </td>
           </tr>
        </tbody></table>

        <br>

        <hr color="silver" size="1" width="100%">

        <b>Version Information:</b>&nbsp;Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

        </font>

<!--

[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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at 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) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.Impl.SessionFactoryImpl.OpenConnection() [ADOException]: cannot open connection at CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) at CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) at CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) at CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() at CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() at CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialiser..cctor() [TypeInitializationException]: The type initializer for 'Initialiser' threw an exception. at CounterSoft.Gemini.Business.DatabaseApplicationSettings.getGetInstance() at CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() at CounterSoft.Gemini.Business.ApplicationSettings..cctor() [TypeInitializationException]: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception. 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) [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.defaultaspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) -->

jeffrey.schoolcraft · 1
Wednesday, March 28, 2007, 3:13:19 PM

Replies (6)

Is the database on the same server as the web app?

Can you connect to it using Query Analyzer from the web server?

Mark Wing · 9108
Wednesday, March 28, 2007, 3:34:43 PM

No, it's not on the same server.

I can connect to the databse in question from the web server using management studio (the target database is SQL 2k, not 2k5).

jeffrey.schoolcraft · 1
Wednesday, March 28, 2007, 3:41:53 PM

Are you connecting to a named instance such as XXX\YYY?

Mark Wing · 9108
Wednesday, March 28, 2007, 3:52:55 PM

No, just to the ip address of the server (192.168.1.12), sa, password, and I specified the database just to make sure it wasn't db specific problems

jeffrey.schoolcraft · 1
Wednesday, March 28, 2007, 3:58:45 PM

Yes, but are you using the default instance of SQL 2000?

Can you try another database server?

Saar Cohen · 5000
Wednesday, March 28, 2007, 10:32:09 PM

I am connecting to the default instance of SQL 2000, yes.

I'll try to connect to another database server.

jeffrey.schoolcraft · 1
Wednesday, March 28, 2007, 10:42:42 PM

Gemini Community Support Site

Connection Error to SQL 2000 (v2.1)