I just installed SQL Server 2016 Developer on a Windows 10 Professional laptop. I set it up to use Windows authentication. I'm having trouble with what seems to be very simple DB permissions.
I am the administrator for the laptop and have sa rights for the instance of SQL Server.
Under the SECURITY > Logins tree of the instance my login is shown (i.e. MYLAPTOP\CalBob). If I right-click on the properties of my login I have user mappings to the db (i.e. ANALYTICS) I need access to. However, when I go to the db, ANALYTICS > Security, my User name/account is not listed, and when I try to add it, I get one of two error messages telling me:
1. If I try to add MYLAPTOP\CalBob I get message saying it is invalid because it contains invalid characters.
2. If I try to add CalBob it says CalBob is an invalid login or I don't have permissions.
Ultimately the problem is if I want to give myself permissions to a table in that database I'm told the user does not exist. For example.
GRANT SELECT on tablename1 TO CalBob
I receive an error indicating the user doesn't exist or I don't have permissions. And I understand that CalBob doesn't exist as a User in the database, but I can't add CalBob either.
This seems simple but I'm obviously missing something. Any ideas?