I have install a while ago a SQL server on my home computer.
now, due to my work, I'm more confident with it and want to play around with
it at home.
I try to make a connection string to it and I keep having error:
---------------------------
SQL Query Analyzer
---------------------------
Unable to connect to server HERMES:

Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'lloyd'. Reason: Not associated with a trusted SQL Server connection.
---------------------------
OK
---------------------------

I try play around with user role, etc ... in SQL Enterprise manager, no way
I manage user lloyd to work.
this drives me crazy, how could I connect to this database.

(apparently windows authentication work, but I DON'T want to use it, I want
to use a login/password !)

BTW I was wondering, I don't really understand how windows authentication
work, nowhere I manage to find the right granted to myself or user ASP_NET,
where could I find that ?