Error Messages

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…

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 following error message when trying to list my database’s tables? “The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.” Here’s the screenshot also: Answer: Are you ready for the simplest explanation ever? 🙂 The reason is that…

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…