OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
This problem also occurs with any linked server query that uses the Jet provider, such as the OPENQUERY function or the Transact-SQL query with four-part names.
- Configure the TEMP and TMP system environment variables to point to a folder (for instance, C:\TEMP).
- Set the permissions to the SQL Server service account on this folder as Full Control.
- Restart the server.
Note In addition to granting full control to the SQL Server service account, any user that connects to the computer that is running SQL Server by using Windows Authentication must also be granted full control to the same TEMP and TMP directories that the SQL Server service account uses. Before you instantiate the OLEDB provider, SQL Server impersonates the account that is connecting to the computer that is running SQL Server if it is using a trusted connection.
- If there is not a TEMP or TMP system environment variable, set the permissions to the SQL Server service account on the %WINDIR% folder as Full Control -or-
- Make the SQL Server service account a member of a group that has such permissions on the %WINDIR% folder.
Article ID: 296711 - Last Review: Jul 10, 2008 - Revision: 1