<connectionStrings>
<add name="Conn" connectionString="Data Source=miServer; Initial Catalog=miBD; user Id=miUser; Password=miPwd" />
</connectionStrings>
dim Conn as New SqlConnection
Conn.ConnectionString = ConfigurationManager.ConnectionStrings"Conn").ToSt ring
Dim cmd As New SqlCommand("SELECT * FROM Productos", Conn)
Dim Dr as SqlDataReader
Try
Conn.Open()
Dr = cmd.ExecuteReader
While Dr.Read
' lo que quieras hacer
End While
Catch ex As Exception
Responser.Redirect("~/PaginaError.aspx")
Finally
Conn.Close
End Try
Saludos..... y verifica que el SQL acepte conexiones remotas por las dudas tambien ok.