Unable to create login / Error 15401

Question

Post reply

Unable to create login / Error 15401

Bob Boursaw

SSC Eights!

Points: 865
More actions
June 4, 2007 at 2:47 pm

#172647

Ok,
I have been all over MS website trying to figure out what I'm missing and so far, no success. I am trying to create a new DB login by browsing to my NT domain account. When doing so I receive the following error.
"Windows NT group or user name, "Domain\user" not found.
I know that it is there as I'm using it now. I also check AD and see it is there with no errors showing.
I then looked in the sys.syslogins table and don't see it there either.
What am I missing here? Why can't I create this account?
Thanks!!
Bob
November 1, 2018 at 1:49 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

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

jezemine SSCrazy Eights Points: 8059 More actions · Answer 1

what's the DDL you are issuing to create the login?

---------------------------------------
elsasoft.org

Moreno-84941 Hall of Fame Points: 3258 More actions · Answer 2

I assume you try to create the login through the GUI by selecting new and the browsing the domain. Do you see the account, can you select it ? Or you type directly domain\username in the GUI ?

Is the SQL server in the same domain ? If not are the domain trusted ?

Bob Boursaw SSC Eights! Points: 865 More actions · Answer 3

Good morning,

The account is valid, I am logged in with it on the domain, the server and I are both in the same domain, the login did exist at one time but I had to delete and recreate all logins and DB accounts, which is when my problem started.

Bob

Diane-238072 SSChasing Mays Points: 619 More actions · Answer 4

Have you tried using T-SQL:

USE MASTER

GO

CREATE LOGIN [domain\user] FROM WINDOWS

GO

USE [database_name}

GO

CREATE USER [domain\user] FOR LOGIN [domain\user]

GO

Moreno-84941 Hall of Fame Points: 3258 More actions · Answer 5

Try this http://support.microsoft.com/kb/324321/en-us

Bob Boursaw SSC Eights! Points: 865 More actions · Answer 6

Ok, so here's where I'm at now.

When I try to create the login via TSQL I get the following.

Windows NT user or group 'nwdc.net\rboursaw' not found. Check the name again.

My sys.syslogins table looks like this (name and loginname):

sa sa

##MS_SQLResourceSigningCertificate## ##MS_SQLResourceSigningCertificate##

##MS_SQLReplicationSigningCertificate## ##MS_SQLReplicationSigningCertificate##

##MS_SQLAuthenticatorCertificate## ##MS_SQLAuthenticatorCertificate##

BUILTIN\Administrators BUILTIN\Administrators

NT AUTHORITY\SYSTEM NT AUTHORITY\SYSTEM

NWDC58AP\SQLServer2005MSSQLUser$NWDC58AP$WFMPROD NWDC58AP\SQLServer2005MSSQLUser$NWDC58AP$WFMPROD

NWDC58AP\SQLServer2005SQLAgentUser$NWDC58AP$WFMPROD NWDC58AP\SQLServer2005SQLAgentUser$NWDC58AP$WFMPROD

NWDC58AP\SQLServer2005MSFTEUser$NWDC58AP$WFMPROD NWDC58AP\SQLServer2005MSFTEUser$NWDC58AP$WFMPROD

##MS_AgentSigningCertificate## ##MS_AgentSigningCertificate##

TCSDBOWNER TCSDBOWNER

TCSADMIN TCSADMIN

TCSACDPROC TCSACDPROC

TCSAPPROC TCSAPPROC

TCSAUTORUN TCSAUTORUN

TCSCHECKER TCSCHECKER

TCSTALLYSERVER TCSTALLYSERVER

TCSUPDATER TCSUPDATER

WFMEXPORTER WFMEXPORTER

WFMIMPORTER WFMIMPORTER

WFMSCHEDEVENT WFMSCHEDEVENT

WFMSSMONITOR WFMSSMONITOR

NWDC-NET\s.tcsservices NWDC-NET\s.tcsservices

NWDC-NET\LLenz NWDC-NET\LLenz

NWDC-NET\LHemphil NWDC-NET\LHemphil

NWDC-NET\s.rtalisten NWDC-NET\s.rtalisten

NWDC-NET\s.wfmdispatcher NWDC-NET\s.wfmdispatcher

RTALISTEN RTALISTEN

I am 100% certain that the accout in the domain is fine.

both teh account and the DB are in the same domain.

Not sure what else to do here and following the above link from the MS site didn't resolve the issue either.

Moreno-84941 Hall of Fame Points: 3258 More actions · Answer 7

Hey, maybe I got it use mwdc\username without .net otherwise SQL get a problem....I bet now it will work

David le Quesne SSCertifiable Points: 5229 More actions · Answer 8

Or NWDC-NET\Username ?

If it ain't broke, don't fix it...

Moreno-84941 Hall of Fame Points: 3258 More actions · Answer 9

OK I see your point. Let say, if domain is microsoft.com type microsoft\username

kgottfredsen Mr or Mrs. 500 Points: 542 More actions · Answer 10

I believe that if your SQL Server was installed with a case-sensitive collation, the login name must be specified with the exact same case as how the Windows user account was defined.