SQL Server Errors or Failures from Error: 7403 to Error: 7425

 

Error: 7403, Severity: 16, The OLE DB provider “%ls” has not been registered.
Error: 7404, Severity: 16, The server could not load DCOM.
Error: 7405, Severity: 16, Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
Error: 7409, Severity: 16, Could not start distributed query using integrated login because the user is logged in using SQL Server authentication. Provide remote server login user ID and password in the connection string.

Error: 7410, Severity: 16, Remote access is not allowed for impersonated security context.
Error: 7411, Severity: 16, Server ‘%.*ls’ is not configured for %ls.
Error: 7412, Severity: 16, OLE DB provider “%ls” for linked server “%ls” returned message “%ls”.
Error: 7413, Severity: 16, Could not connect to linked server ‘%ls’ (OLE DB Provider ‘%ls’). Enable delegation or use a remote SQL Server login for the current user.
Error: 7414, Severity: 16, Invalid number of parameters. Rowset ‘%ls’ expects %d parameter(s).

Error: 7415, Severity: 16, Ad hoc access to OLE DB provider ‘%ls’ has been denied. You must access this provider through a linked server.
Error: 7416, Severity: 16, Access to the remote server is denied because no login-mapping exists.
Error: 7417, Severity: 16, GROUP BY ALL is not supported in queries that access remote tables if there is also a WHERE clause in the query.
Error: 7418, Severity: 16, Text, image, or ntext column was too large to send to the remote data source due to the storage interface used by the provider.
Error: 7419, Severity: 16, Lazy schema validation error. Linked server schema version has changed. Re-run the query.
Error: 7420, Severity: 16, Remote access is not supported for transaction isolation level “%ls”.
Error: 7421, Severity: 10, Cannot fetch the rowset from OLE DB provider “%ls” for linked server “%ls”. %ls.
Error: 7422, Severity: 16, OLE DB provider “%ls” for linked server “%ls” returned an invalid index definition for table “%ls”.
Error: 7423, Severity: 16, The ‘%ls’ OLE DB provider for the ‘%ls’ linked server returned an invalid CLR type definition for the ‘%ls’ table.
Error: 7424, Severity: 10, OLE DB provider “%ls” for linked server “%ls” returned “%ls” with data type “%ls”, which should be type “%ls”.
Error: 7425, Severity: 10, OLE DB provider “%ls” for linked server “%ls” returned an incorrect value for “%ls”, which should be “%ls”.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.