SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Windows Authentication Login Creation issue


Windows Authentication Login Creation issue

Author
Message
Scott_4
Scott_4
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 121
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 Wink )



All help appreciated.

(edit: and I'm not sure why images are not posting - same format works elsewhere ... )

Thank you.

Scott MacDonald
Tucson, AZ
f242337
f242337
SSC Journeyman
SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)

Group: General Forum Members
Points: 82 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.
Scott_4
Scott_4
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 121
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
Scott_4
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 121
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. BigGrin

Have a good day all!

s
dave.convery@red-gate.com
dave.convery@red-gate.com
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: Administrators
Points: 293 Visits: 3601
@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
sqlsurfing
Old Hand
Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)Old Hand (394 reputation)

Group: General Forum Members
Points: 394 Visits: 1185
[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 :-D
Scott_4
Scott_4
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 121
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search