The issue is caused by missing registry key: HKEY_LOCAL_MACHINE SOFTWARE Microsoft Microsoft SQL Server InstanceName Providers OraOLEDB.Oracle I have manually added this key to the registry.

Best free cad software. I’ve seen this one a few times lately. In SQL Server there is a linked server to Access Excel etc.

Most of the times it works well, however, every now and then we get this: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server ' returned message 'Cannot start your application. The workgroup information file is missing or opened exclusively by another user.' Msg 7399, Level 16, State 1, Line 1 The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server ' reported an error.

Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server '. The most common reason I have seen for this is that the account executing the query against the linked server is not a Windows Authenticated account, instead it is a SQL Server Authenticated account. What I understand is happening is that some invalid login or security tokens are passed down to the file. This works well when the account is a Windows account, but when a SQL Server account is used, the token is not valid and the error shows. For example, create an Excel file called “MyLinkedXls.xls” in “C: Temp”. Start SSMS and login using a SQL Server authenticated account. Sims 3 sites.

Then create a linked server to the Excel file, like so: exec sp_addlinkedserver @server = N 'OurLinkedServer', @srvproduct =N 'Excel', @provider =N 'Microsoft.Jet.OLEDB.4.0', @datasrc =N 'C: Temp MyLinkedXls.xls', @provstr =N 'Excel 8.0;IMEX=1' And try to test it: exec sp_testlinkedserver OurLinkedServer -- Or select from it select top 1 * from OurLinkedServer.Sheet1$ This should give: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server ' returned message 'Cannot start your application. The workgroup information file is missing or opened exclusively by another user.' Msg 7399, Level 16, State 1, Line 1 The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server ' reported an error.

Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server '.

Now, logout from the server and login using a Windows authenticated account. This can be done by simply right clicking somewhere in the query window in SSMS and select Connection -> Change Connection. Rerun the query or sp_testlinkedserver procedure, this should work.