I've build a web application on a Windows XP computer that has SQL Server
Express edition installed on it. I then copied the web application to a
Windows 2003 Server box. When trying to run the application an error occurs:


provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified

Why does this error exist and how can it be fixed?

Where is SQL Express installed?

IF still on your XP, then check the XP firewall settings.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Jim" <Jim@discussions.microsoft.com> wrote in message
news:9885CD1E-CE71-40AE-A621-73231460E52B@microsoft.com...
> I've build a web application on a Windows XP computer that has SQL Server
> Express edition installed on it. I then copied the web application to a
> Windows 2003 Server box. When trying to run the application an error
> occurs:
>
>
> provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified
>
> Why does this error exist and how can it be fixed?
>
>
>

The connection string is:

<add name="ASPNETDBConnectionString" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ASPNETDB.MDF;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />

"Jim" wrote:

> I've build a web application on a Windows XP computer that has SQL Server
> Express edition installed on it. I then copied the web application to a
> Windows 2003 Server box. When trying to run the application an error occurs:
>
>
> provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
> Specified
>
> Why does this error exist and how can it be fixed?
>
>
>

Data source needs to be SQLServerBox\SQLEXPRESS
You are using just .\SQLEXPRESS so it's going to look for
SQL Server locally - on the IIS box. If you just copied the
web site to another server and Express, the databases are
still on the other box, that indicates it is likely not
pointing to the correct server.
If you didn't change anything from the defaults on the box
where Express is installed, you will also need to enable
remote connections and make sure the browser service is
running.
And finally, if windows firewall is running on the XP box
where Express is installed, add an exception for
sqlservr.exe

-Sue

On Fri, 27 Oct 2006 14:56:01 -0700, Jim
<Jim@discussions.microsoft.com> wrote:

>The connection string is:
>
><add name="ASPNETDBConnectionString" connectionString="Data
>Source=.\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\ASPNETDB.MDF;Integrated
>Security=True;User Instance=True"
> providerName="System.Data.SqlClient" />
>
>"Jim" wrote:
>
>> I've build a web application on a Windows XP computer that has SQL Server
>> Express edition installed on it. I then copied the web application to a
>> Windows 2003 Server box. When trying to run the application an error occurs:
>>
>>
>> provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
>> Specified
>>
>> Why does this error exist and how can it be fixed?
>>
>>
>>

I am new to setting up the server side and also get the same error.
When the connection string is added, do I need to also add the following
<remove name="LocalSqlServer"/>



*** Sent via Developersdex http://www.developersdex.com ***