cannot login to sql server 2000

Hi,
May I know what is the error below? I can't even login with sa id. It fails
on two workstations but it works on the rest of the workstation.
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (
CreateFile()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL se
rver not
found.
Thanks in advance
andrewHi
Are the rest of the workstations using the same ODBC drivers as the the ones
on the two workstations. Click on the drivers tab and check versions. If
there not the same try and download some
new MDAC drivers. Just a guess. Are the working workstations using TCP/IP
to connect to SQL server?
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:46023653-6EB9-4D0A-AE7E-DC7256C2E36A@.microsoft.com...
> Hi,
> May I know what is the error below? I can't even login with sa id. It
> fails
> on two workstations but it works on the rest of the workstation.
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
> (CreateFile()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL
server not
> found.
> Thanks in advance
> andrew
>