How To Quickly Test A Remote MS-SQL Database Connection With PowerShell
If you enjoyed this video, be sure to head over to http://techsnips.io to get free access to our entire library of content!
There are a lot of times when troubleshooting, writing a custom script to deplay a new Microsoft SQL database, or simply creating a SQL Server monitor that you need to ensure your SQL database is always responding to connection attempts. Like PowerShell often does, it can make this process very easy! We'll create a simple function to test our connections in PowerShell and call it Test-SqlConnection.
In this snip, we'll cover how we can build this Test-SqlConnection function by using a few simple techniques which will allow you to quickly determine if your SQL server can be connected to remotely.
Prerequisites include:
An MS-SQL database to test.
Head over to adamtheautomator.com now for hundreds of in-depth, informative how-to articles just like this!