SQL Connectivity troubleshooting checklist

Hello all, During daily operations with SQL Instances, DBA/Application teams frequently encounter SQL Connectivity issues while connecting from the applications. In this  blog, I am covering few checklist steps to troubleshoot SQL Connectivity issues. When a client connects to SQL Server, it goes through authentication and authorization stages. If the connectivity issue is because of…

3

Database Mirroring Configuration Failure scenarios

Hello all, In this blog, I am covering few scenario’s that I have encountered while configuring Database mirroring as a high availability solution for SQL Server database. For demonstration purpose, I am using SQL 2012 instances on Windows 2012 R2 server. Principal Server: SQLServer\SQL2012Mirror Server: SQLServerDR\SQL2012Witness Server: Witness\WitnessMirrored Database: DBMirrorMirroring Port : 5022Service Account: SQLServiceAccount@contoso.lab…

5

Tips and Tricks to fix SQL Connectivity Issues

Hello all, Have you had any issues connecting to the SQL instance from an application or remote machine? Well, don’t worry because in this blog, I have: Explained a few common scenarios; Approached these connectivity issues; and Included fixes for these issues. To illustrate the SQL connectivity issues, I have installed SQL 2012 named instance…

14