Nhibernate sql Error for express connection - error: 26 - Server / instance location error

Question

I can communicate normally with regular ado.net. However, when trying to connect nHibernate, I get the following error.

hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8" ?> <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"> <session-factory> <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property> <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property> <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property> <property name="connection.connection_string">Server=xxxxx\SQLEXPRESS; Database=xxxxx; User ID=xxxxx; Password=xxxxx; Trusted_Connection=True</property> <property name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle</property> <property name="show_sql">true</property> </session-factory> </hibernate-configuration> 

server error

When connecting to SQL Server, a network-related or specific instance error occurred. The server was not found or was not available. Verify the instance name is correct and configure SQL Server to connect remotely. (provider: SQL network interfaces, error: 26 - server / instance location error)

Full stack

[SqlException (0x80131904): A network-related or specific instance error occurred while establishing a connection to SQL Server. The server was not found or was not available. Verify the instance name is correct and configure SQL Server to connect remotely. (provider: SQL network interfaces, error: 26 - server / instance location error)] System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, logical connection disconnection) +4845255 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning (TdsParsject stateObj) +194 System.Data.SqlClient.TdsParser.Connect (ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean integratedClientSlocentclientp01 ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover (String host, String newPasswor d, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist (SqlConnectionTlectClientSlnStlnClnStlnStlnClnTlnStlnCntlnctlnctlnctlnctlnctlntlnctlnctlnctlnctlntnctlntlnctlntnctlntlntnctlntlntnntlnctlntclntnntlnctlnntlnctlntncltnntlnct (DbConnectionPoolIdentity identifier, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189 System.Data.SqlClient.SqlConnectionFactory.CreateConnection, DocConnectBonnPodOnConnectOnConnectOnConnectOnConnectOnConnectOnConnectOnConnection .DbConnectionFactory.CreatePooledConnection (DbConnection owningConnection, DbConnectionPool pool, options DbConnectionOptions) +31 System.Data.ProviderBase.DbConnectionPool.CreateObject (DbConnection o wningObject) +433 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest (DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection (DbConnection owningObject) +499 System.Data.ProviderBaseConnection DbConnectionDbConnection DbConnection .Data.ProviderBase.DbConnectionClosed.OpenConnection (external connection DbConnection, DbConnectionFactory connectionFactory) +117 System.Data.SqlClient.SqlConnection.Open () +122 NHibernate.Connection.DriverConnectionProvider.GetConnection.Spelpt.pelpt.pludtp2102 Prepare () +15 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords (dialect, IConnectionHelper connectionHelper) +65 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update (ISessionFactory.Splfact sessionfactory sessionfactory sessionfactory IMapping mapping, Settings, Listen EventListeners) +599 NHibernate.Cfg.Configuration.BuildSessionFactory () +87 XXX.Domain.Repositories.NHibernateHelper.get_SessionFactory () in D: \ dev \ MyProject \ XXX \ XXX.Domain \ Repositories \ NHibernateHelper.cs: 23. Domain.Repositories.NHibernateHelper.OpenSession () in D: \ dev \ MyProject \ XXX \ XXX.Domain \ Repositories \ NHibernateHelper.cs: 31 XXX.Domain.Repositories.EntryRepository.GetCountByGmapId (Int32 gmapId) in D: \ dev \ XXX \ XXX.Domain \ Repositories \ EntryRepository.cs: 152 XXX.Controls.Activity.BindRepeater (Int32 id) in D: \ dev \ MyProject \ XXX \ XXX.Controls \ Activity.ascx.cs: 58 XXX.Controls. Activity.DropDownListMaps_SelectedIndexChanged (object sender, EventArgs e) in D: \ dev \ MyProject \ XXX \ XXX.Controls \ Activity.ascx.cs: 75 System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged (EventArgs e) +111 System. Web.UI.WebControls.DropDownList.RaisePostDataChangedEvent () +134 System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandle r.RaisePostDataChangedEvent () +10 System.Web.UI.Page.RaiseChangedEvents () +165 System.Web.UI.Page.ProcessRequestMain (Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1485

Answer 1

From http://www.connectionstrings.com/ :

 Server=myServerAddress;Database=myDataBase; User ID=myUsername;Password=myPassword;Trusted_Connection=False; 

I would try setting Trusted_Connection=False and see what happens.

Usually, when I see this error, it is due to the fact that my connection string is incorrect or the database is inaccessible / inaccessible, but I am sure that there are other potential reasons.