I have created new login on our database, and assigned it to the sysadmin group the same as another user with the same.
when I login and go to select data from that user it does not return any results, or any errors. I have attached the very simply login that I have created. There must be something very silly I am not doing.
I am testing this as I set-up a user before that only had select permission and not sysadmin and this did the same thing. I thought I would test by using a test using with the sysadmin role.
Do I need to do anything else to allow it to return the data?