providing sql server authentication in MS SQL code example

Example: authentication in sql server

Windows mode and Mixed Mode – SQL and Windows. 

Click Start> Programs> Microsoft SQL Server and 
click SQL Enterprise Manager to run SQL
Enterprise Manager from the Microsoft SQL
Server program group.
Then select the server from the Tools menu.
Select SQL Server Configuration Properties, 
and choose the Security page.