How To Quickly Test A Remote MS-SQL Database Connection With PowerShell
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.