MS SQL Server - SQL Server 2000 and Outlook 2003

Author

SQL Server 2000 and Outlook 2003

Mike Trebilcock

2005-06-30, 3:23 am

I have recently upgraded my server from Win 2K to Win 2K3 this included
upgrading office to 2K3 as well. The upgrade involved a rebuild of the
server.

Now when I try to setup the mail in Sql Server Agent the mail profile drop
down is remaining greyed out. I use a domain account with an associated
email account. I have logged onto the server with that account setup
outlook and tried to configure Sql Server using that account, but still the
same result.

Is there an isssue with using Outlook 2003? Or an issue with my Server!
Its driving me mad.

Thanks in anticipation.

Mike

Jens Süßmeyer

2005-06-30, 7:23 am

Don´t know ehere the issue is located, but that shoulod help you further, as
it helps in 99 % of the cases:

http://support.microsoft.com/kb/897349/en-us

http://support.microsoft.com/defaul...;315886&sd=tech

HTH, Jens Suessmeyer.

"Mike Trebilcock" <tiger@trebilcock.net> schrieb im Newsbeitrag
news:uPtJE7UfFHA.1480@TK2MSFTNGP10.phx.gbl...
>I have recently upgraded my server from Win 2K to Win 2K3 this included
> upgrading office to 2K3 as well. The upgrade involved a rebuild of the
> server.
>
> Now when I try to setup the mail in Sql Server Agent the mail profile drop
> down is remaining greyed out. I use a domain account with an associated
> email account. I have logged onto the server with that account setup
> outlook and tried to configure Sql Server using that account, but still
> the
> same result.
>
> Is there an isssue with using Outlook 2003? Or an issue with my Server!
> Its driving me mad.
>
> Thanks in anticipation.
>
> Mike
>
>

Mike Trebilcock

2005-06-30, 7:23 am

Thanks for the quick reply. I have read the pages but do not think they
apply to me.

All email goes through the exchange server in an enterprise environment.
POP3 and SMTP don't come in to it (I think). But I am not getting as far as
being able to sent mails.

My problem is that Sql is not picking up the outlook mail profile. I have
checked that it exists with Control Panel and as I said logged in with the
account and sent and received mail to ensure the account was properly set
up.

Mike
"Jens Süßmeyer" < Jens@Remove_this_For
_Contacting.sqlserver2005.de> wrote in
message news:umCLfJVfFHA.3260@TK2MSFTNGP10.phx.gbl...
> Don´t know ehere the issue is located, but that shoulod help you further,
as
> it helps in 99 % of the cases:
>
> http://support.microsoft.com/kb/897349/en-us
>
> http://support.microsoft.com/defaul...;315886&sd=tech
>
> HTH, Jens Suessmeyer.
>
>
> "Mike Trebilcock" <tiger@trebilcock.net> schrieb im Newsbeitrag
> news:uPtJE7UfFHA.1480@TK2MSFTNGP10.phx.gbl...
drop[color=darkred]
>
>

Mike Trebilcock

2005-06-30, 7:23 am

PROBLEM SORTED!!

I read the webcast relating to SQL Mail problems and found the answer.

It turns out that MAPI.dll that is in the system32 folder was a different
version from the one in program files\common files\system\msmapi\
1033. I
copied the version outlook was using in the 1033 folder to the system32
folder, restarted Sql Server agent and Bobs your uncle it found the profile.

Link to the webcast:

http://support.microsoft.com/defaul...kb;en-us;324689

Its best to read the transcript.

Thanks for the help

Mike

Bloody computers : )
"Mike Trebilcock" <tiger@trebilcock.net> wrote in message
news:OO1HrcVfFHA.3124@TK2MSFTNGP12.phx.gbl...
> Thanks for the quick reply. I have read the pages but do not think they
> apply to me.
>
> All email goes through the exchange server in an enterprise environment.
> POP3 and SMTP don't come in to it (I think). But I am not getting as far
as
> being able to sent mails.
>
> My problem is that Sql is not picking up the outlook mail profile. I have
> checked that it exists with Control Panel and as I said logged in with the
> account and sent and received mail to ensure the account was properly set
> up.
>
>
> Mike
> "Jens Süßmeyer" < Jens@Remove_this_For
_Contacting.sqlserver2005.de> wrote
in
> message news:umCLfJVfFHA.3260@TK2MSFTNGP10.phx.gbl...
further,[color=darkr
ed]
> as
the[color=darkred]
> drop
associated[color=dar
kred]
still[color=darkred]

Server![color=darkre
d]
>
>

Sponsored Links