Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understanding DNS for SQL Server
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Understanding DNS for SQL Server
Miscellaneous
Thread ID:
01679952
Message ID:
01679952
Views:
60
Hi,

I want to be sure I understand the term hostname as far as SQL Server is concerned.

My application connects to the SQL Server using the SQL Server name. E.g. "MySQLExpress"
So, the application does not use the SQL Server IP address.
When the application starts and connects to the SQL Server, does DNS lookup take place?

And would the SQL Server name I use when connecting is the same as 'hostname'?

TIA

UPDATE: I want to test my app connecting the SQL Server by IP and not name. How do I find out what is the IP of the SQLExpress installed on my PC? so that I can test it. TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Next
Reply
Map
View

Click here to load this message in the networking platform