Troubleshooting

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

How to Enable, Disable or Check SQL Server Trace Flags?

Trace flags are used to gather in-depth information about certain logs during some transactions. We use DBCC commands to enable…

Fix Error 1418: The server network address cannot be reached or does not exist.

We got error 1418 while configuring Database Mirroring on one of the SQL Server database instance. The error details are…

Fix Error 1101: Could not allocate a new page for database

We get error 1101 because of space issues. Database engine doesn’t able to allocate new pages to the database because…

SQL Server Evaluation Period has Expired and How to Upgrade it?

Generally, we download SQL Server evaluation edition to learn or do some testing before deployments. Evaluation edition of SQL Server…

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…