I'm very new to SQL Server Administration. I've built databases before once
the program was installed, but I'm new to installing it myself. I'm trying
to get a feel for it by installing it on a test server. When I try to
create a DSN to it I can see the server, but when I try to connect with a
valid SQL server username and password I receive the followingn error:
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'patricia'. Reason: Not associated with a trusted SQL Server connection.
Any ideas? This is SQL Server 2000 installed on a W2K Advanced Server
machine. I'm trying to connect to it from a W98 machine.