How can i create sqlserver other then window authentication?

Question

I am using sqlserver 2005 i want to implement security on database that no user can open my database with window authentication. How can i set other password for my newer database. Thanks in advance.

Pardeep Malik · Answer

Thanx Hakim but i think sql is more secure. i have publish a website on private server and upload my database there. Is any one can open my database on that server? Elaborate it for me thanx in advance. Pardeep Malik

Christofel Hakim · Answer

You can not disabled the windows authentication. since windows authentication is more secure than SQL authentication. To Set another password of your database: GoTo SQL server management studio and login with sys admin account: [Database Server Name] -> Security -> Logins. You can add remove or modified SQL Server logins in this module.