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