Error 22042

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

Date: Wed, 26 Nov 2003 04:09:01 -0800

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: Linked Server Connection Problem
    ... Use SQL authentication to connect to the SQL server from the client, ... set the domain account used to start SQL Server to have permissions in the ... Establish a SPN for your domain account which will enable Kerberos ... Load the Active Directory Users and Computers MMC snap-in. ...
    (microsoft.public.sqlserver.connect)
  • RE: ssis, sql job and windows authentication - how to impersonate
    ... You'll want to setup an agent proxy. ... I want to put this ssis on a sql server. ... Do not really want to give to this particular sql server agent account any ... different domain account there. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Services account question...
    ... I wish you'd say the reason of not using a domain account as a service account for the SQL Server. ... Backup operations are performed by SQL Server service, at this point I don't know what goes on under hood exactly but SQL Server service may be needed to communicate to the AD for validation of the database owner and as the SQL Server service is a local one, it can't achieve this task. ... > Source: Security Event ID: 537 ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... >>I've enabled anonymous access, setting it to the correct domain account, ... >> the correct permissions in sql server ... > That means the local user permissions, the SQL Server, etc. ... >> c) I've enabled anonymous access, setting it to the correct domain account, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)