<div>
Take a look<a href="http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/83300532-e780-4ac6-9a64-7246e58c253a" rel="ugc nofollow"> here</a>. &nbsp;Possibly one of these suggestions will work for you.<br />
<br />

</div>


Take a look here [http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/83300532-e780-4ac6-9a64-7246e58c253a].  Possibly one of these suggestions will work for you.



<div>
None of these seemed to work. &nbsp;Would it make a difference that we jsut upgraded our servers to a 64 bit operating system?
</div>


None of these seemed to work.  Would it make a difference that we jsut upgraded our servers to a 64 bit operating system?

<div>
<div class="content wysiwyg-content">
I am using a linked server in SQL Server to query an Excel database. &nbsp;I receive the following error message that I cannot figure out.<br />
<br />
The OLE DB provider &quot;Microsoft.Jet.OLEDB.4.0&quot; for linked server &quot;LINKEDSERVER1&quot; reported an error. Authentication failed.<br />
Cannot initialize the data source object of OLE DB provider &quot;Microsoft.Jet.OLEDB.4.0&quot; for linked server &quot;LINKEDSERVER1&quot;. <br />

</div>
</div>


I am using a linked server in SQL Server to query an Excel database.  I receive the following error message that I cannot figure out.

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LINKEDSERVER1" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LINKEDSERVER1". 


SQL Server using Linked server error

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications