SQL Server Connectivity Issue

Fix SQL Error 18456: failed to open the explicitly specified database

This article will help you fixing SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly…

Fix SQL Server Error 121 – The Semaphore Timeout Period Has Expired

Yesterday one of my teammate got a weird error while executing a T-SQL script. We are talking about SQL Server…

How to Change Authentication Mode in SQL Server?

Authentication is a process to establish a successful connection. SQL Server provides two types of authentication modes to connect to…

Fix:VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’

Yesterday, one of the app user was complaining that he is not able to execute some of the queries and…

SQL Server Error 5184: Cannot use file ‘I:\Path\Techyaz.mdf’ for clustered server

Today, one of my team mate was trying to attach a database on one of the clustered SQL Server instance.…

How to Change SQL Server Instance Name?

Changing SQL Server Instance name is not a routine task. Although, sometimes we get requirements to change SQL Instance name.…

Fix SQL Server Error 233: No process is on the other end of the pipe

Today, I got SQL Server error 233 no process is on the other end of the pipe while connecting to…

Fix SQL Server Error 53: Could not open a connection on SQL Server

Today, I will explain how to fix SQL Server error 53 (The network path was not found). The details about…

SQL Server Error 40: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Today, a user has raised a request to fix an error (Microsoft SQL Server Error 40 - Could not open a connection…

Fix SQL Server Error 18456: Login failed for user ‘User_Name’.

Yesterday, a developer has reported an SQL Server error 18456 Login failed for user ‘username’. (Microsoft SQL Server, Error: 18456)…

Fix: SQL Network Interfaces Error 28 – Server doesn’t support requested protocol

Today I am going to discuss about Microsoft SQL Server Error 28 that most of the SQL Server users might…