Re: Error 22042

From: Eric (anonymous_at_discussions.microsoft.com)
Date: 11/26/03 

Date: Wed, 26 Nov 2003 05:28:15 -0800

Thanks Ryan,

You know, itīs really weird, I went into Services snap-in
and was able to configure the services with the domain
account. But now SQLServer Agent doesnīt recognize the
MAPI profile, on the other hand I could configure SQL Mail
successfully. ... mmmmm
I'll keep trying, thanks

Eric.
>-----Original Message-----
>There is a Kbase article on 22042, hopefully this will
help :-
>
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;299935
>
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>
>"Eric" <anonymous@discussions.microsoft.com> wrote in
message
>news:0ca001c3b41a$24b77ca0$a501280a@phx.gbl...
>Yes it is. Itīs member of Domain Admins group, and Iīve
>configured it as the account for SQL Service and SQL
>Server Agent in another server in the same domain with no
>trouble.
>
>Eric.
>>-----Original Message-----
>>Is the domain account a member of the Local Admin group
>on the server..?
>>
>>
>>
>>--
>>HTH
>>Ryan Waight, MCDBA, MCSE
>>
>>"Eric" <anonymous@discussions.microsoft.com> wrote in
>message
>>news:064901c3b416$1409c290$a001280a@phx.gbl...
>>> I have SQL server (Sp3a) installed in a Windows 2000
>SP4.
>>> Everytime I try to configure a domain account for SQL
>>> Service or SQL Server Agent. I get this error: Error
>>> 22042: xp_SetSQLSecurity() returned error -
>>> 2147024890 'Invalid driver'. The extended stored
>>> Procedure is defined by xpstar.dll I've tried replacing
>it
>>> with a copy from a server where I can correctly
>configure
>>> the domain account but the error keeps coming up.
>>>
>>> Any suggestions?
>>>
>>> Thanks
>>> Eric.
>>
>>
>>.
>>
>
>
>.
>

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: SCCM with a remote SQL instance problems (IT IS NOT A WARNING)
    ... PreReq check is not a WARNING it is a FAILURE. ... account the run the SQL Server Service on the server, Domain Memberships, AD ...
    (microsoft.public.sms.installer)
  • Re: Distributed Query - Linked Servers?
    ... In the case of SQL style accounts, it doesn't seem very secure to me, because the password will be transmitted over the network. ... it should also be able to work by setting up a credential and proxy account on Server1. ... In this case it could work with NTLM authentication. ... we just need to verify that the 2 sql server instances are under sql server and windows authentication mode and the sql account you use has the permission on the 2 sql server instances. ...
    (microsoft.public.sqlserver.server)