connect to SQL server: windows authentication / SQL Server authentication

  • Thread starter Thread starter Lloyd Dupont
  • Start date Start date
L

Lloyd Dupont

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 ?
 
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
 
thanks Lloyd :-)

--
ihookdb
Get your data mobile
http://www.ihookdb.com


Lloyd Sheen said:
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 said:
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 ?
Click to expand...
Click to expand...
 
Back
Top