 |
|
|
|
Next: Mass-Market Your Website 33013
|
| Author |
Message |
External
Since: Mar 02, 2006
Posts: 56
|
(Msg. 1) Posted: Thu Aug 14, 2008 3:29 pm
Post subject: Cannot add domain users
Archived from groups: microsoft>public>sqlserver>security (more info?)
|
|
|
Hello.
I have found several issues raised already regarding adding domain users as
logins to the SQL server, but none of them answered my problem.
I'm running the SQL server service (it is an SQL Express) under domain user,
which has administrative rights in the domain (let's say DOMAIN\Admin). I can
log in to the server via remote desktop using this account, I can login to
the Management Studio and to all the configs.
But when I need to add more users from the domain to access the SQL server I
get an error, that the "Windows NT user or group 'DOMAIN\User' not found.". I
can list the domain users by using the browse button, so the user is there
for sure and if I use the user from the list, it is correctly typed as
DOMAIN\User.
What is stragne, the only user I can add from the domain is the user which
the sql service runs under.
Any ideas, where the problem might be?
Thank you very much.
Peter. |
|
| Back to top |
|
 | |
External
Since: Mar 03, 2006
Posts: 234
|
(Msg. 2) Posted: Thu Aug 14, 2008 9:19 pm
Post subject: RE: Cannot add domain users [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Can you describe exactly how you did to add a domain user to access SQL Server?
Linchi
"Peter" wrote:
> Hello.
>
> I have found several issues raised already regarding adding domain users as
> logins to the SQL server, but none of them answered my problem.
>
> I'm running the SQL server service (it is an SQL Express) under domain user,
> which has administrative rights in the domain (let's say DOMAIN\Admin). I can
> log in to the server via remote desktop using this account, I can login to
> the Management Studio and to all the configs.
>
> But when I need to add more users from the domain to access the SQL server I
> get an error, that the "Windows NT user or group 'DOMAIN\User' not found.". I
> can list the domain users by using the browse button, so the user is there
> for sure and if I use the user from the list, it is correctly typed as
> DOMAIN\User.
>
> What is stragne, the only user I can add from the domain is the user which
> the sql service runs under.
>
> Any ideas, where the problem might be?
>
> Thank you very much.
>
> Peter. |
|
| Back to top |
|
| |
External
Since: Mar 02, 2006
Posts: 56
|
(Msg. 3) Posted: Fri Aug 15, 2008 3:06 am
Post subject: RE: Cannot add domain users [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi, Linchi.
Thank you for your reply - the way I have added the user was:
Opened Management Studio, connected to the server using the windows
authentication with the currently logged in user (it is the same user under
which the sql server runs).
The select Security -> Login and choose new login. In the dialog I selected
browse and typed in the name of the account from the domain I wanted to add.
I clicked the Check names button to ensure the account from domain is OK.
Then I selected OK, so the login name field filled with the DOMAIN\User form
of name and choosen the appropriate roles for the user (db_creator, as it
should be able to create new database). Then I clicked OK and the error
message appeared.
Do you have any idea, why I can't get the domain account working?
Thank you.
Peter.
"Linchi Shea" wrote:
> Can you describe exactly how you did to add a domain user to access SQL Server?
>
> Linchi
>
> "Peter" wrote:
>
> > Hello.
> >
> > I have found several issues raised already regarding adding domain users as
> > logins to the SQL server, but none of them answered my problem.
> >
> > I'm running the SQL server service (it is an SQL Express) under domain user,
> > which has administrative rights in the domain (let's say DOMAIN\Admin). I can
> > log in to the server via remote desktop using this account, I can login to
> > the Management Studio and to all the configs.
> >
> > But when I need to add more users from the domain to access the SQL server I
> > get an error, that the "Windows NT user or group 'DOMAIN\User' not found.". I
> > can list the domain users by using the browse button, so the user is there
> > for sure and if I use the user from the list, it is correctly typed as
> > DOMAIN\User.
> >
> > What is stragne, the only user I can add from the domain is the user which
> > the sql service runs under.
> >
> > Any ideas, where the problem might be?
> >
> > Thank you very much.
> >
> > Peter. >> Stay informed about: Cannot add domain users |
|
| Back to top |
|
| |
External
Since: Aug 28, 2007
Posts: 179
|
(Msg. 4) Posted: Fri Aug 15, 2008 11:39 am
Post subject: Re: Cannot add domain users [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Peter,
Have you seen this KB?
http://support.microsoft.com/kb/324321/en-us
--
Ekrem Önsoy
"Peter" wrote in message
> Hello.
>
> I have found several issues raised already regarding adding domain users
> as
> logins to the SQL server, but none of them answered my problem.
>
> I'm running the SQL server service (it is an SQL Express) under domain
> user,
> which has administrative rights in the domain (let's say DOMAIN\Admin). I
> can
> log in to the server via remote desktop using this account, I can login to
> the Management Studio and to all the configs.
>
> But when I need to add more users from the domain to access the SQL server
> I
> get an error, that the "Windows NT user or group 'DOMAIN\User' not
> found.". I
> can list the domain users by using the browse button, so the user is there
> for sure and if I use the user from the list, it is correctly typed as
> DOMAIN\User.
>
> What is stragne, the only user I can add from the domain is the user which
> the sql service runs under.
>
> Any ideas, where the problem might be?
>
> Thank you very much.
>
> Peter. >> Stay informed about: Cannot add domain users |
|
| Back to top |
|
| |
External
Since: Mar 02, 2006
Posts: 56
|
(Msg. 5) Posted: Fri Aug 15, 2008 11:39 am
Post subject: Re: Cannot add domain users [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi, Ekrem.
Thank you for your reply - yes I have seen that article as the first thing
to trouble shoot. The problem is, that this is a clean Windows installation
(virtual) with a complete new domain, so there are no duplicate users. Also
the user exists, as I can browse for it... The domain is OK, I have checked
WINS, DNS.
Any other ideas?
"Ekrem Önsoy" wrote:
> Hi Peter,
>
> Have you seen this KB?
> http://support.microsoft.com/kb/324321/en-us
>
> --
> Ekrem Önsoy
>
>
>
> "Peter" wrote in message
>
> > Hello.
> >
> > I have found several issues raised already regarding adding domain users
> > as
> > logins to the SQL server, but none of them answered my problem.
> >
> > I'm running the SQL server service (it is an SQL Express) under domain
> > user,
> > which has administrative rights in the domain (let's say DOMAIN\Admin). I
> > can
> > log in to the server via remote desktop using this account, I can login to
> > the Management Studio and to all the configs.
> >
> > But when I need to add more users from the domain to access the SQL server
> > I
> > get an error, that the "Windows NT user or group 'DOMAIN\User' not
> > found.". I
> > can list the domain users by using the browse button, so the user is there
> > for sure and if I use the user from the list, it is correctly typed as
> > DOMAIN\User.
> >
> > What is stragne, the only user I can add from the domain is the user which
> > the sql service runs under.
> >
> > Any ideas, where the problem might be?
> >
> > Thank you very much.
> >
> > Peter.
> >> Stay informed about: Cannot add domain users |
|
| Back to top |
|
| |
External
Since: Mar 03, 2006
Posts: 234
|
(Msg. 6) Posted: Sat Aug 16, 2008 6:57 pm
Post subject: RE: Cannot add domain users [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
That's odd. What happens if you don't use GUI, but execute the following code
directly?
CREATE LOGIN [domain\user] FROM WINDOWS
Linchi
"Peter" wrote:
> Hi, Linchi.
>
> Thank you for your reply - the way I have added the user was:
>
> Opened Management Studio, connected to the server using the windows
> authentication with the currently logged in user (it is the same user under
> which the sql server runs).
>
> The select Security -> Login and choose new login. In the dialog I selected
> browse and typed in the name of the account from the domain I wanted to add.
> I clicked the Check names button to ensure the account from domain is OK.
>
> Then I selected OK, so the login name field filled with the DOMAIN\User form
> of name and choosen the appropriate roles for the user (db_creator, as it
> should be able to create new database). Then I clicked OK and the error
> message appeared.
>
> Do you have any idea, why I can't get the domain account working?
>
> Thank you.
> Peter.
>
>
> "Linchi Shea" wrote:
>
> > Can you describe exactly how you did to add a domain user to access SQL Server?
> >
> > Linchi
> >
> > "Peter" wrote:
> >
> > > Hello.
> > >
> > > I have found several issues raised already regarding adding domain users as
> > > logins to the SQL server, but none of them answered my problem.
> > >
> > > I'm running the SQL server service (it is an SQL Express) under domain user,
> > > which has administrative rights in the domain (let's say DOMAIN\Admin). I can
> > > log in to the server via remote desktop using this account, I can login to
> > > the Management Studio and to all the configs.
> > >
> > > But when I need to add more users from the domain to access the SQL server I
> > > get an error, that the "Windows NT user or group 'DOMAIN\User' not found.". I
> > > can list the domain users by using the browse button, so the user is there
> > > for sure and if I use the user from the list, it is correctly typed as
> > > DOMAIN\User.
> > >
> > > What is stragne, the only user I can add from the domain is the user which
> > > the sql service runs under.
> > >
> > > Any ideas, where the problem might be?
> > >
> > > Thank you very much.
> > >
> > > Peter. >> Stay informed about: Cannot add domain users |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
