All geek questions in one place

SQL 2005 instance will not work with DNS

Basically, I have a standard sql 2005 server with a named instance installed (server / instance1). I also created a DNS record (dnsDBServer) that points to the sql server IP address. The web application that we can connect uses the following methods (ipaddress / instance1, server / instance1), but cannot connect using dnsDBServer / instance1. Of course, this view defeats the purpose of writing dns. I wonder if sql aliases will help solve this problem or if someone has a solution. Thanks.

+3
source share
3 answers

ha, I just realized that the web server (which is the same server that the SQL server is running on) did not update its own DNS. I should have checked this first thing. I launched ipconfig / flushdns and started working. It never occurred to me to check the server. Thank you for your help.

0
source

Most likely, your DNS resolution does not work the way you thought.

Make a trace from the machine that is trying to talk to your sql server and see where it will be.

You should also look at the firewall settings between the requesting machine and the server to see if there is anything else that could affect it.

+3
source

? server.bob.net, dnsDBServer.fred.com?

  • ping -a, , DNS .
  • , DNS " DNS- ( )".
  • Can SSMS in a SQL window connect to dnsDBServer \ instance1?
  • tracert, as already suggested
+2
source

Source: https://habr.com/ru/post/1704672/

More articles:


All Articles