|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL MailRunning SQL 2000 sp4 on W2003 server. Trying to get SQL Mail to run.
Installed Outlook 2000 and setup my profiles as Internet POP3. I can send mail fine from Outlook. In SQL no profiles are found. In SQLAgent the Mail section is greyed out. Server login, SQL service, and SQLAgent service are all the same user (an admin on the local machine). Get error Msq: 18030 either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. I have setup Outlook as the default mail client in Explorer. I have deleted and reinstalled profile many times and restart services. No luck. Any ideas? Thanks Gary Angus When configuring Outlook on the box you have to log in as the user that the
SQL Server is running under. That will allow SQL Server to "see" the profile. An alternative to SQL Mail is sp_smtp_sendmail. You can find it here: http://www.sqldev.net/xp/sp_smtp_sendmail.htm -- Show quoteKeith Kratochvil "Gary Angus" <g***@rtt-law.com> wrote in message news:e5wYkp%23OGHA.984@tk2msftngp13.phx.gbl... > Running SQL 2000 sp4 on W2003 server. Trying to get SQL Mail to run. > Installed Outlook 2000 and setup my profiles as Internet POP3. I can send > mail fine from Outlook. In SQL no profiles are found. In SQLAgent the > section is greyed out. Server login, SQL service, and SQLAgent service > are > all the same user (an admin on the local machine). Get error Msq: 18030 > either there is no default mail client or the current mail client cannot > fulfill the messaging request. Please run Microsoft Outlook and set it as > the default mail client. I have setup Outlook as the default mail client > in Explorer. I have deleted and reinstalled profile many times and > restart > services. No luck. Any ideas? > > Thanks > Gary Angus > > Have done all that and still no profile shows up. The Server user, sql
agent and sql all use the same account. I have a third party app that requires the agent mail to function. Thanks Gary Show quote "Keith Kratochvil" <sqlguy.bac***@comcast.net> wrote in message news:%231jORL$OGHA.516@TK2MSFTNGP15.phx.gbl... > When configuring Outlook on the box you have to log in as the user that the > SQL Server is running under. That will allow SQL Server to "see" the > profile. > > An alternative to SQL Mail is sp_smtp_sendmail. You can find it here: > http://www.sqldev.net/xp/sp_smtp_sendmail.htm > > > -- > Keith Kratochvil > > > "Gary Angus" <g***@rtt-law.com> wrote in message > news:e5wYkp%23OGHA.984@tk2msftngp13.phx.gbl... > > Running SQL 2000 sp4 on W2003 server. Trying to get SQL Mail to run. > > Installed Outlook 2000 and setup my profiles as Internet POP3. I can send > > mail fine from Outlook. In SQL no profiles are found. In SQLAgent the > > section is greyed out. Server login, SQL service, and SQLAgent service > > are > > all the same user (an admin on the local machine). Get error Msq: 18030 > > either there is no default mail client or the current mail client cannot > > fulfill the messaging request. Please run Microsoft Outlook and set it as > > the default mail client. I have setup Outlook as the default mail client > > in Explorer. I have deleted and reinstalled profile many times and > > restart > > services. No luck. Any ideas? > > > > Thanks > > Gary Angus > > > > > > Got it, thanks. Login was AD account, service was local account.
Gary Angus Show quote "Keith Kratochvil" <sqlguy.bac***@comcast.net> wrote in message news:%231jORL$OGHA.516@TK2MSFTNGP15.phx.gbl... > When configuring Outlook on the box you have to log in as the user that the > SQL Server is running under. That will allow SQL Server to "see" the > profile. > > An alternative to SQL Mail is sp_smtp_sendmail. You can find it here: > http://www.sqldev.net/xp/sp_smtp_sendmail.htm > > > -- > Keith Kratochvil > > > "Gary Angus" <g***@rtt-law.com> wrote in message > news:e5wYkp%23OGHA.984@tk2msftngp13.phx.gbl... > > Running SQL 2000 sp4 on W2003 server. Trying to get SQL Mail to run. > > Installed Outlook 2000 and setup my profiles as Internet POP3. I can send > > mail fine from Outlook. In SQL no profiles are found. In SQLAgent the > > section is greyed out. Server login, SQL service, and SQLAgent service > > are > > all the same user (an admin on the local machine). Get error Msq: 18030 > > either there is no default mail client or the current mail client cannot > > fulfill the messaging request. Please run Microsoft Outlook and set it as > > the default mail client. I have setup Outlook as the default mail client > > in Explorer. I have deleted and reinstalled profile many times and > > restart > > services. No luck. Any ideas? > > > > Thanks > > Gary Angus > > > > > > Excellent!
-- Show quoteKeith Kratochvil "Gary Angus" <g***@rtt-law.com> wrote in message news:OJOc6QHPGHA.1088@tk2msftngp13.phx.gbl... > Got it, thanks. Login was AD account, service was local account. > > Gary Angus > "Keith Kratochvil" <sqlguy.bac***@comcast.net> wrote in message > news:%231jORL$OGHA.516@TK2MSFTNGP15.phx.gbl... >> When configuring Outlook on the box you have to log in as the user that > the >> SQL Server is running under. That will allow SQL Server to "see" the >> profile. >> >> An alternative to SQL Mail is sp_smtp_sendmail. You can find it here: >> http://www.sqldev.net/xp/sp_smtp_sendmail.htm >> >> >> -- >> Keith Kratochvil >> >> >> "Gary Angus" <g***@rtt-law.com> wrote in message >> news:e5wYkp%23OGHA.984@tk2msftngp13.phx.gbl... >> > Running SQL 2000 sp4 on W2003 server. Trying to get SQL Mail to run. >> > Installed Outlook 2000 and setup my profiles as Internet POP3. I can > send >> > mail fine from Outlook. In SQL no profiles are found. In SQLAgent the >> > section is greyed out. Server login, SQL service, and SQLAgent >> > service >> > are >> > all the same user (an admin on the local machine). Get error Msq: >> > 18030 >> > either there is no default mail client or the current mail client >> > cannot >> > fulfill the messaging request. Please run Microsoft Outlook and set it > as >> > the default mail client. I have setup Outlook as the default mail > client >> > in Explorer. I have deleted and reinstalled profile many times and >> > restart >> > services. No luck. Any ideas? >> > >> > Thanks >> > Gary Angus >> > >> > >> >> > > Take a look at http://www.sqldev.net/xp/xpsmtp.htm
-- Show quoteKeith Kratochvil "Gary Angus" <g***@rtt-law.com> wrote in message news:e5wYkp%23OGHA.984@tk2msftngp13.phx.gbl... > Running SQL 2000 sp4 on W2003 server. Trying to get SQL Mail to run. > Installed Outlook 2000 and setup my profiles as Internet POP3. I can send > mail fine from Outlook. In SQL no profiles are found. In SQLAgent the > section is greyed out. Server login, SQL service, and SQLAgent service > are > all the same user (an admin on the local machine). Get error Msq: 18030 > either there is no default mail client or the current mail client cannot > fulfill the messaging request. Please run Microsoft Outlook and set it as > the default mail client. I have setup Outlook as the default mail client > in Explorer. I have deleted and reinstalled profile many times and > restart > services. No luck. Any ideas? > > Thanks > Gary Angus > >  |
|||||||||||||||||||||||
Other interesting topics