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 Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 122
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 Veteran
SSC Veteran (228 reputation)SSC Veteran (228 reputation)SSC Veteran (228 reputation)SSC Veteran (228 reputation)SSC Veteran (228 reputation)SSC Veteran (228 reputation)SSC Veteran (228 reputation)SSC Veteran (228 reputation)

Group: General Forum Members
Points: 228 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 Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 122
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 Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 122
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
Mr or Mrs. 500
Mr or Mrs. 500 (539 reputation)Mr or Mrs. 500 (539 reputation)Mr or Mrs. 500 (539 reputation)Mr or Mrs. 500 (539 reputation)Mr or Mrs. 500 (539 reputation)Mr or Mrs. 500 (539 reputation)Mr or Mrs. 500 (539 reputation)Mr or Mrs. 500 (539 reputation)

Group: Administrators
Points: 539 Visits: 3699
@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
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 1190
[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 Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 122
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