views:

77

answers:

1

Hello,
I am have a Silverlight app that connects to a local SQL Server db. It works as expected on my WinXP computer, but not on the Win7 x64 computer. (SQL Server 2008 installed.)
When I run the app, I get this error:

The remote server returned an error: NotFound.

My web.config, AppSettings:

<!-- For Development -->
<!--<add key="ConnectionInfo" value="data source=localhost\SQLEXPRESS; database=db003;integrated security=True;" />-->
<!-- For Win7 ?? -->
<add key="ConnectionInfo" value="server=(local); database=db003; Integrated Security=True;" />

Thanks for any suggestions, I suspect it is something simple that my limited SQL Server experience hasn't encountered yet...

A: 

Try localhost\SQLEXPRESS instead of local.

UPDATE

I am positive that the express needs \SQLEXPRESS. On my machine I have:

  • MachineName\SQLEXPRESS.
  • SQL server browser is running
  • Shared Memory, TCP/IP and Named Pipes are enabled.
Damir Sudarevic
Thanks for the reply. Changing server=(local) to server=localhost\SQLEXPRESS (with or w/o paren) still gave the same error.
Number8

related questions