question

billgreen-4986 avatar image
0 Votes"
billgreen-4986 asked cthivierge answered

DNS Cannot be recognized!

I know I am in the wrong section, but I cannot find anyone to help. I figured a DBA could possibly help me with this issue.

I am getting this error from the command prompt whenever I ping :

"Ping request could not find host oraserver. Please check the name and try again."

My host file has been edited to add oraserver:

192.168.56.199 oraserver.myserver oraserver


I changed permissions and that sent me on this rabbit hole adventure.

Can anyone help? It appears administrator has a red "X" over it as if it is messed up.
133811-image.png


windows-server
image.png (2.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @billgreen-4986,

Your issue is not related to SQL server, it is related to windows server. So I add the window server tag, people there will give you a better help.

0 Votes 0 ·
MotoX80 avatar image
0 Votes"
MotoX80 answered

Try using 2 entries. Does either name ping?

 192.168.56.199 oraserver.myserver
 192.168.56.199 oraserver

Did you make the update with notepad or some other program? You might have changed the encoding. Open hosts with notepad and verify that it's UTF-8.

133814-capture.jpg


I changed permissions

On what? The hosts file? Put it back. Hosts inherits all permissions from the Etc folder.



capture.jpg (62.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello,

Thank for reaching out.

Please try to access your DB server using FQDN and see if you can get ping responses.

Also, Please try to disable firewall and anti-virus for temporarily.

In your host file also add another entry with ip and just hostname ( without FQDN).

Hope this helps,

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

cthivierge avatar image
0 Votes"
cthivierge answered

I would go with @MotoX80 suggestion

Try adding 2 lines in the hosts file. I had several issues with multiple name on the same line in the past that were fixed by adding separate line for each entry


133938-hosts1.png



hosts1.png (23.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.