So when it worked for you and you had no issues, you must have been using a SQL login.
Sue
SQL Login? what makes you say that? I was using Windows authentication.
Also, I just want to make sure that there is no confusion. We used to have an employee who would use SSMS to login, now he is no longer working for us but does some consulting work for the company. He doesn't have company's laptop anymore so he is asking if his machine name ( 'LAPTOP-AJ0F871P\greg’) can be added into the company's AD so he can use his personal laptop to access our DBs using windows authentication. Is that even possible?
Because if it's an issue of SPNs for the service account, you would have had the double hop issue as well.
That's why I was asking about the security mapping because you had reported you had no errors and it worked fine. The other non-sysadmin user had the issues.
Sue