January 16, 2013 at 3:48 am
Hi folks
SSIS - 2008 R2 on a Windows 7 machine accessing a remote server - which I think is 2003.
I'm trying to run a WMI Data Reader Task to get sub folders from a specified directory.
This simply generates a [WMI Data Reader Task] Error: An error occurred with the following error message: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))".
I'm using a service account - svc-remoteServer. If I put in the server, account name and password into the WMI connection and test - it works fine.
If I run wbemtest.exe and connect to the remote server as the service account, and execute the query - it works fine and returns all subfolders. It just won't work when I execute the Task.
I've tried specifying the username, password and server name. I've also tried specifying the connection string - as follows
ServerName=\\remoteServer;Namespace=\root\cimv2;UseNtAuth=False;UserName=DOMAIN\svc-remoteServer;PassWord=xxxxxxxx
Any ideas?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply