unable to connect

[peterve]

I've set up a SQL Server 2000,
assigned the Domain Admins as database administrators,

I've installed the SQL Client tools on 5 PC's,
but I'm unable to connect to the sql server on one of them.
The user is also a domain admin (using Windows authentication),
but even the connect with the sa user doesn't work (using SQL Server authentication)

What could be wrong here ?

by the way : when I try to connect, I get a 'server does not exist or access denied' - like error
I can ping the server from that machine

When the same user logs on to another machine, he can access the server

I've tried to reinstall the client software,
reapplied SP6a for NT4,
tried to connect to sql using a ODBC connection, but nothing works...

help please

---------------------------------------------------------------------
I have not failed, I've just found 10,000 ways that don't work
---------------------------------------------------------------------
Peter Van Eeckhoutte

 

[Guest_imported]

go to start/programs/sql server 7.0 /enterprise manager right click on the server name and select properties /security .select (windows and server aunthentication).but you should use sql server authentication ok bye
thanks & regards

m.a.khaleel

 

[peterve]

even with sql server authentication it doesn't work
(I've tried it with sa and other users, but it doesn't work) ---------------------------------------------------------------------
I have not failed, I've just found 10,000 ways that don't work
---------------------------------------------------------------------
Peter Van Eeckhoutte

 

[sh4ronL]

I have exactly the same problem. I've checked the mixed sql/windows authentication settings in the security panel, the radio button is checked, but still get the "Not associated with a trusted SQL Server connection" error when trying to connect using SQL Server authentication.

Have also checked on the Server Utility Manager that the TCP/IP libraries are installed. There is another database on the server using NT authentication which works fine.

Anyone have any ideas?