Results 1 to 4 of 4
  1. #1
    chrisdd is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    13

    SQL server [ODBC SQL Server Driver]Cannot generate SSPI context

    Hi,

    I'm using SQL server express 2019 which recently could only be accessed via a VPN.

    I'm using a standard ODBC connection string:

    ODBC;Driver={SQL Server};SERVER=#######DATABASE=#######;UID=####### ;PWD=#######;

    When I first changed the name of the server to connect without the VPN it worked fine but now if I close it and reconnect I see the following message:

    SQL server [ODBC SQL Server Driver]Cannot generate SSPI context

    Do I need to change the connection string in some way I wonder? Or is this a configuration issue with the server?

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    have you tried using the connect string to build an odbc link? then see if that works.

  3. #3
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Probably the DNS can't solve the server name. Take a look here: https://dba.stackexchange.com/questi...e-sspi-context

  4. #4
    chrisdd is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2020
    Posts
    13
    Can I also add a further weird detail and that is, if I go into the front end and manually save a form, the next time I open the database I don't see the SSPI error, but if I then close the front end without saving the form and open it again I get the SSPI error??? I'm very confused!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 03-30-2020, 05:31 PM
  2. Accessing SQL Server Via ODBC
    By jaryszek in forum Import/Export Data
    Replies: 4
    Last Post: 01-17-2018, 06:24 AM
  3. ODBC sql server driver invalid object name "query name"
    By masoud_sedighy in forum SQL Server
    Replies: 4
    Last Post: 10-06-2017, 10:12 AM
  4. SQL Server, ODBC, DSN, Access
    By cbende2 in forum Access
    Replies: 10
    Last Post: 06-23-2015, 01:12 PM
  5. Connection to SQL Server ODBC Failed
    By Historypaul in forum SQL Server
    Replies: 2
    Last Post: 01-05-2015, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums