SQL Network Interfaces, Error: 26 (after Deploying)

Hello All,

We are migrating from ASP.Net 1.1 to 2.0 and have built a new site with the 2.0 membership controls (Login, etc).  We're using VS2005/SQL Server 2005.  All works well from the development site but once it is deployed from our local machine to our intranet development server, the following error is encountered after the user types in a valid username/password and clicks the Login button (on the Login control on the Login.aspx page):

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Our web.config (for testing purposes only):

<?xml version="1.0"?>

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

WindowsMicrosoft.NetFrameworkv2.xConfig

-->

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<appSettings/>

<connectionStrings>

<add name="MyLocalSQLServer" connectionString="Initial Catalog=aspnetdb;data source=localhost;Integrated Security=SSPI;"/>

</connectionStrings>

<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

-->

<compilation debug="true"/>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<authentication mode="Forms">

<forms name="SqlAuthCookie" timeout="10"/>

</authentication>

<authorization>

<deny users="?"/>

</authorization>



<membership defaultProvider="MySqlMembershipProvider" >

<providers>

<clear/>

<add name="MySqlMembershipProvider"

connectionStringName="LocalSQLServer"

applicationName="FormsAuthSql"

type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

enablePasswordReset="true"

requiresQuestionAndAnswer="true"

requiresUniqueEmail="false"

passwordFormat="Clear"

minRequiredNonalphanumericCharacters="0"

minRequiredPasswordLength="3"

/>

</providers>

</membership>

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

-->

<customErrors mode="Off"/>

</system.web>

</configuration>

Any suggestions will be greatly appreciated!

Troy