Upgrade 5.5 to 2003

  • Ok your going to have to bare with me I am a programmer and our infrastructure boys have updated exchange and now are Xp_mail is failing. and they have no solution and are SQL expert is away on holiday I have a very basic understanding but we have servers split over a couple of domains, the error is:-

    xp_sendmail: failed with mail error 0x80070005

    Microsoft say Configure the SQL Mail profile to use the default mailbox of the domain account used

    to start Microsoft SQL Server services.

    Sorry but how do I do this? is there anything else I need to do?

    Thanks

  • You should find that there is an outlook client installed on the sql server box.

    The mail profile it uses should be setup in there just modify this profile to use your new servers.

    This article explains in more detail

    http://support.microsoft.com/kb/263556/

    hth

    david

Viewing 2 posts - 1 through 2 (of 2 total)

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