Can not connect to SQL Server

A user who has been connected to our server for several years can not longer
connect.
The error through ODBC shows the following :
Connection failed:
SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server not
found.
No one else in the firm is having troubles connecting to the server. The
server has SP4 applied.Can he ping the server by hostname? Check to his ODBC connection to ensure
that it is correct. It sounds like a name resolution problem.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
>A user who has been connected to our server for several years can not
>longer
> connect.
> The error through ODBC shows the following :
> Connection failed:
> SQLState: '01000'
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
> (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
> not
> found.
> No one else in the firm is having troubles connecting to the server. The
> server has SP4 applied.|||They can ping and connect to other named instances on the server.
I have since found if they put "SERVERNAME\PortNumber" instead of
"SERVERNAME\INSTANCENAME" in their definition it all works.
Why is that ?
"Hilary Cotter" wrote:
> Can he ping the server by hostname? Check to his ODBC connection to ensure
> that it is correct. It sounds like a name resolution problem.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
> news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
> >A user who has been connected to our server for several years can not
> >longer
> > connect.
> >
> > The error through ODBC shows the following :
> > Connection failed:
> > SQLState: '01000'
> > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
> > (Connect()).
> > Connection failed:
> > SQLState: '08001'
> > SQL Server Error: 6
> > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
> > not
> > found.
> >
> > No one else in the firm is having troubles connecting to the server. The
> > server has SP4 applied.
>
>