Nicholson, Karen
knicholson at gpsx.net
Wed Oct 15 12:10:31 CDT 2003
Can you use a name for a server that has "reserved characters" in it? Like MAS-1 or MAS-2? Just asking, we had a problem with using the same naming conventions from SQL 7 on our new SQL 2000 servers. -----Original Message----- From: Eric Barro [mailto:ebarro at afsweb.com] Sent: Wednesday, October 15, 2003 11: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