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