Post reply

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0"

  • September 10, 2009 at 2:14 pm

    #141516

    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

    #1052010

    Can this be wrapped in proc and use execute as?

    Andrew

  • September 10, 2009 at 5:20 pm

    #1052034

    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