How to connect to a MSSQL database using a windows account, but without logging in under it?

Question

Active Directory

When logging in from a windows domain account to a system that is authorized to connect to the database, the user does not even need to enter a password. The authentication type is Windows Authentication. In this case, you cannot change the user to another. How to connect to the database if the user has a domain account, but the computer itself is not in the domain?
There is an Active Directory authentication type - Password (the only one where you can enter a password), but it refuses to work and gives errors.
Actually, is it possible to connect to it at all?

Answer 1

You can add a local account to it (client's computer), such as in a domain - this will work if MSSQL itself is also a domain controller.