Showing posts with label group. Show all posts
Showing posts with label group. Show all posts

Monday, March 12, 2012

Login does not exist - Error 15401

Hello,
Our IT Infrastructure group had recently renamed the Windows login username
from Bob_J to JBob. When I tried to add the new login with the new username
after the change, I received the error '15401: Windows NT user or group 'Cor
porate\JBob' not found. Che
ck the name again.' I used the sp_revokelogin to drop that login but it stil
l did not allow me to add the new username. I know the issue related to SID
but I had removed the login according KB324321.
If I added the login 'Corporate\Bob_J' back, it was fine. Under User Manager
, user Bob_J no longer exists. Have anyone had experience with this? If so,
how can I correct it? Do I not have a choice by either using the old usernam
e or create a new Windows l
ogin user? Any help will be greatly appreciated. Thank you.This could be ralated to the following article:
http://support.microsoft.com/?kbid=329420.
SQL Server uses the function mentioned in the article. If you have SP4 of
Windows 2000 installed this may not be the problem. The quick resolution is
to reboot all serves involved starting with the SQL Server to see if that
will resolve the problem and then the domain controller.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Friday, March 9, 2012

Login Account

Hello,
When I try to add a login account to SQL Server, I get the following error.
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
The account is the built in Windows Administrator account renamed.
Any and all help is greatly appreciated.
Thanks,
Donnie
"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following
> error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
I'm not following here.
Did you:
1. Create a new Windows Account and grant it all the same privs and the
Administrator account?
2. Rename the Windows Administrator account. (Not sure if you can even do
that...)
When you tried to add the account, were you using sp_grantlogin, sp_addlogin
or SQL Enterprise Manager?
When you tried to add the account, did you specify the domain\user name
like: MyLocalComputer\Administrator or something else?
Is it a Domain account?
Does the account have access to your local server?
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick,
Thanks for your reply.
The renamed administrator account is the built-in default administrator
account for Windows 2003 SBS.
When I try to add this account using Enterprise Manager on the same server,
I get the error:
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
Hope this clarifies the issue. Thanks for your help.
Donnie
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> I'm not following here.
> Did you:
> 1. Create a new Windows Account and grant it all the same privs and the
> Administrator account?
> 2. Rename the Windows Administrator account. (Not sure if you can even
> do that...)
> When you tried to add the account, were you using sp_grantlogin,
> sp_addlogin or SQL Enterprise Manager?
> When you tried to add the account, did you specify the domain\user name
> like: MyLocalComputer\Administrator or something else?
> Is it a Domain account?
> Does the account have access to your local server?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Rick,
> Thanks for your reply.
> The renamed administrator account is the built-in default administrator
> account for Windows 2003 SBS.
> When I try to add this account using Enterprise Manager on the same
> server, I get the error:
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> Hope this clarifies the issue. Thanks for your help.
> Donnie
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>
I don't know if this will help here, but have you restarted the server with
the account name change?
Rick
|||Yes. The account has been renamed for some time now.
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23bsj0o5lFHA.320@.TK2MSFTNGP09.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> I don't know if this will help here, but have you restarted the server
> with the account name change?
>
> Rick
>
>
|||Hi,
Are you specifying the account as:
NameOfComputer\AccountName
?
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
|||Hey Dan,
I am specifiying as
Domain\AccountName
Thanks,
Donnie
"Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Are you specifying the account as:
> NameOfComputer\AccountName
> ?
> --
> HTH
> Dan Artuso, Access MVP
>
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>
|||Hi,
I think we mean the same thing :-)
If you're specifying a local account, the 'Domain' is the computer name.
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OP$fQxQmFHA.2628@.tk2msftngp13.phx.gbl...
> Hey Dan,
> I am specifiying as
> Domain\AccountName
> Thanks,
> Donnie
> "Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
> news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
>

Login Account

Hello,
When I try to add a login account to SQL Server, I get the following error.
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
The account is the built in Windows Administrator account renamed.
Any and all help is greatly appreciated.
Thanks,
Donnie"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following
> error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
I'm not following here.
Did you:
1. Create a new Windows Account and grant it all the same privs and the
Administrator account?
2. Rename the Windows Administrator account. (Not sure if you can even do
that...)
When you tried to add the account, were you using sp_grantlogin, sp_addlogin
or SQL Enterprise Manager?
When you tried to add the account, did you specify the domain\user name
like: MyLocalComputer\Administrator or something else?
Is it a Domain account?
Does the account have access to your local server?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick,
Thanks for your reply.
The renamed administrator account is the built-in default administrator
account for Windows 2003 SBS.
When I try to add this account using Enterprise Manager on the same server,
I get the error:
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
Hope this clarifies the issue. Thanks for your help.
Donnie
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
> I'm not following here.
> Did you:
> 1. Create a new Windows Account and grant it all the same privs and the
> Administrator account?
> 2. Rename the Windows Administrator account. (Not sure if you can even
> do that...)
> When you tried to add the account, were you using sp_grantlogin,
> sp_addlogin or SQL Enterprise Manager?
> When you tried to add the account, did you specify the domain\user name
> like: MyLocalComputer\Administrator or something else?
> Is it a Domain account?
> Does the account have access to your local server?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Rick,
> Thanks for your reply.
> The renamed administrator account is the built-in default administrator
> account for Windows 2003 SBS.
> When I try to add this account using Enterprise Manager on the same
> server, I get the error:
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> Hope this clarifies the issue. Thanks for your help.
> Donnie
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
>> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
>>
>> I'm not following here.
>> Did you:
>> 1. Create a new Windows Account and grant it all the same privs and the
>> Administrator account?
>> 2. Rename the Windows Administrator account. (Not sure if you can even
>> do that...)
>> When you tried to add the account, were you using sp_grantlogin,
>> sp_addlogin or SQL Enterprise Manager?
>> When you tried to add the account, did you specify the domain\user name
>> like: MyLocalComputer\Administrator or something else?
>> Is it a Domain account?
>> Does the account have access to your local server?
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>
I don't know if this will help here, but have you restarted the server with
the account name change?
Rick|||Yes. The account has been renamed for some time now.
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23bsj0o5lFHA.320@.TK2MSFTNGP09.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
>> Rick,
>> Thanks for your reply.
>> The renamed administrator account is the built-in default administrator
>> account for Windows 2003 SBS.
>> When I try to add this account using Enterprise Manager on the same
>> server, I get the error:
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> Hope this clarifies the issue. Thanks for your help.
>> Donnie
>> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
>> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
>> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
>>
>> I'm not following here.
>> Did you:
>> 1. Create a new Windows Account and grant it all the same privs and the
>> Administrator account?
>> 2. Rename the Windows Administrator account. (Not sure if you can even
>> do that...)
>> When you tried to add the account, were you using sp_grantlogin,
>> sp_addlogin or SQL Enterprise Manager?
>> When you tried to add the account, did you specify the domain\user name
>> like: MyLocalComputer\Administrator or something else?
>> Is it a Domain account?
>> Does the account have access to your local server?
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>>
> I don't know if this will help here, but have you restarted the server
> with the account name change?
>
> Rick
>
>|||Hi,
Are you specifying the account as:
NameOfComputer\AccountName
?
--
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>|||Hey Dan,
I am specifiying as
Domain\AccountName
Thanks,
Donnie
"Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Are you specifying the account as:
> NameOfComputer\AccountName
> ?
> --
> HTH
> Dan Artuso, Access MVP
>
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
>|||Hi,
I think we mean the same thing :-)
If you're specifying a local account, the 'Domain' is the computer name.
--
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OP$fQxQmFHA.2628@.tk2msftngp13.phx.gbl...
> Hey Dan,
> I am specifiying as
> Domain\AccountName
> Thanks,
> Donnie
> "Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
> news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> > Are you specifying the account as:
> >
> > NameOfComputer\AccountName
> > ?
> >
> > --
> > HTH
> > Dan Artuso, Access MVP
> >
> >
> > "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> > news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> >> Hello,
> >> When I try to add a login account to SQL Server, I get the following
> >> error.
> >>
> >> " Error 15401: Windows NT user or group "Domain\User" not found.
> >> Check the name again. "
> >>
> >> The account is the built in Windows Administrator account renamed.
> >>
> >> Any and all help is greatly appreciated.
> >>
> >> Thanks,
> >> Donnie
> >>
> >>
> >>
> >
> >
>

Login Account

Hello,
When I try to add a login account to SQL Server, I get the following error.
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
The account is the built in Windows Administrator account renamed.
Any and all help is greatly appreciated.
Thanks,
Donnie"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following
> error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
I'm not following here.
Did you:
1. Create a new Windows Account and grant it all the same privs and the
Administrator account?
2. Rename the Windows Administrator account. (Not sure if you can even do
that...)
When you tried to add the account, were you using sp_grantlogin, sp_addlogin
or SQL Enterprise Manager?
When you tried to add the account, did you specify the domain\user name
like: MyLocalComputer\Administrator or something else?
Is it a Domain account?
Does the account have access to your local server?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick,
Thanks for your reply.
The renamed administrator account is the built-in default administrator
account for Windows 2003 SBS.
When I try to add this account using Enterprise Manager on the same server,
I get the error:
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
Hope this clarifies the issue. Thanks for your help.
Donnie
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> I'm not following here.
> Did you:
> 1. Create a new Windows Account and grant it all the same privs and the
> Administrator account?
> 2. Rename the Windows Administrator account. (Not sure if you can even
> do that...)
> When you tried to add the account, were you using sp_grantlogin,
> sp_addlogin or SQL Enterprise Manager?
> When you tried to add the account, did you specify the domain\user name
> like: MyLocalComputer\Administrator or something else?
> Is it a Domain account?
> Does the account have access to your local server?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Rick,
> Thanks for your reply.
> The renamed administrator account is the built-in default administrator
> account for Windows 2003 SBS.
> When I try to add this account using Enterprise Manager on the same
> server, I get the error:
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> Hope this clarifies the issue. Thanks for your help.
> Donnie
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>
I don't know if this will help here, but have you restarted the server with
the account name change?
Rick|||Yes. The account has been renamed for some time now.
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23bsj0o5lFHA.320@.TK2MSFTNGP09.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> I don't know if this will help here, but have you restarted the server
> with the account name change?
>
> Rick
>
>|||Hi,
Are you specifying the account as:
NameOfComputer\AccountName
?
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OMP54h3lFHA.3380@.TK2MSFTNGP12.ph
x.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following error
.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>|||Hey Dan,
I am specifiying as
Domain\AccountName
Thanks,
Donnie
"Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Are you specifying the account as:
> NameOfComputer\AccountName
> ?
> --
> HTH
> Dan Artuso, Access MVP
>
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>|||Hi,
I think we mean the same thing :-)
If you're specifying a local account, the 'Domain' is the computer name.
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OP$fQxQmFHA.2628@.tk2msftngp13.ph
x.gbl...
> Hey Dan,
> I am specifiying as
> Domain\AccountName
> Thanks,
> Donnie
> "Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
> news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
>