March 8, 2010 at 1:58 pm
Im trying to use my WMI Data Reader Task to execute WMI Query on a remote server.
In the WMI Connection Manager Edirtor > server name . I have tried using both server name and ip address but I get the following message
Failed to connect to the specified server with the following error: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))". The server name may be invalid.
I have created a local user on the server that belongs to the admin group.And am using that specific user name and password to connect.
Kindly advice me if there is any other kind of security settings that I am missing.
March 9, 2010 at 8:40 am
Do we need to have sys admin rights and be part of the administrator group on all machines that need to be queried by WMI ?
I have been googling but cant find any information
March 9, 2010 at 9:59 am
I think your domain user needs to be either in the local administrators group or in the domain admins group. Most remote WMI queries require a fairly high level of rights (for good reason).
You might take a look at:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/67428/
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply