I am very new to administering SQL Server 2012. I am starting to study for the Certification Exam 70-462. One of the very first things I tried to do was to create a Windows Login for SQL Server (I had always used sa up to this point).
Of course I immediately ran into issues. I'm not sure why SQL Server is not finding my Windows Login?
Here is a screen capture showing both the Windows Login ("Scott"), and the attempted creation of the SQL Server Windows Authentication - hopefully someone can lead me in the right direction?
This is really annoying me - I popped up my Windows Users list next to the "Advanced/Find Now" results - and you'll note that even though "Scott" appears in the Windows Users list, the same entry does not appear in the SQL Server list.
Hopefully someone knows what this means - because I do not. I do appreciate your getting me to this point though.
Very strange indeed! My knowledge of the Windows internals is sketchy at best, so I don't have any thoughts on why this is happening. If you do find the reasons, please post back so all can learn. Thanks.