[dba-SQLServer]Connecting to the server

I never messed with his client network utilities on his pc, thus never 
checked, just now I found that it was using the wrong port number I 
modified it and it seems to all be working fine..

now the big question... how did this happen?

Billy Pang wrote:

> 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
>>
>>


-- 
-Francisco