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.
Question, has anyone heard of firewall rules changing after virtualization? Thanks a ton.
VirtualizationWindows Server 2012SQL
Last Comment
Dan
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
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
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
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 ;)
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
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
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
Thanks for the clarification.
And yes, unusual that p2v process turned the firewall back on ...
Regards
David
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.
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.