Category: SQL Server

SQL Server Error Code – 979 the target database (?%.*ls?) is in an a

In this blog post, you’ll learn more about the SQL Server Error Code 979 and the error message description that is shown SQL Server Error Code 979 SQL Server Error Description for the Code :979 The target database (?%.*ls?) is in an availability group and currently does not allow read only connections. For more information about application intent, see SQL Server Books Online.

SQL Server Error Code – 18059 the connection has been dropped because

In this blog post, you’ll learn more about the SQL Server Error Code 18059 and the error message description that is shown SQL Server Error Code 18059 SQL Server Error Description for the Code :18059 The connection has been dropped because the principal that opened it subsequently assumed a new security context, and then tried to reset the connection under its impersonated security context. This…

SQL Server Error Code – 8935 table error: object id %d, index id %d,

In this blog post, you’ll learn more about the SQL Server Error Code 8935 and the error message description that is shown SQL Server Error Code 8935 SQL Server Error Description for the Code :8935 Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). The previous link %S_PGID on page %S_PGID does not match the previous page…

SQL Server Error Code – 33102 cannot encrypt a system database. databa

In this blog post, you’ll learn more about the SQL Server Error Code 33102 and the error message description that is shown SQL Server Error Code 33102 SQL Server Error Description for the Code :33102 Cannot encrypt a system database. Database encryption operations cannot be performed for ‘master’, ‘model’, ‘tempdb’, ‘msdb’, or ‘resource’ databases.

SQL Server Error Code – 41136 failed to join the availability replica

In this blog post, you’ll learn more about the SQL Server Error Code 41136 and the error message description that is shown SQL Server Error Code 41136 SQL Server Error Description for the Code :41136 Failed to join the availability replica to availability group ‘%.*ls’ because the group is not online.  Either bring the availability group online, or drop and recreate it. Then retry the…