I am having a problem. Our DBA is using SQL Server 2005 running an Access front end because the systems were developed in Access and migrated later to SQL Server. The SQL Server uses Windows Authentication but will fail through out the day and the user has to log out and back in (on some computers not all). Our DBA says the problem is a reverse lookup issue. On the failing computer, if you run... ping svrname
it resolves the name to an IP and pings fine. If you run...
ping -a 10.100.100.7
it does not resolve the server name but does ping. It does work on other computers just not this one.
I have never setup a reverse lookup zone in our DNS because I did not think we needed one but fine I did it. The problem now is I am getting the following error...
The DNS server encountered error 32 attempting to load zone 100.100.10.in-addr.arpa from Active Directory. The DNS server will attempt to load this zone again on the next timeout cycle. This can be caused by high Active Directory load and may be a transient condition. For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/even...When I click the Support Link it simply says Microsoft has no solution to this problem yet. Can any one help us?
Ok, solved the problem. I did an NSLOOKUP and found it was not resolving the DNS server name. After much triel and error I found that you I had to do a SERVER mydnsservername on the NSLOOKUP of the DNS server. This has at least resolved the DNS issues but I have a feeling that the SQL Server problem has to do with us switching Default Gateways on the DHCP server because our primary router is crapping out and we are switching to the backup router. The problem is that I put in a static route on the server to route traffic to the second NIC on our SQL Server for any traffic coming from our backup router but the DNS Host record was still set to the IP of the old NIC. I am going to change the DNS entry and see if it solve the SQL Server problem.
Thanks for listening.
Ad Choices