Tag: SQL Server Errors

SQL Server Error Msg 19153 – An error occurred while obtaining the Accepted SPNs list for Extended Protection. Check Network Configuration settings in SQL Server Configuration Manager.

SQL Server Error Msg 7642 – A full-text catalog named ‘%ls’ already exists in this database. Use a different name.

SQL Server Error Msg 21370 – The resync date specified ‘%s’ is not a valid date.

SQL Server Error Msg 9828 – The second and third arguments of the TRANSLATE built-in function must contain an equal number of characters.

SQL Server Error Msg 5228 – Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d. DBCC detected incomplete cleanup from an online index build operation. (The anti-matter column value is %d.)

SQL Server Error Msg 35278 – Availability database ‘%.*ls’, which is in the secondary role, is being restarted to resynchronize with the current primary database. This is an informational message only. No user action is required.

SQL Server Error Msg 17899 – Login timer expired for the client connection.

SQL Server Error Msg 41163 – An error occurred while waiting for the local availability replica of availability group ‘%.*ls’ to transition to the primary role.  The operation encountered SQL OS error %d and has been terminated.  Verify that the availability group is in the correct state for the command.  If this is a Windows Server Failover Clustering (WSFC) availability group, also verify that the WSFC cluster is in the correct state for the command.  Then retry the command.

SQL Server Error Msg 3201 – Cannot open backup device ‘%ls’. Operating system error %ls.

SQL Server Error Msg 1854 – The original file name ‘%.*ls’ for logical database file ‘%.*ls’ is too long to be combined with the full path to the new primary data file location.

SQL Server Error Msg 3417 – Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

SQL Server Error Msg 18276 – Database file differential changes were backed up. Database: %s, creation date(time): %s(%s), file list: (%s), pages dumped: %I64d, number of dump devices: %d, device information: (%s). This is an informational message only. No user action is required.

SQL Server Error Msg 10799 – This is not a valid data compression setting for a columnstore index. Please choose COLUMNSTORE or COLUMNSTORE_ARCHIVE compression.

SQL Server Error Msg 33180 – Searching for “‘%.*ls’” only searches for Azure Active Directory users. To search for a SQL Server authentication login, add the server name at the end. For example [%.*ls@%.*ls].

SQL Server Error Msg 40814 – Could not change database edition to or from Premium for a Federation root.

SQL Server Error Msg 1807 – Could not obtain exclusive lock on database ‘%.*ls’. Retry the operation later.

SQL Server Error Msg 9419 – XML parsing: line %d, character %d, ‘(‘ expected

SQL Server Error Msg 28078 – The RC4 encryption algorithm is not supported when running in FIPS compliance mode.

SQL Server Error Msg 30020 – The full-text query parameter for %S_MSG is not valid.

SQL Server Error Msg 40106 – The schema scope set in the session is not the current schema scope for the current partition. Please rerun your query.