First I thought our 2 DHCP servers were conflicting so I removed both from IPAM and added 1 at a time. I have tried them both but I keep getting the same error.
IPAM indicates the server is up at first but then it quickly goes down. Same with the subnets - they all look good then in less than 1 minute, all the subnets go grey.
the system error I'm getting is:
DHCP server scanning for 'DHCP Server '****DHCP'' failed with error:Cannot resolve collation conflict for equal to operation.
Is this an SQL problem?
Can anyone recommend me a course of action?
Do I need to start by looking to upgrade SQL?
Any information will be greatly appreciated.