Cannot connect to SQLEXPRESS via MS Enterprise Library??

[Crash]

Windows XP
MS SQLExpress
VS 2003
..NET 1.x SP1 {for Application}
..NET 2.0 {for SQLExpress}
MS Enterprise Library June 2005

This works from a command prompt

osql -E -S localhost\SQLEXPRESS

use <MyDatabase>
select * from <MyTable>
go

However on the same machine, attempting to use this
dataconfiguration.xml entry throws "SQL Server does not exist or access
is denied":

<connectionString name="SqlServerLocalHost">
<parameters>
<parameter name="database" value="<MyDatabase>"
isSensitive="false" />
<parameter name="Integrated Security" value="True"
isSensitive="false" />
<parameter name="server" value="localhost\SQLEXPRESS"
isSensitive="false" />
</parameters>
</connectionString>

Any ideas? Thanx in advance for your help...

 

[Crash]

Nevermind I fixed it...

Needed to start the SQL Browser service...

 

[Willy Denoyette [MVP]]

Don't know if Express comes with "SQL Server Configuration Manager" utility
though, but if it does you can change the TCP/IP properties and turn off
dynamic port mappings and enable the default TCP/IP port 1433 (or another
free port). When done, you can stop the Browser Service and connect your
clients over TCP/IP.



Willy.

|
| Nevermind I fixed it...
|
| Needed to start the SQL Browser service...
|