July 18, 2004 at 10:11 pm
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.
July 19, 2004 at 5:08 am
is the domain\user a member of local admin ?
MVDBA
July 19, 2004 at 5:13 am
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
July 19, 2004 at 4:39 pm
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