Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
1 year ago

Connecting MS SQL with hostname\database

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 con...
Need Help
Show and Tell
Tips and Tricks
Karthik12's avatar
Karthik12
Post Patron
1 year ago

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's avatar
PhilipTreacy
Super User
1 year ago

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