[ODBC SQL Server Driver] error

[eao]

SQL Server 2000 SP3
Access 2000 and 97 database connecting through ODBC.

When users attempt to connect to any database on this server, they receive the following error message.

Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[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.

Enterprise Manager hangs when I attempt to browse the local server. This is a fresh installation of SQL Server. What could be causing this, and how should I begin to troubleshoot? Thanks.

 

[Luvsql]

Can you ping the server by name, IP and also can you ODBCping the server?

Make sure that TCP/IP is configured properly and that you are able to ping between client and server both by name and IP address. Additionally, go into the Client Network Utility and the Server Network Utility. On the General tab, click on the Server Alias Configuration and choose Edit.

if you run SELECT @@SERVERNAME in query analzer, do you get the correct result?