sql server odbc: Is it possible to open a SQL Server connection using domain credentials that
are not your own? In ODBC dialog, you have the option for Windows
Authentication (your own domain account - this works, but not what I want)
or SQL Authentication.

In SQL Server, I have a login created as a domain account and it shows
correctly in SSMS as domain\username.

When trying to create an ODBC connection using domain\username, I get "Login
failed for domain\username".

If I create a SQL login as just username, it works. But, I really want to
have a domain account login.

Is there a way to make this work short of having to login as the domain
account I am trying to configure?

SQL Server 2005 SP1