During the installation of SQL Server you can choose the authentication mode for Database Instance. SQL Server support the two authentication mode as 1) Windows authentication mode 2) Mixed authentication mode
Read this post on varindersandhu.in