Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logging into a database using SSMS from non-domain machine

Status
Not open for further replies.

RRinTetons

IS-IT--Management
Jul 4, 2001
333
0
0
US
I have a client who, quite properly,has all SQL Server do’s set to Windows Authentication. I have a VPN connection, I can see the database server. I even have a Windiescaccountinntheirsystem. However being on a non-domain computer gives me no obvious (obvious to me, anyway) way to authenticate.

Is there a Windows kludge?some script trick? A SQL Server configuration? Just give up?

-
Richard Ray
DBA, Developer, Data Analyst
Jackson Hole Mountain Resort
 
you can shit+right-click on SSMS and start it as a different user. Assuming your VPN was setup to allow it you may be able to enter your client supplied domain/user/password and have it authenticate to their domain

Regards

Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top