HOSTS FILE/DNS SERVER

Hi: I have a new client and we have established site to site VPN connection. We have workgroup environment and they have provided us an application which we have to install in our local machine and we have installed it successfully but when we are trying to access by providing credentials provided by client,  it gives error "DATABASE SERVER NOT FOUND" when we discussed about this error they told us that please do entry in your "DNS SERVER" which we haven't.

Is there any option/solution that we can overcome with this problem? I would appreciate if you could help me out. it is very urgent. If any more information required would be happy to provide

Regards
Sanjeev
Sanjeev jhaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scot HalvorsenCommented:
If you do not have a DNS server in your network environment, you can add entries to the local "hosts" file on the machine running the application.

[Windows 8]
As an administrator, run notepad and edit the file 'C:\Windows\System32\Drivers\etc\hosts'.

Add an entry "<ip> <hostname>", where IP is the address of the databases server and HOSTNAME is the hostname the application is trying to reach.
Sanjeev jhaAuthor Commented:
Thanks! I have done all these things but still facing the ERROR "Database server not found"
client has suggested me to configure in DNS server, which I have not in my organisation. Please advise me for any alternate option to get out.


Please advise
advise.png
Lee W, MVPTechnology and Business Process AdvisorCommented:
Is there a reason you haven't advised the client that you don't have a DNS server?  Perhaps they have an alternate configuration.

(One option might be to use the server's IP.  And are you sure you've edited the hosts file correctly?  Can you ping the server from the command line?)
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Sanjeev jhaAuthor Commented:
yes am getting reply from both ip and host name both.
Sanjeev jhaAuthor Commented:
any way to check  sql connectivity from my pc to their database server. or check sql which i have installed on my pc.
Scot HalvorsenCommented:
Different SQL servers use different ports to communicate. Can you describe what application you are trying to use and what SQL server you are trying to connect to?

If you knew the port number the SQL server used to communicate with, you can use the windows 'telnet' program to try to 'ping' the port.

Ex. C:/> telnet db_server port_num

Where db_server is the IP of the database and port_num is the port number that database is listening to.

Port 3306 is the default port number for MySQL
Port 1433 is the default port for SQL Server.

If the telnet program fails, most likely that port is blocked or not in use. If the telnet program succeeds, the program will connect, however you will not be able to do anything with it. You need a proper client to communicate with a database server correctly.
Sanjeev jhaAuthor Commented:
Thanks I tried to telnet by both IP and Server name with given port no but it showing error of Failed connection.
Scot HalvorsenCommented:
If you believe that you are using the correct port and IP address, then something is blocking the connection.

Most common reason is that you have a firewall or aggressive virus protection software program active between you and the database.

If you have access to a machine that is allowing you to connect to the database, I suggest comparing this machine and environment with you current setup.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sanjeev jhaAuthor Commented:
Thank you very much for always support.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.