SQLState: '01000' SQL Server Error : 86

[niallo32]

I have an Access 2000 database which connects to SQL Server 2000. I created a user in Enterprise Manager and gave that user access to the relevant Database. When prompted for a SQL Server login, I enter the username & password. This worked fine yesterday

I am now getting the following error:

Connection Failed:
SQLState: '01000'
SQL Server Error: 86
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 86
[Microsoft][ODBC SQL Server Driver]Client unable to establish a connection

----

Any idea how to fix it?

Thanks