thanks Lloyd :-)
--
ihookdb
Get your data mobile
http://www.ihookdb.com
"Lloyd Sheen" <(E-Mail Removed)> wrote in message
news:e%smc.17355$(E-Mail Removed)...
> To change this use Enterprise Manager.
>
> Right click on the server you want to change. Select properties. Then
> select the Security tab. You will see radio buttons that will allow you
to
> change the Authentication: to SQL Server and Windows. This will allow you
> to use a SQL Server only login.
>
> To manage your logins, expand the server node and select Security/Logins.
>
> Lloyd Sheen
>
>
> "Lloyd Dupont" <net.galador@ld> wrote in message
> news:(E-Mail Removed)...
> > 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 ?
> >
> >
>
>
Similar Threads
