I have a Broker application whose message contains a Access DB which needs to be read. We use Windows 2008 and SQL server 2008 64 bit. The new Access OLE DB library is installed. The queue has automatic activation. In the queue defination, if we use EXECUTE_AS
'a local server user' everything works fine. However, if we change this to EXECUTE_AS 'a domain user' we get the message << Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server
"(null)">> when trying to read the Access DB. Using SysInternals I can see several actions with the result 'BAD IMPERSONATION', but I'm a bit stuck on why.
If I login to the server and use SQL Managerment Studio run the run the normally automaticlly activated Stored Procedure manually. The process works.