VPN into 2ns domain?

From: Richard Siddaway (rsiddaw@hotmail.com)
Date: 05/20/02


From: "Richard Siddaway" <rsiddaw@hotmail.com>
Date: Mon, 20 May 2002 04:49:19 -0700


The easiest answer is to create a user login based in the
clients domain

Richard Siddaway
MCSE(Win2K), MCDBA

>-----Original Message-----
>I am using VPN to connect my laptop to a second domain at
a client site. I
>want to use Windows authentication to connect to a SQL
Server at this
>location. I am getting an error message "Cannot generate
SSPI context". This
>makes sense, because I haven't specified anywhere that I
want to use another
>domain/account to get into SQL Server.
>
>My question is, can I still log into my laptop under
MyCompany\MyUser and
>somehow specify that windows should use
ClientDomain\AccountAtClient in
>order to get into SQL Server?
>
>If not, I guess my options are to either create a 2nd
user login on my
>laptop for the client's domain (in which case all my
settings etc would be
>in the other login...) or, just for SQL Server, to create
a SQL Server login
>to use. We are planning to use only Windows integrated
security.
>
>Thanks in advance.
>
>
>.
>



Relevant Pages

  • Re: Cannot generate SSPI context
    ... when i use a laptop on a domain. ... I can however connect using SQL Auth. ... Everything works fine when I use sql server ... but if I switch to windows authentication I get the error ...
    (microsoft.public.sqlserver.connect)
  • RE: Setting up replication
    ... the least expensive way to get Full SQL Server 2000 and that gets you SQL ... Each Laptop can use Windows Synchronization Manager (found ... in Start, All Programs, Accessories, Synchronize to Create an Anonymous Merge ... > I have just converted an access mdb app to an access adp app with msde ...
    (microsoft.public.sqlserver.replication)
  • Re: Unable to ping some machines - others ok???
    ... The IP Address of the laptop ... The IP Address of the SQL server ... > decided to attempt to ping the machine to troubleshoot the issue. ... > successfully able to ping other machines on the LAN no probs. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Run-time error 2467... Oh yes it does!
    ... Over the weekend I sat down side by side, my laptop and the desktop. ... I could not prove it but once the SQL Server ... If there were no object in the subform control, then you could refer to it ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
  • IIS on server 2000
    ... When you access a asp page from the website - it ... domain authentication - The SQL server requests a user id ... asp page is running on the IIS webserver it sends the ... Is there a setting in IIS to pass the user login ...
    (microsoft.public.inetserver.iis.security)