Billy Pang
tuxedo_man at hotmail.com
Wed Oct 15 12:21:51 CDT 2003
Under the Client Network Utlity, are all the server aliases intact? >From: Francisco H Tapia <my.lists at verizon.net> >Reply-To: dba-sqlserver at databaseadvisors.com >To: dba-sqlserver at databaseadvisors.com >Subject: Re: [dba-SQLServer]Connecting to the server >Date: Wed, 15 Oct 2003 09:36:18 -0700 > >I saw this problem before on a developer's machine who has added everything >under the sun to his machine, SP's, .NET and it's SP's etc, etc. For some >reason connecting to the server by name (for example MYSRVC) won't connect >It is running Sql Server 2000 SP3. the default listening 1433 port has >been modified. on the other hand connecting to a Sql7 server does not >provide these side-effects. I have over 30 workstations that connect to >this same server w/o any side effects. I don't want them modified because >I'm sure it'll create the same problems like my Boss's pc and my >co-worker's pc. > >the total length of the the server name is 8 characters, no special or >otherwise non alpha characters at all. (i.e. MYAASRVC) > >Nicholson, Karen wrote: >>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 > _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail