Configuring SQL Server Email Notifications for Job Status Alerts

Email Notifications can be configured for SQL Server Jobs for Complete (Success or Failure), Success and Failure states. Step 1: Configuring Outgoing Email Account 1. Navigate to SSMS > Object Explorer > Connect to Database Engine > Root Node (server) > Management > Database Mail. First time, it may prompt as “Database Mail is not enabled, would you like to enable?” Accept…

SQL Server 2008 R2 Remote Connection

Below are the steps to enable Remote Connection on SQL Server 2008 R2. (I am referring to the UI of Microsoft SQL Server Management Studio) 1. In Server Properties > Security, set the Server Authentication to “SQL Server and Windows Authentication Mode”  2. In Server Properties > Connections, check the checkbox “Allow remote connections to…