Set Database password

Question

Hi all

 

I am not so much expertise in sql server. 

 

I had created an application that uses sql as its backend which connects on Windows authentication. 

 

Now,  I want to create a user id and password that should be used to access that database. And no one should have access through Windows authentication mode. 

 

Kindly suggest.