Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hameed
Starting Member
40 Posts |
 Posted - 2001-12-14 : 15:06:31
|
| I created a dns entry on my dns server to point to my sql serversql1.deltaworld.com and I can ping the server by typing the dns name sql1.deltaworld.com in my command window - which obviously means it is resolving correctly. However when I change my connection string for one of the websites that is accessing this sql server (on a different server of course) from using the IP address to this dns name, the site will not come up. It says connect failed. What else do I need to do so that I can change all my connection strings from using the IP address to the domain name?Here is my connection string:objConn.Open("Provider=SQLOLEDB; Data Source=64.7.70.18; Initial Catalog=dbname; " & "User Id=temp; Password=temp;") |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-14 : 15:33:47
|
| If it's working by IP Address and not by name from the same machine, then it sounds like the ports are working okay. I'd suggest you enter the appropriate info into the SQL Client Network Utility on your web server, and make sure you have selected TCP/IP.-------------------It's a SQL thing... |
 |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2001-12-19 : 17:13:50
|
| If you are not running an Internet-registered DNS server for which you're the SOA, your DNS changes won't be visible outside your network. Internet-visible DNS needs to start in the Root servers for the net, and you have to coordinate with the Internic to have "real" names.If you do have registered nameservers, and you are the SOA for the domain, it may take hours to days for your changes to be visible to other Internet computers and ISP's. ======Doug G====== |
|
|
|
|
|
|
DNS Problem