I am trying to get this to work for a non sa/sysadmin user.
I have already added the registry item...
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Providers\Microsoft.Jet.OLEDB.4.0]
"AllowInProcess"=dword:00000001
"DisallowAdhocAccess"=dword:00000000
And added the user to the master DB and explocitly granted rights to the "xp_prop_oledb_provider" with execute only.
But I am still getting the following error...
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
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 "(null)".
Any Ideas?
It works if they are sa but that's not going to be an option.