Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Windows Authentication Login Creation issue Expand / Collapse
Author
Message
Posted Saturday, May 11, 2013 11:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 11:15 AM
Points: 26, Visits: 117
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
Post #1451845
Posted Saturday, May 11, 2013 3:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:35 PM
Points: 16, Visits: 34
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.
Post #1451860
Posted Saturday, May 11, 2013 3:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 11:15 AM
Points: 26, Visits: 117
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
Post #1451861
Posted Saturday, May 11, 2013 3:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 11:15 AM
Points: 26, Visits: 117
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. :D

Have a good day all!

s
Post #1451862
Posted Monday, May 13, 2013 2:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: Administrators
Last Login: Yesterday @ 7:44 AM
Points: 15, Visits: 2,417
@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.
Post #1451994
Posted Monday, May 13, 2013 2:50 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 1:12 AM
Points: 132, Visits: 934
[quote](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
Post #1451998
Posted Monday, May 13, 2013 9:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 11:15 AM
Points: 26, Visits: 117
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
Post #1452170
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse