Hi @sql dev ,
Please check first:
The server name and instance was selected and configured by browsing for the nstance to connect to
The user account was checked to ensure it had appropriate permissions in the instance and required database
The windows firewall is turned off on both the SQL Server and the remote server
The server was pingable
Could telnet to the port without error
'Cannot generate SSPI context' means that SSPI tries but cannot use Kerberos authentication to delegate client credentials through TCP/IP or Named Pipes to SQL Server
Because as mentioned above there are various reasons why Kerberos connections fail, it is recommeded to fix the error with Kerberos configuration manager
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.