Error 53

I have SQL Server 8 running locally on my networked XP pc. I would like to have users connect to the database there through the network. Each time they try to connect, the following error occures:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection open(CreateFile()).
Connection failed:
SQLState:'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
When a user tries to connect, are they to use my IP address, my computer name, my SQL Server Group name? I think I've tried all ways, but they can't connect (myself included).
</scratching head>
tia,
JMorrell
Could be an error with authentication. Make sure that they are using named
pipes protocol and are authenticated to your PC with an ID that has
permissions for SQL server. Try having them map a drive first with this ID.
"JMorrell" wrote:

> I have SQL Server 8 running locally on my networked XP pc. I would like to have users connect to the database there through the network. Each time they try to connect, the following error occures:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection open(CreateFile()).
> Connection failed:
> SQLState:'08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
> When a user tries to connect, are they to use my IP address, my computer name, my SQL Server Group name? I think I've tried all ways, but they can't connect (myself included).
> </scratching head>
> tia,
> --
> JMorrell