Sql Connection Tester Utility
I found myself needing to test for the ability to connect to a given Sql Server from a workstation today, without access to Enterprise Manager. Instead of simply installing it (or, come to think of it, simply attempting to connect through Visual Studio - ha! that would be too smart), I whipped up this handy .NET command line utility that will test for connectivity to a Sql Server. It’s written in C# and targets the .NET 1.1 runtime.
It’s quite simple to use - fire it up, and follow the instructions. Granted, in an environment where you have all the usual tools it’s completely useless, but you may occasionally find yourself with nothing but Notepad and an internet connection…and then you’ll thank me.
Download the bits:
TODO:
- Allow the user to choose the type of connection (Sql Server, ODBC, etc)
- Build a GUI (If more than 2 people use it. That means you.)
Brett wrote:
Hey, Thanks for the great tool. I was having issues connecting to my SQL server and this helped pin point the problem.
Posted on 16-Jan-06 at 1:43 am | Permalink
jason wrote:
You’re welcome. Glad it was useful to someone (other than myself!).
Posted on 16-Jan-06 at 10:07 am | Permalink
jim wrote:
wow this is great. looked for something like this (VBS script) for 2 hours.
Thanks
jw
Posted on 18-Oct-06 at 1:47 pm | Permalink
Marcus wrote:
Hey, after I download it, I cannot unzip it due to an error.
But thank’s anyways.
Posted on 09-Apr-09 at 2:10 pm | Permalink
madhu kumar wrote:
Hi i have a doubt, if the connection is proper and i am able to access SQL database from my client machine but some time the connection drops from SQL database, is there a way how to check this connection drops
Posted on 22-May-10 at 11:54 am | Permalink