I have a staging SQL Server that is not joined to the domain. When I access the server, I log into remote desktop as a local user on that machine.
However, I can connect to the SQL Server instance in SSMS from my machine using Windows Authentication. However, I can't find how this is working. I don't see my domain username included in the list of logins.
Is there a way to tell how my domain account has permissions to log in? This server in general is a mess and I need to start cleaning it up and setting up other users to use Windows Authentication instead of SQL Server Authentication.