sql server?

houssam_ballout

New Member
When I was trying to install MS SQL server 2000, I have move to a step that it asks me:
Choose the authentication mode with 2 options:
Windows Authentication Mode
and Mixed Mode (Windows authentication and SQL server authentication)?
what to choose and for what do these used?
thanks
 
houssam_ballout said:
When I was trying to install MS SQL server 2000, I have move to a step that it asks me:
Choose the authentication mode with 2 options:
Windows Authentication Mode
and Mixed Mode (Windows authentication and SQL server authentication)?
what to choose and for what do these used?
thanks

Easiest way is to use Windows authentication. My understanding was that if a domain comprised of all windows members Windows authentication was the choice and if a domain comprised of windows and novell clients Sql server authentication was the correct choice. If you choose Sql server authentication does it ask for a username and password? pick sa for the username and create a password.
 
Back
Top