Re: xpsql.cpp

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 12/20/02 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Thu, 19 Dec 2002 20:16:24 -0600

The SQL Server service account also needs the rights below. See
<http://support.microsoft.com/default.aspx?scid=KB;en-us;248391&> for
details.

    Act as part of the operating system.
    Increase quotas.
    replace process level token.
    Log on as a batch job. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Bil" <biljanat@nbrm.gov.mk> wrote in message
news:eC6cVN2pCHA.1980@TK2MSFTNGP12...
> The acount that SQL Server service is running is in local
administrators
> group and also is "sa" in SQL Server. Because I am running xp_cmdshell
as a
> non-sysadmin user, the process uses the SQLAgentCmdExec Windows NT
account
> (created during setup). This account has exec privilegies on
xp_cmdshell,
> and change privilegies on directory where .txt file should be
generated by
> bcp. What else privilegies are to be considered?
>
> What do you mean by "You might try changing the account from EM and
> restarting SQL Server."? I read somewhere that maybe deleting and
recreating
> SQLAgentCmdExec login in EM and restarting SQL Server can help. Did
you mean
> the same? I haven't try that yet.
>
> Thank you for your answer.
> Regards,
> Biljana
>
>
>
> "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
> news:OQQLV4qpCHA.1332@tk2msftngp13...
> > If you are running BCP via xp_cmdshell as a non-sysadmin user, the
error
> > may be because the SQL Server service account does not have the
> > necessary permissions to switch security context to the proxy
account.
> >
> > The necessary account permissions are granted when the service
account
> > is specified during SQL Server installation or with Enterprise
Manager
> > but not when the account is changed from the Services MMC.  You
might
> > try changing the account from EM and restarting SQL Server.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > -----------------------
> > SQL FAQ links (courtesy  Neil Pike):
> >
> > http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> > http://www.sqlserverfaq.com
> > http://www.mssqlserver.com/faq
> > -----------------------
> >
> > "Bil" <biljanat@nbrm.gov.mk> wrote in message
> > news:#Bx9RzopCHA.1612@TK2MSFTNGP09...
> > > I have Win2K and SQL2000 installed on that machine.
> > >
> > >
> > > "Bil" <biljanat@nbrm.gov.mk> wrote in message
> > > news:OhbyzxopCHA.1876@TK2MSFTNGP10...
> > > > When I run bcp command, I receive this message:
> > > >
> > > > Msg 50001, Level 1, State 50001
> > > > xpsql.cpp: Error 1326 from LogonUserW on line 488
> > > >
> > > > Does anybody have any experience concerning this issue?
> > > >
> > > > Thanks in advance.
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Installation - What Account is needed?
    ... Because, when you change your SQL Server' s service account's password from your Active Directory, it won't be updated automatically at the SQL Server server and when your SQL Server service restarts, it'd compain about the wrong password. ... it does not mean your SQL Server services have to be running under the account which you installed the mentioned SQL Server instance. ... I understand you are asking about the required account to install a SQL ...
    (microsoft.public.sqlserver.setup)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)