Test Database Connectivity

Powershell Test Database Connectivity, if you are looking for how quickly one can test the database status using Powershell script then you are at the right place, here are the simple steps. There are many situation database administrators who have to test the database connection or database availability. When there is an update, removal, or addition to database records we need to test after the modification. Here is the simple Powershell script that tests whether a database instance accepts the connection or not, I mean a connection to an SQL Server instance can be established or not.

#Database Instance connectivity test
$dbhostname = 'yourservername'
$dbinstance = 'DBInstance'
$dbname = 'yourDBname'

$username = "DB user name"
$password = "DB user password"

$cs = "Server=$dbhost\$dbinst;Database=$dbname;User Id=$username;" +
      "Password=$password;"

$test = New-Object -COM 'ADODB.Connection'
$test.ConnectionString = $cs
try {
  $test.Open()
  if ($test.State -eq 1) {
    'connected'
    $test.Close()
  } else {
    'not connected'
  }
} catch {
  'not connected'
}

In the above script, you just need to provide the database name, Database hostname, DB username and password, make sure you have all the privileges to test the DB connection. This script is really helpful when you have more number of servers and databases, it is really important to validate the database connection and connectivity after any change to make sure DB functionality is available. Thank you for reading this article, if you have any questions please let us know. Thank you for visiting my site, for any scripts in these articles you are testing please make sure you have tested this script in our lower environment before you run in production.

Top 5 Notepad++ Tricks that you should know in 2020

Best Minecraft mods in 2021

Windows Minecraft

Pokemon Sword and Shield: Post Game 2021

5 Best Free Youtube Video to MP3 Converters in 2021

Best beat making softwares List

DaVinci Resolve Plugins you Should have in 2021