• Status: Open
  • Priority: High
  • Security: Private
  • Views: 37
  • Last Modified:

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
0
wasabi3689
Asked:
wasabi3689
5 Comments
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
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/DeveloperCommented:
Shift+Right-Click on shortcut
ssmsrunas.png
0
 
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

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now