SQL ODBC connection errors

I'm trying to set up a ODBC connection to our SQL server when I do I get the errors below. FYI, these connect work fine from from the server, so it must be a remote connection problem. I have checked a bunch of the settings on the server and can't solve it.


If I use the SQL Server 2005 Native Client Driver the following error occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Named Pipes Provider: No process is on the other end of the pipe.


Connection failed:
SQLState: '08S01'
SQL Server Error: 233
[Microsoft][SQL Native Client]Communication link failure
Connection failed:
SQLState: '08001'
SQL Server Error: 0
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

---------------------------
OK
---------------------------

If I use the SQL Server 2000 Driver the following error occurs:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 233
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (PreLoginHandshake()).
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

---------------------------
OK
---------------------------

Any help would be greatly appreciated.

Norman

You might need to check the version of your MDAC on your client end and see whether it is different than your server end. Also what edition is your sql server 2005. Since some edition disable the remote connection by default and you need to use Surface Area Configuration tool to enable sqlserver and
sqlbrowser and start the sqlbrowser service if you haven't already done so.

I checked the MDAC verison and on the server it is MDAC 2.8 SP2 and on the client it is MDAC 2.8 SP1. How can I update the client? I look on the MS site but can only find SP1 for download....

Also I did check in the Surface Area Configuration tool and the remote connection is enbled and using TCP/IP and name pipes. And the services are running.