Connecting MS SQL with hostname\database

[Karthik12]

Hello Team,

I am trying to get date from SQL server database. My machine and remote machine connected in the same network.

When I try to put IPV4 address\sql instance name, it is successfull to connect the data base and I can load. 

But problem is when I try to put hostname istead of IP address the problem is not connected.

Please support to guide me how to establish connection with hostname instead of IP address.

[Karthik12]

Hi @PhilipTreacy 

Thank you very much for your time. I have done the same.

I have done the same in cmd.

IP address ping is sucessfull and hostname ping is not successfull (Lost 100%).

May I know how to setup DNS resolution?

[PhilipTreacy]

Hi @Karthik12 

OK, firstly, is it necessary to use the hostname to connect?  if the IP address works, why not just continue with that?

DNS resolution should work via your company DNS servers.  I assume you are doing this from inside your business?  If not, where did the hostname come from?

You can aso use an entry in your hosts file, but again, why not just stick with the IP address if it works?

To add an entry to your hosts file check this article for instructions

How to Add a Local DNS Lookup to Hosts File (helpdeskgeek.com)

Regards

Phil

[Karthik12]

Hi @PhilipTreacy 

The problem is am using IP address inside a business. Mine and remote host connected to a same business wifi and these IPs are dynamic and it used to change on daily basis. 

I am facing connection issues everyday and I used to go to remote PC and note down the IP address then used to change data source option daily.

That's why I wanted to use hostname.

[PhilipTreacy]

@Karthik12 

OK then the business DNS server/system should be set up in such a way that you can use it to connect.

If the IP of the server is dynamic (why is this, it's crazy for a server to have a dynamic IP address?) then you can't use a static entry in your hosts file either.

Where did you get this hostname from?  Whomever gave it to you should have set up a DNS system that allows you to use that hostname to connect to this server.

regards

Phil

[PhilipTreacy]

@Karthik12 

So the hostname INDLT-6SYSTIT has the IP address 10.28.x.x ?

Open a command prompt and type ping INDLT-6SYSTIT to confirm this.

The replies you get after using that ping command will tell you the IP address your computer is using to connect to INDLT-6SYSTIT

If that IP address isn't the one you expect i.e. 10.28.x.x then there's an issue with the DNS name resolution on your computer.  That could be down to several things but first off check your DNS server is correct and that its records are correct.

Phil