SQL Server database password
<p>I am not so much expertise in SQL Server. </p>

<p>I had created an application that uses SQL Server as its backend which connects on Windows authentication. </p>

<p>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. Also I don't want to disable windows authentication mode. </p>

<p>Kindly suggest</p>