Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2010-03-08 : 16:38:51
|
| 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. |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-03-09 : 10:41:28
|
| 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 |
 |
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2010-06-10 : 01:03:08
|
| You probably need credentials. I'll write more later if you reply.~ Shaun MerrillSeattle area |
|
|
|
|
|
|
WMI Data Reader Task