Server Explorer (SQL Server Login)

[Tommy Malone]

I have an SQL Server running on an XP (SERVER) machine to which I am trying
to connect via Visual Studio and the Server Explorer on another machine. I
see the "SERVER" Explorer but when I try to expand and view the tables on
the "SERVER" I am prompted to login and cannot. I have admin rights on all
machines and the SQL Server but cannot seem to get a connection. My error
specifically is "Not associated with a trusted SQL Server connection".

Is there good documentation on what needs to be configured and where to make
this connection via the Server Explorer?

Clearly I am weak in SQL and Windows security and I appreciate any tips or
reading.

Thanks.

 

[Rogas69]

If you want to connect to SQL Server using its own authentication you should
configure it to support 'mixed' mode authentication which is off by default
afair. It is on the server's properties window, on security tab in SQL 2000.
The error you are describing is related to fact SQL Server rejects all
connections not based on Windows authentication.

Peter