sql server mixed mode authentication question

I set my sql server to sql server mixed mode authentication

I add this Windows account, for example domain name\johnsmith to SQL server login
If I want to log into SQL server by this Windows account like domain name\johnsmith on SQL authentication, not on Windows authentication
Can I do that?

My SQL server is SQL 2012
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shaun VermaakTechnical SpecialistCommented:
You either login to the server with the Windows account or RunAs SSMS as a different user
wasabi3689Author Commented:
I don't understand this part " RunAs SSMS as a different user",

More specific, or example
Shaun VermaakTechnical SpecialistCommented:
Shift+Right-Click on shortcut
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

David Johnson, CD, MVPOwnerCommented:
it is either/or they are totally independent of each other
sql login authenticates by the sql server
windows login authentication is by AD/computer
Vitor MontalvãoMSSQL Senior EngineerCommented:
What tool are you using to connect to the database?
If you use SSMS then it will use the credential of the current user (the user that's actually logged in his/her computer). To run with the credentials of another user you must use the RunAs option and provide the new credentials to connect to the database.
Vitor MontalvãoMSSQL Senior EngineerCommented:
wasabi, a feedback will be appreciated.
David Johnson, CD, MVPOwnerCommented:
sql authentication and windows authentication are completely separate. so you can't do what you want
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.