Troubleshooting

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…

Fix SQL Server Error 802: There is insufficient memory available in the buffer pool.

We receive SQL Server error 802 when buffer pool of SQL Server instance is full and cannot grow further. Here,…

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 Native Client Error 50000: A network error occurred while attempting to read from the file

Yesterday i have received SQL Server Native Client Error 5000 while installing SQL Server Management Studio on one of the…

SQL Server Error 5009: One or more files listed in the statement could not be found or could not be initialized

I had to add a log file to a database and then extend the size of this log file to…

Top Perfmon Counters to Identify SQL Server CPU Bottleneck

We should always monitor system resource utilization of our database servers and make sure that these utilizations should not exceed…

Top 10 Performance Counters to Identify SQL Server Memory Pressure

Memory is one of the important system resource that SQL Server uses to process their transactions. Sometimes, your server might…

SQL Server Error 701: There is Insufficient System Memory to Run this Query

Today I am going to discuss SQL Server memory issues that your database Instance might face during bulk data load…

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.…

How to Configure Reporting Services after Renaming SQL Server Instance

Sometimes we need to change the name of the server or computer on which SQL Server instance is running. Once…

Fix Error 15190: There are still remote logins for the server ‘DBSERVER’.

I got this error 15190 while renaming SQL Server Instance name. I was not able to drop the existing SQL…

Fix Error 1105: Could not allocate space for object in database because the filegroup is full.

Today, I got error 1105 on one of the database server. We were processing some bulk transactions on a database…

Fix Error 15123: The configuration option does not exist.

Yesterday, one of my teammate was facing an issue while enabling a server level parameter using T-SQL command sp_configure. He was trying…

Fix Error 18452: Login failed. The login is from an untrusted domain

Recently a user has reported error 18452 while connecting to database server. Full description of this error is given below:…