Re: adding windows user via sp_cmdshell

From: TOM P. (TOMP_at_discussions.microsoft.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 06:52:02 -0700

Hello Hari,

I have tried it, but it did not work for me, I got:
The request will be processedat DC ....
System error 5 has occurred
Access denied.

I got this regardless if I'm using SA account to open Query Analizer or windows auth... where am member of domain admin. any idea...

"Hari Prasad" wrote:

> Hi,
>
> Yes. See the OS commands NET USER and NET GROUP in OS Help. You can use this
> command from Query Anayzer using XP_CMDSHELL.
>
> Sample
>
>
> Master..XP_cmdshell 'net user Fin_user password /DOMAIN /ADD'
> go
> Master..XP_cmdshell 'net group Finance /DOMAIN /ADD'
> go
>
>
> For more details of command execute the below from command prompt
>
> net user ?
>
> net group ?
>
> Thanks
> Hari
> MCDBA
>
>
> "TOM P." <TOMP@discussions.microsoft.com> wrote in message
> news:E8D38151-CF4C-4EF9-A713-617E25BA2AEE@microsoft.com...
> > assuming SQL server nt service is started under domain user with right to
> create windows user in domain, is there a way to execute sp_ in QA that
> allow mw to create domain user, set password and add user to group in
> domain? if so can anyone provide this statment.
> >
> > Tom,
>
>
>

Relevant Pages

  • Re: adding windows user via sp_cmdshell
    ... See the OS commands NET USER and NET GROUP in OS Help. ... For more details of command execute the below from command prompt ... > assuming SQL server nt service is started under domain user with right to ...
    (microsoft.public.sqlserver.security)
  • Re: Im halfway there
    ... Close the Command Prompt. ... the Acer (Ray), assuming it's okay on a wireless network to have them ... Create an account for Ray. ...
    (microsoft.public.win2000.networking)
  • Re: Im halfway there
    ... Close the Command Prompt. ... Laptop 2, a Toshiba, the net command resulted in the following: ... the Acer (Ray), assuming it's okay on a wireless network to have them ...
    (microsoft.public.win2000.networking)
  • Re: Sharing and Security on File Share
    ... net user %UserName%>> c:\test.txt ... When I got to the command: ... "Pegasus (MVP)" wrote: ...
    (microsoft.public.windows.file_system)
  • Re: Im halfway there
    ... Close the Command Prompt. ... Laptop 2, a Toshiba, the net command resulted in the following: ... the Acer (Ray), assuming it's okay on a wireless network to have them ...
    (microsoft.public.win2000.networking)