sql server mixed mode authentication question

I set my sql server to sql server mixed mode authentication

Question
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
wasabi3689Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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 Specialist IVCommented:
You either login to the server with the Windows account or RunAs SSMS as a different user
0
wasabi3689Author Commented:
I don't understand this part " RunAs SSMS as a different user",

More specific, or example
0
Shaun VermaakTechnical Specialist IVCommented:
Shift+Right-Click on shortcut
ssmsrunas.png
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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
0
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.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
wasabi, a feedback will be appreciated.
Cheers.
0
David Johnson, CD, MVPOwnerCommented:
sql authentication and windows authentication are completely separate. so you can't do what you want
0
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
SQL

From novice to tech pro — start learning today.