Hey, the server in our office is runing SQL server. it is basically used just for database storage. Today it started throwing a lot of errors out (Event ID: 5774 Source: NETLOGON "DNS operation failed." ) I looked through microsoft's knowlege base and looked up various other forums who had this posted. I tried all of the suggestions and nothing has worked.
I talked to my boss about the issue and he is wondering if we really even need DNS on. We have, at max, 15 computers working with the server. We also use a VPN so our employees can access the server from home. Really the only thing people use the server for is for data entry.
My question is: Do I NEEED DNS activated or is it really worthless for our small network.
Are you using Active Directory? If so, you will need to keep DNS on. If not, no, you don't really NEED it, but you'll need a WINS server unless you want to remember each workstation's IP.
You could disable it but then you'd want to add to your host file (C:\windows\system32\drivers\etc\host)
IP address SQLserverName
ex.
127.0.0.1 localhost
That way you computer will know where to point. But without DNS or a WINS server running, resolution may not work unless everything is running Vista or XP. You'd have to go by IP address and not computer name.
You are about to answer a thread that has been inactive for more than 6 months. If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.