Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR: Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\USER, system error: ConnGetProxyPassword). The step failed. EXPLANATION: I encountered this error …
Read More »Cannot insert the value NULL into column ‘permission path’, table ‘@temp’; column does not allow nulls
ERROR: Msg 515, Level 16, State 2, Procedure sp_validate_user, Line 19 Cannot insert the value NULL into column ‘permission path’, table ‘@temp’; column does …
Read More »User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’ on SQL Server
ERROR: User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’ on SQL Server EXPLANATION: You may experience this error if you try to debug a …
Read More »An invalid schema or catalog was specified for the provider “SQLNCLI” for linked server “server name”
ERROR: An invalid schema or catalog was specified for the provider “SQLNCLI” for linked server “server name” EXPLANATION: Suppose you have a linked server …
Read More »Rman ORA-27086 unable to lock file – already in use
When you try to get a backup with Rman, if you get errors like ORA-27086, ORA-01580, the first place you should check is nfs …
Read More »FileGroup Backup and FileGroup Restore Operations On SQL Server(Partial Backup-Restore)
We perform FileGroup Backup and Restore operations in databases that are usually large and have more than one filegroup, while some of the filegroups are …
Read More »Invalid attempt to GetBytes on column
ERROR: An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column ‘xxx’. The GetBytes function can only be used …
Read More »An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.
ERROR: “An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.” EXPLANATION: I received this error message when …
Read More »Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
ERROR: “Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: xxx.35.1.26] Error: 18452, Severity: 14, State: …
Read More »The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service
ERROR: The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. …
Read More »