.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

The provider reported an unexpected catastrophic failure

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server

For a very long time we extract data from a linked server without any issues.  We use a scheduled DTS package to call a stored procedure which in turn is doing a bulk copy from the linked server.  The linked server 'AAA' is MSSQL 2005 SP2 and the server which is doing the  extraction is SQL2000 SP unknown at this stage.  For a while now we get the following error:

"The OLE DB provider "AAA" for linked server "AAA" reported an error. The provider reported an unexpected catastrophic failure.      Error source:  Microsoft OLE DB Provider for SQL Server " Later on the error may turn into the follwoing:

"Error string:  [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.      Error source:  Microsoft OLE DB Provider for SQL Server "

We did not changed network security, nor usernames or whatever.  It just stared to happen.  Together we may get a "locked" error message.  We do run Redgate to try and trace this error to no avail.  The only way to resolves this error is to restart both servers.

Any help would be appreciated - this is getting too much now.





View Complete Post

More Related Resource Links

sporadic error "The provider reported an unexpected catastrophic failure"


Hello Experts,

ín my case I have a linked server based on provider "OraOLEDB.Oracle".
To import data using this linked server working well but sometime the import step failed with the error message "The provider reported an unexpected catastrophic failure". I checked the log files and found the known message "c0000005 EXCEPTION_ACCESS_VIOLATION".

I use:
Windows Server 2008 SP2
SQL Server 2008 SP1
Oracle 11g

After browsing this forum and web using the messages above I only found the solution to connect microsoft.

Are there any other solutions?


The provider reported an unexpected catestrophic failure using BETA MICROSOFT.ACE.OLEDB.14.0 drivers

I'm just in the process of converting my app to be able to support text importing via "OPENROWSET" in 64 bit SQL Server using the Beta MICROSOFT.ACE.OLEDB.14.0 drivers.  I've previously used the MICROSOFT.ACE.OLEDB.12.0 drivers but of course these only work on 32 bit instances of SQL Server.  I've found that after I've installed the beta that the connections wont work if I use MICROSOFT.ACE.OLEDB.14.0 as the provider.  However if I use MICROSOFT.ACE.OLEDB.12.0 it works... sort of... I can import data a few times then I get a "The provider reported an unexpected catestrophic failure" error and the app hangs.My environment is 64-bit Windows 7 running VM Workstation, with a 64-bit Windows 7 guest running SQL Server 2008 64 Bit.  Essentially I'm running the following which works... occasionally getting the failure above select top 50 * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=c:\temp\captell;HDR=Yes', 'SELECT * FROM [DASDGIGS0013046591395.TXT]')and select top 50 * FROM OPENROWSET('Microsoft.ACE.OLEDB.14.0','Text;Database=c:\temp\captell;HDR=Yes', 'SELECT * FROM [DASDGIGS0013046591395.TXT]')Which doesn't work, returning the "OLEDB provider ... has not been registered" message.So I'm thinking that the drivers are 64-bit drivers but the registration process during installation is using

How to resolve Shared Services Provider creation failure?

I would like to ask for support regarding this problem: SSP provisioning will be retried periodically. If you correct the error that caused this failure, provisioning will subsequently succeed. To stop provisioning from being retired, delete the SSP. I'm creating a New SSP & everytime I create, I received that message. I tried to reset the IIS already, restart the machine, but still I received that error after I create a new SSP. Wait for soonest advise!

Getting "Provider load failure" from SSRS Configuration Manager (SQL 2008 R2 Hot Fix CU3 did not fix

After upgrading our SQL 2008 cluster to R2, SSRS on one node works fine, but the second node will not allow connection via the Configuration Manager (getting "Provider load failure").  We've done re-installs, repairs and applied Hot Fix CU3, but the issue remains. NOTE: It's understood that SSRS is not a clustered resource.  We have it installed as separate instances on each of the two cluster nodes.

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access

Hi,I am importing Excel 2007 file into SqlServer 2005 (Sqlexpress). The office 2007 is not installed in the machine. I have downloaded and installed "AccessDatabaseEngine". When I execute following statement SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\File1.xlsx', 'SELECT * FROM [Sheet1$]');The following error is comming:Msg 7399, Level 16, State 1, Line 1The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.Msg 7350, Level 16, State 2, Line 1Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".Can any one suggest what should I do to resolve?Thanks,Parmeshthee. Learning .Net 3.5

The OLE DB provider ....reported an error. Access denied.

I'm trying to export excel data to a SQL Server database as:SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:\DATA_SOURCE\Data2.xlsx', 'SELECT * FROM [Sheet1$');I get errors:Error Message: The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.Is there any reason for this error message? Thanks.

Catastrophic failure Error - Correlation ID not found in ULS logs


Hi all

I'm having a problem in sharepoint when trying to create a new site from a custom template - I am getting the below error:

Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))


Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: [long hex code]


However when I look in the ULS logs there is no mention of this correlation ID. I have turned the logs up to Verbose on everything, then reproduced the error, and still I can't find the error. Is it possible that this error is coming from another subsystem like ASP or IIS? I have looked in the IIS logs and can find the HTTP requests but nothing to do with why the error occurs.

Any help would be appreciated - I feel like if I could find the correlation ID I could at least start to work out what the error is!

Many thanks


Error occurred in deployment step 'Recycle IIS Application Pool': Provider load failure



I am using Visual Studio 2010 to create page layouts and preview images(http://blog.beckybertram.com/Lists/Posts/Post.aspx?ID=71). I was successful in creating page layouts but the image was not coming properly.

So I decided to change the path of image and deploy the project (Empty SharePoint project). But this time, I am getting an error
Error occurred in deployment step 'Recycle IIS Application Pool': Provider load failure
I am sure there is no relation between changing image path in elements.xml and this error.

I also browsed through and found some related issues, but they are not specific to VS 2010 or SharePoint 2010. And I am apprehensive of implementing them.

1. The logged in user is site collection admin and local admin
2. Windows Management Instrumentation service is running
3. App pool's identity is configured to the local admin & password has not changed.

Thanks in advance

Vighnesh Bendre


Catastrophic failure while opening DIP form in Infopath



while opening my content type's DIP in infopath, it shows 'Catastrophic failure'.

while searching, i have found the reason for this,

While doing this so, you may be facing an ugly error Catastrophic failure error. Dont worry about this error... this is because of the columns in your content type. While creating a column in content type, that column should not contain any space(s). For example, you created a content type named "Test Document" and the site column you use is "Test Column". Then this content type will face the catastrophic failure error.

the columns are already being used.please guide me to solve this issue.

Thanks in advance.

,NET Framework 4 has not been instaled because: Catastrophic failure


I can `t install .NET Framework 4

.NET Framework 4 has not been instaled because: Catastrophic failure

Can you hetlp me?

,NET Framework 4 has not been instaled because: Catastrophic failure


I can `t install .NET Framework 4

.NET Framework 4 has not been instaled because: Catastrophic failure

Can you hetlp me?

Unexpected failure during the setup of SQL Server 2005 Standard Edition


Dear All

When I was installing the SQL Server 2005 Standard Edition on Windows Server 2003, the following problem occured.

How can I solve it?

Thank you so much!


TITLE: Microsoft SQL Server 2005 Setup

There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643



List Item Update Exception from HRESULT: 0x80040E2F Unexpected query execution failure, error code 3


A thread somewhat simliar to this has been posted before as well, but i just wanted to detail out the issue and circumstances

We have a list with 53 columns and 2600 items(and growing. I know its rubbish, but thats the way it is at the moment). The list was created using SharePoint GUI  on a test server, saved as a template with data, and was then imported to the production environment. I can post the list columns and type if it helps.

Every one in a while, on updating an item, SharePoint throws up the very not so helpful error page with "Exception from HRESULT: 0x80040E2F".

We looked into the logs and found that for each suc error, there was a Database level error logged as well.

The error starts with Unexpected query execution failure, error code 3621. Additional error information from SQL Server is included below. "The statement has been terminated." Query text (if available): "BEGIN TRAN;DECLARE... and runs for many lines so i wont post the entire blurb here.

Each time, the item update is successful, despite this error. The list also has an Item Updated event handler attached to it. Every time the update error occurs, the event handler does not seem to be firing.

Anybody can shed light on what is happening. We have tried exporting the list template to another site and everything seemed to work

"Catastrophic failure" when accessing an OCX library from C#



I'm currently trying to use a third-party DLL from my C# application. I've registered the DLL and added it as a reference from the list of COM component. As I understand, this should create the necessary interop classes to access this DLL from C#.

On attempting to call any methods from within the DLL I get the following exception:-



System.Runtime.InteropServices.COMException was unhandled
 Message=Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
  at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
  at OCXDLL._OCXDLL.MyMethod(Int32 param0, String param1, String param2, String param3, Int32 param4)
  at MyApplication.Program.Main(String[] args) in C:\MyApplication\Program.cs:line 29
  at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
  at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
  at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
  at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
  at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
  at Syst

Building a LINQ Provider

Throughout this article, we will build a simple IQueryable provider similar to the LINQ to SQL provider demonstrating what is needed to build a custom provider that is capable of executing LINQ queries and performing create, update and delete operations.

Tab container rendered with visibility:hidden - This was reported over three years ago.



Here is (more) code that demonstrates the issue.  If the control in the host page is removed the tab control renders correctly.  Otherwise it is rendered with the visibility attrubute set to hidden as reported in the above link.  Is this broken or am I doing something wrong?



<%@ Page Language="C#" AutoEventWireup="true" CodeFile="S2.aspx.cs" Inherits="S2" %>
<%@ Register Src="~/SelectorPatternControl.ascx" TagName="TestControl" TagPrefix="sam" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <form id="form1" runat="server">
        <cc1:ToolkitScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true"></cc1:ToolkitScriptManager>

Membership Provider Conn String


Hello. I've bee successfully using the Asp.Net Membership Provider in my VB.Net 3.5/SQL 2005 web app for a year now (Site A). However, I've added 2 new sites (B and C) (both with their own DB) and now I see a problem. It looks like users that get created for sites B and C also get created in site A. Roles that I create for B and C only get created in A. I think it is a conn string problem.

When I created A, I adde the conn string to my machine.config (not sure why I did this or if it is even needed)...


         <add name="LocalSqlServer" connectionString="Data Source=VS689\SQLEXPRESS;Initial Catalog=SiteA;USER ID=sa;PASSWORD=123456"/>


                <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=blahblah" connectionStringName="LocalSqlS

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend