I am transitioning my work laptop to a coworker (who we'll call Mary Smith) who is taking my place on my team as I move on to other things. One of the tools we use is Microsoft SQL Server Management Studio. We have always used windows Authentication to access our local databases. It has always worked for me, like so:
I had Mary log into the laptop with her active directory credentials, and it proceeded to setup her account on the laptop. Later I logged back in with my credentials, and gave Mary admin privileges on the laptop.
Later, with Mary logged in again, I was going to walk her through the database schemas, and had her attempt to connect with Windows Authentication:
This resulted in the following error:
I am thinking this either has something to do with some settings in user accounts on the laptop, or the database (or MS SQL Server) settings themselves need to be changed... or a combination of the two. How can I solve this error so Mary can successfully connect to her local MS SQL Server with Windows Authentication?