Is SQL Server available

Question

I'm using VB.NET to create a simple application which will test if a variety of SQL Server are available online.

I have the code below, but the timeout is not working and it simply waits forever rather than throwing a timeout error. I have put breakpoints in and, as this is in an loop of IP's, it never progresses if the IP being checked is unavailable.

 Dim data As New SqlClient.SqlConnection("Data Source=DatabaseIP;Initial Catalog=POS;Integrated Security=False;User ID=sa;Password=;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False".Replace("DatabaseIP", IP))

Try
    data.Open()
Catch ex As Exception
    Dim stophere As String = ""
    TextBox1.Text += IP + vbNewLine
End Try

Possible duplicate of [How to make SqlConnection timeout more quickly](http://stackoverflow.com/questions/3619347/how-to-make-sqlconnection-timeout-more-quickly) — Heinzi, Dec 08 '16 at 14:15
Not a duplicate. My issue is that the timeout is NOT occurring., rather than how to make it quicker. — Lord Nodral III, Dec 08 '16 at 14:48

score 0 · Answer 1 · answered Dec 08 '16 at 11:02

0

Connect Timeout=15 is not correct, try it with Connection Timeout=15

answered Dec 08 '16 at 11:02

David Sdot

2,343
1
20
26

I've made this change and it has produced no effect on the outcome – Lord Nodral III Dec 08 '16 at 11:09
after crating your sqlconnection check that the timeout is set correctly ex: Debug.WriteLine("ConnectionTimeout: {0}", data.ConnectionTimeout) – David Sdot Dec 08 '16 at 11:32
Yes. This shows as 15. There is all probability that the IP / Database may not be reachable. I'm unsire if this makes any difference/ – Lord Nodral III Dec 08 '16 at 13:31

score 0 · Answer 2 · answered Dec 08 '16 at 14:07

0

To connect with Database, following code is enough,

Dim data As New SqlClient.SqlConnection("Data Source=DatabaseIP;Initial Catalog=POS;Integrated Security=False;User ID=sa;Password=;")

answered Dec 08 '16 at 14:07

K.Suthagar

2,226
1
16
28

And this will use the default timeout settings, which is NOT actually happening. My question is as to WHY the timeout is not working, and how to get the connection request to timeout and indicate that the DB is not accessible. – Lord Nodral III Dec 08 '16 at 14:50

Is SQL Server available

2 Answers2