error 8198

  • I have an SQL server runnig on a Windows 2000 member server of a domain for which the doamain controller is running Windows 2003. When a job is run with owner being domain\user, I get an error saying "Unable to determine if the owner domain\user has access to the server".

    If I use "SA" account, it works, but will have problems executing part of the job which is to send a mail using one of the domain mailboxes and it will end up having "MapiLogonEx Failed"

    any help is much appreciated.

     

     

  • is the domain\user a member of local admin ?

    MVDBA

  • see the micorosfoft page

    http://support.microsoft.com/default.aspx?scid=kb;en-us;834124

    this has all the details - you're having problems running xp_logininfo system stored procedure - this could be down to SQL permissions, but it ocurs in a lot of circumstances (where there are domain crossovers with no trust)

    MVDBA

  • The account used (domain\user) is a member of local admin too. In fact tried, domain\administrator too.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply