How to check if the server is available!!

[Eteleeb]

Hi People,

In my application I should connect to SQL Server first. therefore, I would like to know how to check if the SQL Server is availaible or no. in other words, when I click connect to the server button, I should check if the server is available or no.
Please can someone tell me how

Thanks
Eteleeb

 

[ritesh_jain1982]

Hi,
Try to open the connection if u get any exception that means ur either ur server does not exist or u don't have permission..........

e.g

try
consql.Open
consql.Close
Catch exc as SqlException
Messagebox.show("server does not exist or u don't have permission")
End try

I hope this will help u..................

Regards,
Ritesh

 

[Eteleeb]

YUP,

I already tried that and it is ok now. Thank you very much for helping me