Sunday, May 12, 2013

[SQL 2012] Windows Authentication Login Creation issue

[SQL 2012] Windows Authentication Login Creation issue

Windows Authentication Login Creation issue

Posted: 11 May 2013 04:53 AM PDT

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? [img]http://imgur.com/6SHp3Um[/img](edit: since I have no image - the msg I receive is "An object (User) with the following name cannot be found. "Scott" (which is my Windows login). Check the selected object types and locations for accuracy and ensure that you have typed the object name correctly, or remove this object from the selection.)Someone elsewhere suggested I "Try changing location to Entire Directory" - Unfortunately that doesn't seem to be a choice ... "FROGROOM-PC" is the only choice (long story on the computer name here ;) )[img]http://imgur.com/c4bo8dD[/img]All help appreciated.(edit: and I'm not sure why images are not posting - same format works elsewhere ... )Thank you.Scott MacDonaldTucson, AZ
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog