hello there!
i have a question regarding authentication in SQL2005
i am using MS SQL Server Management Studio Express
and also created a username same privelege as "sa"

why is it when logging in to the database there are "Windows Authentication" and "SQL Server Authentication" i need only the SQL Server Authentication because it requires password but in Windows Authentication it will automatically connect to the dataabase, my worry is that what if the user change the value of the database?

and when deploying sthe program since i have created a new username do i still to install MS SQL Server Management Studio Express? just to create the the new username on the client?(client means it will be the server in deployment not my PC)

unlike in MS access just set the password nobody will open the database.

tnx.-