Link to home
Create AccountLog in
Avatar of Dan
DanFlag for United States of America

asked on

SQL clients can't connect after virtualization of a Server.

After Visualizing a  2012 R2 server the MSSQL 2008 could not be connected to.  The program is called Office Mate.  Their tech support logged in and found if I turn the firewall off it worked fine.  I haden't made any changes to the system before it failed, and the old system had the firewall on.

Question, has anyone heard of firewall rules changing after virtualization?  Thanks a ton.
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Has the machine got the same IP as the physical had or does it have a new one?
Worth checking the firewall logs to confirm what is being dropped. Alternatively, you may have a firewall rule tied to a specific NIC or MAC address, which would have been replaced by a virtual NIC and potentially a new MAC address.
ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Dan

ASKER

Steve, yes, same IP, I needed to keep it that way.  It does have a new nic, a virtual nic, i'm assuming a new mac.

Shaun, thanks, is that a power shell script?  I'll try it Wed when i go back.
Powershell that detects SQL instances and adds it automatically
Avatar of Dan

ASKER

ok coolio, can't wait to try it, did you write it?
Hi Dan,

My question is which firewall did the techs touch? Host or guest? I could well imagine that the host had a firewall that needed tweaking after the guest was added.

Regards
  David
ok coolio, can't wait to try it, did you write it?
Yes ;)
Avatar of Dan

ASKER

David, it's the Windows Firewall for Windows Server 2012 R2, It was on before, but now it seemed to block the clients, thats the one they turned off.
Hi Dan,

What is hosting your VM? If the VM is Windows 2012R2 and the host is Windows 2012R2, aren't there TWO windows firewalls in operation - one on the guest (your VM) and one on the host.

HTH
  David
Avatar of Dan

ASKER

Oh sorry, the hoster is an ESXi 6.0 system, there is just one VM, that 2012 Server.  It went from a physical power edge to this one.
Hi Dan,

Thanks for the clarification.

And yes, unusual that p2v process turned the firewall back on ...

Regards
  David
Avatar of Dan

ASKER

Thaks all that script worked, I checked the old server had it's firewall on, not sure what happened, but I'm going to keep Shaun's script around.