Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-04-30 : 01:53:18
|
| hi,Very New to SQL MAIL... SQL SERVER 2005....I am trying to set sql mail for my SQL server 2005.. i m on client machine...from here i got info for @@versionMicrosoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)I have created alerts (TestAlert),operator (TestOperator.. here i have mentioned my email id)I have created simple JOB ..insert statement...owner as NT AUTHORITY\SYSTEM...under alert I assigned TestAlert..under notification I assinged or checked my TestOperator...click okI also checked in Service Area Configuration Features .. Enable SQL Mail Stored Procedures...But when i loggned in Query Analyser as Windows Login and fired EXEC xp_startmail I got error likeMsg 17930, Level 16, State 1, Line 0xp_startmail: 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.Also Under Legacy..SQL MAIL..when i right click I got error TITLE: Microsoft SQL Server Management Studio------------------------------Cannot show requested dialog.------------------------------ADDITIONAL INFORMATION:If a stored procedure could not be found, SQL Mail may not be installed in the instance. (SqlManagerUI)------------------------------xp_get_mapi_profiles: 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. (Microsoft SQL Server, Error: 17930)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=17930&LinkId=20476------------------------------BUTTONS:OK------------------------------On my machine (its client machine) Outlook is configured but on server it is not....Please suggest me best way to set SQL MAIL....I needed to set notification when any job executed as success....T.I.A |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-30 : 10:29:26
|
| What about DBmail? configure outlook express in server as well. We use DBmail . |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-04-30 : 15:15:56
|
| I agree with sodeep. Using DBMail in SQL2005 is the way to go. Easier to configure as well. |
|
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-05-02 : 02:11:05
|
| Hi,You mean I need to configure Outlook in server also??? :(I need to contact my system admin ::(Thanks any way for your help :) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 20:30:06
|
| Dbmail doesn't need outlook, it uses smtp mail. |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2008-05-07 : 04:53:58
|
| first check whether the service is started under ur account...go to services.msc in start-run dialog box. go to mssqlserver serivice and u have a log on account .. try to restart the service and then configure mail profile in sql server ... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 15:44:04
|
| Dbmail doesn't require specific sql startup account, but smtp mail server may need domain account. |
|
|
|
|
|
|
|
|
SQL Server 2005 Mail Issues???