Error on connection to SQL Server 2005 Express

tads · **Posted:** Thu May 04, 2006 8:30 am

Hi all,

I´m trying to use the SQL Server 2005 Express Edtion, but the
following error occurs:

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)

The database is in local machine, to test the version 2005.
I configured the Local database in "SQL Server Surface Area Configuration"
to allow remote connections by using TCP/IP and Named Pipes,
but the above error occurs yet.

Is there a way to connect to SQL Server 2005 Express by using
NHibernate?

thank u very much!!!!

tads · **Posted:** Thu May 04, 2006 9:58 am

I solved the problem puting the Data Source with machine\sqlexpress like this:

Code:

  <nhibernate>
    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
    <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver"/>
    <add key="hibernate.connection.connection_string" value="Data Source=MACHINE_NAME\SQLEXPRESS;Database=basdb;User ID=acc;Password=pwd123;"/>
    <add key="hibernate.connection.isolation" value="ReadCommitted"/>
    <add key="hibernate.default_schema" value="basdb.dbo"/>
    <add key="hibernate.show_sql" value="true"/>
  </nhibernate> 

awilkins · **Joined:** Thu May 04, 2006 5:51 am **Posts:** 7

You might find that .\SQLEXPRESS also works (and without problems when you go to another machine).