SQL Cant Find Server/instance When Deploying Website.

Hello All, please be gentle im very new to this stuff..

So if i add a record via a sql datasource using the ConnectDB connection string it adds it the the sql 2005 database called intranet.... If i try to add to it using an onbuttonlick(Code Below) event it comes up with the

"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) "

I have set remote connections on and tryed it with TCP/IP and TCP/IP and Named Pipes.   SQL is installed as the default instance.

If  both ways are using the same connection string surely it should work? Im not to sure where i am going wrong here...

Here is the code for the on button click event..
 
'INSERT NEW EMAIL INTO NEWSLETTER TABLE





1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

Protected Sub AddEmailButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles AddEmailButton.Click
Dim ConSTRING As String = ConfigurationManager.ConnectionStrings("ConnectDB").ConnectionString
'INSERT NEW EMAIL INTO NEWSLETTER TABLE
Dim cn As SqlConnection = New SqlConnection(ConSTRING)
Dim InsertSQL As String = "INSERT INTO Newsletter (Name, Email) VALUES (@Name, @Email)"
Dim cmd As SqlCommand = New SqlCommand(InsertSQL, cn)
cmd.Parameters.AddWithValue("@Name", (TBname.Text))
cmd.Parameters.AddWithValue("@Email", (TBemail.Text))
cn.Open()
cmd.ExecuteNonQuery()
LBLstatus.Text = "Success, Email is now on Mailing List"
cn.Close()


Below is my web.config connection string

<connectionStrings>
  <remove name="LocalSqlServer" />
  <add name="ConnectDB" connectionString="Data Source=10.130.0.11;Initial Catalog=intranet;User ID=XXXXX;Password=XXXXX;"
   providerName="System.Data.SqlClient" />
 </connectionStrings>

 

Any help on this would be great as im stuck..

Best Regards

Leigh