|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
connect via QA with windows auth without joining domainHi, 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
-- Show quoteTibor 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! > 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! > > |
|||||||||||||||||||||||