Hi,

I am completely stumped.

Im running

• <div mce_keep="true">Vista</div>
• <div mce_keep="true">SQL2005 SP2</div>
• <div mce_keep="true">Visual Studio 2008 SP2</div>

I can connect from Management Studio using my domain credentials.  

From within the VS IDE I can connect to the database ok however when I try debugging my WebApp it comes up with

 A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

 The connection string from the web.config is

<add name="TESTSQLConnectionString" connectionString="Data Source=(local);Initial Catalog=SAMPLEDB;Integrated Security=SSPI;Min Pool Size=5;Max Pool Size=60;Connect Timeout=30" providerName="System.Data.SqlClient"/>

</connectionStrings>

Things I have tried.

• Changing ports 1433
• Firewall disabling
• Remote Connection enabled on SQL Server
• TCP/IP and Named Pipes enabled in configuration
• Modified Web.Config to use IP Addresses/ Usernames passwords /Trusted_Connections/ Different SQL Server on a different machine
• Re-Installing SQL Server

 So I have absolutely no idea what to do anymore.

Can anyone give me suggestions on what to try?

Many Thanks

Jeremy