Windows Authentication Login Creation issue

Question

Windows Authentication Login Creation issue

Scott_4

Old Hand

Points: 367
More actions
May 11, 2013 at 11:53 am

#277376

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?
(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 😉 )
All help appreciated.
(edit: and I'm not sure why images are not posting - same format works elsewhere ... )
Thank you.
Scott MacDonald
Tucson, AZ

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

f242337 Right there with Babe Points: 798 More actions · Answer 1

It sounds like your database server is not in a domain -- thus, it only offers you the one choice for login, that one choice being its local SAM. (* Unless it is a DC; that's a rather unusual case.)

If your database server is indeed not in a domain, then you will only be able to create windows logins that exist in the local SAM.

Scott_4 Old Hand Points: 367 More actions · Answer 2

That does make sense - and it's entirely possible.

I have been more of a SQL Geek and DB Developer, rather than the Administration end - so I'm not real familiar with this area.

I will investigate it further. And, if you have the answer handy, how would I move my installation INto this domain?

Your help appreciated - thank you.

s

Scott_4 Old Hand Points: 367 More actions · Answer 3

Wasn't a domain issue for SQL Server - it's some type of issue with my Windows Login.

-o-

And just for grins I created a new account on my computer - in my Wife's name, and very simply created a SQL Server Windows Authentication account for her.

So something about my Windows Login is screwed up.

I can live with that - I just need to know how to make this work in general, not specifically for me. 😀

Have a good day all!

s

Dave Convery SSCrazy Points: 2159 More actions · Answer 4

@Scott_4

I've edited the post so the URLs are pointing at the image files rather than the host page. That should work reliably.

sqlsurfing SSCarpal Tunnel Points: 4883 More actions · Answer 5

(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.)[\quote]

Did you solve this problem? If not, Have you check for case sensitivity of your AD account?

--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

Scott_4 Old Hand Points: 367 More actions · Answer 6

I'm not sure what the issue is with my particular login - but it worked for another login I created - so I'm satisfied that I understand and can reproduce the concept.

Thank you.

s