[dba-SQLServer]Connecting to the server

Djabarov, Robert Robert.Djabarov at usaa.com
Wed Oct 15 14:34:53 CDT 2003


In the Client Network Configuration on your boss's pc create an alias
with tcp address.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Eric
Barro
Sent: Wednesday, October 15, 2003 10:58 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Connecting to the server


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

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



More information about the dba-SQLServer mailing list