I keep getting an error when trying to access the database from a web site it returns an error that it can't find the server or it's inaccessible.

Now I did a search and I found many possible reasons - I turned on named pipes and also did what [this link](https://stackoverflow.com/questions/1339944/cant-connect-to-localhost-but-can-with-computer-name-in-sql-server-2008) suggested (i.e. set the IP addresses to "enabled") yet I'm still getting the error.

> 
> Error SqlException: System.Data.SqlClient.SqlException (0x80131904):
>  Error An error has occurred with the network or the occurrence when
>  connecting to SQL Server. Can not find server or is not available.
>  Verify that the instance name is correct and that the configuration of
>  SQL Server allow remote connections. (provider: Named Pipes Provider,
>  error: 40 - Could not open a connection to SQL Server) at
>  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>  exception, Boolean breakConnection) at
> 
> 
> 

I also downloaded [this little app](http://dbaccesstesterclient.codeplex.com/) and I copy/pasted the connection string from the web.config used in IIS for this site and the app is able to connect and query the same database being targeted by the web site.

And, as the title says, this error is utterly missing when I debug it in VS2010. What could be causing this error when launching from the server?

Edit: the connection string includes a user name and password (it's not Windows Authentication).