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-08 : 09:57:09
|
| 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;")Edited by - hameed on 12/08/2001 09:57:36 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2001-12-09 : 18:53:02
|
| HiPerhaps you need to configure the name inside your client network utility.Damian |
 |
|
|
|
|
|
IP address change to dns name