SQL Server Troubleshooting

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

This short blog post helps you troubleshoot the below error message in SQL Server Reporting Services (SSRS): An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help For more information about this…

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

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

Under certain circumstances, there are cases where you might try to connect to a SQL Server instance and get the error message: “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is…

SQL Server 2008 R2 Service Pack Installation Fails – Element not found. (Exception from HRESULT: 0x80070490)

In case you are trying to install a SQL Server 2008 R2 service pack in a clustered SQL Server environment and the installation fails reporting something similar to the below: Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the…

The transaction log for database ‘dbname’ is full due to ‘XTP_CHECKPOINT’‏

When using In-Memory OLTP in SQL Server 2014, under certain conditions you might get the below error message: The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’‏  This was fixed in Cumulative Update 3 for SQL Server 2014 SP1 More information about the fix can be found here.

The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.

Question: What I’m I doing wrong and I’m getting the below error message when trying to list my database’s tables? Answer: Are you ready for the simplest explanation ever? 🙂 The reason is that -most probably- (hey, you never know) you are using a SQL Server login that has conflicting permissions.…

There is insufficient system memory in resource pool ‘internal’ to run this query.

There is insufficient system memory in resource pool ‘internal’ to run this query.

This article discusses how you can resolve the error message: There is insufficient system memory in resource pool ‘internal’ to run this query. Even though you might get the above error message for different occasions, one thing is for sure (after all, the message is quite self-explanatory), it has to…