September 10, 2009 at 2:14 pm
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.
September 10, 2009 at 3:33 pm
Can this be wrapped in proc and use execute as?
Andrew
September 10, 2009 at 5:20 pm
Either way it's executed, SQL will use the credentials passed through from SSMS.
I have tried what the link here: http://blogs.msdn.com/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx
suggests but still workd for sysadmins but not regular users. Might have to call M$ on this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply