Bug #68193 When adding a server instance Native remote management access denied
Submitted: 27 Jan 2013 21:38 Modified: 20 Sep 2013 12:39
Reporter: Mx Dog Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.45 CE OS:Windows (win7 64 to 2008 r2 sp1 )
Assigned to: CPU Architecture:Any
Tags: access denied, remote management, windows server

[27 Jan 2013 21:38] Mx Dog
Description:
in the create new server instance profile the native windows remote management will not "logon" message "Could not set up connection:WMI query executuon failed with this error: Access is denied"
client comp is win7pro-x64 sp1 and the server comp is win2008r2 hpc x64 sp1 

WMI from the client comp works fine with mmc-services,server manager, ect. the logon is in the admin group and mysql is runing as a service

I found a few referances to this problem in the bugs but i did not find any solutions. 

some hints : if i put a bogus login name into the remote windows login screen i get a differant message " Could not set up connection" 

with a good login name and pass  i have ports 135 and 49158 open up on the server(domain rpc ports) even though the default ports for wmi listener show as 5985 80 and 443 ( 80-443 opened those for wmi experimenting) on the client side same ports open on logon 

firewalls are off on both comps for domain and local.

Thats is about as far as i can take it . I can not find any documentaion on what exact service, ports, protocols that logon is trying to use i assume it is remote mangement which should open one of ports listed with this command on the server-winrm enumerate winrm/config/listener. but i never get that far and may be barking up the wrong tree 

local connection on server works fine. one other thing if i run workbench from the 2008 machine to a mysql instance on the win7 machine it works fine remote management connects right up. (win7 is running one instance for a tv server app)

the server is the primary domain server on a small network and as far as i can tell all the services and permissions  i need for remote management are running and again it does work with  mmc snap ins . 

if i did not make it clear it is just the remote mangement that does not work if i bypass that the database hooks up 

 

  

  

How to repeat:
win7 machine to a win server 2008 r2 hpc server repeats on my machines.

Suggested fix:
Possibly better documentaion for that section of the add server dialogs ? or maybe a logging option to see what is actually going on ?
[20 Aug 2013 12:39] MySQL Verification Team
Please try version 6.0.6. Thanks.
[21 Sep 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".