connect via QA with windows auth without joining domain

Hi, I'm using my laptop to connect to a client's internal network. I'd
like to connect to their SqlServer database using Query Analyzer,
Enterprise Manager, osql, etc... They only have Windows Authentication
enabled (they won't change this setting).
When I try to connect in QA I get the authentication failed for user
(null) error.
They've given me a domain login to use when connecting to their
database, but I'm not sure how to use it without logging on to windows
as that user.
I'd prefer not to make my laptop part of their domain. I'd rather use
my regular (local machine) login so I can access my installed programs
and files.
Any thoughts on how I should connect?
Thanks!
Try mapping a drive to a share on a machine in that domain
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<dinosaur8000@.yahoo.com> wrote in message
news:1133316094.691249.88290@.z14g2000cwz.googlegro ups.com...
> Hi, I'm using my laptop to connect to a client's internal network. I'd
> like to connect to their SqlServer database using Query Analyzer,
> Enterprise Manager, osql, etc... They only have Windows Authentication
> enabled (they won't change this setting).
> When I try to connect in QA I get the authentication failed for user
> (null) error.
> They've given me a domain login to use when connecting to their
> database, but I'm not sure how to use it without logging on to windows
> as that user.
> I'd prefer not to make my laptop part of their domain. I'd rather use
> my regular (local machine) login so I can access my installed programs
> and files.
> Any thoughts on how I should connect?
> Thanks!
>
|||I've done that. I mapped a drive to the machine hosting the SqlServer,
actually. I supply the domain login and I'm able to connect to the
share just fine. However, when I try to connect to the DB through QA or
Enterprise Manager, it doesn't work. Am I missing a step?
Tibor Karaszi wrote:[vbcol=seagreen]
> Try mapping a drive to a share on a machine in that domain
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> <dinosaur8000@.yahoo.com> wrote in message
> news:1133316094.691249.88290@.z14g2000cwz.googlegro ups.com...