[dba-SQLServer]Connecting to the server

Eric Barro ebarro at afsweb.com
Wed Oct 15 10:58:08 CDT 2003


Francisco,

Add an entry for the SQL server name in the HOSTS file on his machine associated with the IP. Then you can use the name in place of the IP since the HOSTS file will resolve to the IP.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Francisco H Tapia
Sent: Wednesday, October 15, 2003 8:34 AM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]Connecting to the server


My Boss's pc is running windows 2000 SP3 (I found out today he is on 
this later SP).  The problem I found last night was that for some reason 
his pc is not able to identify the SqlServer Name, if I add it in a 
connection string it can't find it, however If I replace the name with 
an IP then it finds it w/o any problems.

Why would this suddenly happen (yes I know MS, but really why?)? more 
importantly how do I fix it?


-- 
-Francisco


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003



More information about the dba-SQLServer mailing list