SQL Server 2014 cant add any windows accounts

Question

Post reply

SQL Server 2014 cant add any windows accounts

zouzou

SSCrazy

Points: 2292
More actions
June 23, 2016 at 8:30 am

#400312

hello all,
I have an weird issue it started after a reboot of a sql server 2014, I have windows and sql authentication on, on my sql server and service account is running for the sql service but when I try to add a new login I cant see much on the Active directory and therefore cant add any more windows logins
Does anybody have any idea what the issue could be?
Riri

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

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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

Can you add them with T-SQL, e.g

CREATE LOGIN [DOMAIN\USER] from WINDOWS

?

zouzou SSCrazy Points: 2292 More actions · Answer 2

Yeah I can with T - SQL but not through the GUI any ideas why ?

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 3

What's the error? Any login issues? Check for SSPI errors in the log.

I'd suspect somehow either your machine, or the SQL Server is struggling with viewing AD. If you're using the Gui in SSMS, I believe this is your account, from your machine, querying AD. If you use the GUI, this is submitted to the server and run there, though I'm not sure there is any check if the account is a valid AD account.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 4

When you browse to find the login, are you definitely changing the location from your local machine to Entire Directory?

zouzou SSCrazy Points: 2292 More actions · Answer 5

yes and it doesn't give me the whole structure

zouzou SSCrazy Points: 2292 More actions · Answer 6

An object with the following name cannot be found. Check the selected object types and locations for accuracy and ensure that you have typed the object name correctly or remove the object from the selection

that is the error and I m running it locally on the sql server

Lowell SSC Guru Points: 323504 More actions · Answer 7

i believe the GUI will DEFAULT to use Local Users to the server, and you explicitly need to select domain. annoying, for sure.

so if i search for mydomain\lowell, it does nto exist in the scope of the local machine, hence the error.

note the "From this location" has the machine name, and not the domain

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!