Post reply

Cannot Generate SSPI Context

  • January 7, 2009 at 12:00 pm

    #99453

    I have an Access database with some SQL Server linked tables.

    When I am at work on the network, I can double click on the linked tables and see the data.

    However, when I come in through the VPN, I cannot open the linked tables. I get a "Cannot Generate SSPI Context" message.

    While on the VPN, I can:

    (1) Ping the SQL Server with NO problems.

    (2) Through the cliconfig utility - see that TCP/IP and Named Pipes (in that order) are enabled

    Any suggestions?

    Thanks in advance

  • January 8, 2009 at 12:53 pm

    #923646

    are you logging in via Windows Authentication?

    check that your account is valid on the AD domain, and not locked out. There may be problem with picking up the domain controller

    Can you login via SQL Server authentication (username/password)?

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • January 8, 2009 at 1:13 pm

    #923661

    Yes, sorry. It is Windows authentication.

    I authenticate fine at work - it is just when using the VPN.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply