Prev: Import data from Access to SQL
Next: Corrupted .mdf file.
From: Jason Wilson on 20 Jan 2010 12:48
I am unable to create a new windows autentication SQL Server login on my
system. It is a 32 bit SQL Server 2008 (Developer Edition) on Windows 7.
Whenever I try to create the login, either in SSMS, or with T-SQL, I get an
error 15401 - Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49
Windows NT user or group 'MyDomain\Username' not found. Check the name again.

If I click search, it can find it in AD no problem, but when I try to OK to
create it, is when it cannot find it. I have searched the web, and found KB
324321 and went through that, and none of that was the problem, nor resolved
the issue. I am however to login using my windows domain ID which is in the
local admins group.

PLEASE HELP!

Thanks,
From: Uri Dimant on 21 Jan 2010 03:52
Jason
What does xp_logininfo 'MyDomain\Username' return ?

Using sp_helptext 'sp_grantlogin' you could see what line 49 ia about


"Jason Wilson" <JasonWilson(a)discussions.microsoft.com> wrote in message
news:54F3D3D8-B2A3-4FE0-9D34-98B7B9B572DE(a)microsoft.com...
>I am unable to create a new windows autentication SQL Server login on my
> system. It is a 32 bit SQL Server 2008 (Developer Edition) on Windows 7.
> Whenever I try to create the login, either in SSMS, or with T-SQL, I get
> an
> error 15401 - Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line
> 49
> Windows NT user or group 'MyDomain\Username' not found. Check the name
> again.
>
> If I click search, it can find it in AD no problem, but when I try to OK
> to
> create it, is when it cannot find it. I have searched the web, and found
> KB
> 324321 and went through that, and none of that was the problem, nor
> resolved
> the issue. I am however to login using my windows domain ID which is in
> the
> local admins group.
>
> PLEASE HELP!
>
> Thanks,


From: Jason Wilson on 21 Jan 2010 08:41
Thanks for the response. When I run xp_logininfo for the new user I am
trying to add it returns this error:

Msg 15404, Level 16, State 11, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user 'MyDomain\NewUser',
error code 0x6fd.

Thanks,

Jason

"Uri Dimant" wrote:

> Jason
> What does xp_logininfo 'MyDomain\Username' return ?
>
> Using sp_helptext 'sp_grantlogin' you could see what line 49 ia about
>
>
> "Jason Wilson" <JasonWilson(a)discussions.microsoft.com> wrote in message
> news:54F3D3D8-B2A3-4FE0-9D34-98B7B9B572DE(a)microsoft.com...
> >I am unable to create a new windows autentication SQL Server login on my
> > system. It is a 32 bit SQL Server 2008 (Developer Edition) on Windows 7.
> > Whenever I try to create the login, either in SSMS, or with T-SQL, I get
> > an
> > error 15401 - Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line
> > 49
> > Windows NT user or group 'MyDomain\Username' not found. Check the name
> > again.
> >
> > If I click search, it can find it in AD no problem, but when I try to OK
> > to
> > create it, is when it cannot find it. I have searched the web, and found
> > KB
> > 324321 and went through that, and none of that was the problem, nor
> > resolved
> > the issue. I am however to login using my windows domain ID which is in
> > the
> > local admins group.
> >
> > PLEASE HELP!
> >
> > Thanks,
>
>
> .
>
From: Roger Newton on 2 Feb 2010 14:39
We had a similiar issue with a windows 2008 r2 server, we made the folowing
changes documented in this article
(http://www.tomshardware.com/forum/189775-46-shows-permissions-domain-users)

Domain Member: Digitally encrypt or sign secure channel data (always) - Set
this to Disable
Domain member: Digitally encrypt secure channel data (when possible) _ Set
this to Disable
Domain member: Digitally sign secure channel data (when possible) _ Set
this to Disable


"Jason Wilson" wrote:

> Thanks for the response. When I run xp_logininfo for the new user I am
> trying to add it returns this error:
>
> Msg 15404, Level 16, State 11, Procedure xp_logininfo, Line 62
> Could not obtain information about Windows NT group/user 'MyDomain\NewUser',
> error code 0x6fd.
>
> Thanks,
>
> Jason
>
> "Uri Dimant" wrote:
>
> > Jason
> > What does xp_logininfo 'MyDomain\Username' return ?
> >
> > Using sp_helptext 'sp_grantlogin' you could see what line 49 ia about
> >
> >
> > "Jason Wilson" <JasonWilson(a)discussions.microsoft.com> wrote in message
> > news:54F3D3D8-B2A3-4FE0-9D34-98B7B9B572DE(a)microsoft.com...
> > >I am unable to create a new windows autentication SQL Server login on my
> > > system. It is a 32 bit SQL Server 2008 (Developer Edition) on Windows 7.
> > > Whenever I try to create the login, either in SSMS, or with T-SQL, I get
> > > an
> > > error 15401 - Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line
> > > 49
> > > Windows NT user or group 'MyDomain\Username' not found. Check the name
> > > again.
> > >
> > > If I click search, it can find it in AD no problem, but when I try to OK
> > > to
> > > create it, is when it cannot find it. I have searched the web, and found
> > > KB
> > > 324321 and went through that, and none of that was the problem, nor
> > > resolved
> > > the issue. I am however to login using my windows domain ID which is in
> > > the
> > > local admins group.
> > >
> > > PLEASE HELP!
> > >
> > > Thanks,
> >
> >
> > .
> >
 | 
Pages: 1
Prev: Import data from Access to SQL
Next: Corrupted .mdf file.