Home All Groups Group Topic Archive Search About

connect via QA with windows auth without joining domain

Author
30 Nov 2005 2:01 AM
dinosaur8000
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!

Author
30 Nov 2005 11:43 AM
Tibor Karaszi
Try mapping a drive to a share on a machine in that domain

Show quote
news:1133316094.691249.88290@z14g2000cwz.googlegroups.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!
>
Author
30 Nov 2005 9:15 PM
dinosaur8000
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:
Show quote
> 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/
>
>
> <dinosaur8***@yahoo.com> wrote in message
> news:1133316094.691249.88290@z14g2000cwz.googlegroups.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!
> >

AddThis Social Bookmark Button