首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of several SQL Server 2000 computers. You configure these servers to send e-mail messages to SQL Serve
You are the administrator of several SQL Server 2000 computers. You configure these servers to send e-mail messages to SQL Serve
admin
2009-05-19
14
问题
You are the administrator of several SQL Server 2000 computers. You configure these servers to send e-mail messages to SQL Server operators whenever a SQL server agent job fails or encounters an error.
Your company’s software developers create a set of stored procedures that send query results in email messages about stored procedures that have not been successful.
By using a MAPI profile named MS Exchange Settings, you verify that SQLAgentMail is correctly configured and working properly. You need to configure the servers so that the stored procedures function correctly. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)
A. Set the security permissions on your e-mail server to permit multiple connections to the SQL Server mailbox.
B. Set the security permissions on your e-mail server to permit connections from the MSSQLServer service account.
C. Configure the MSSQLServer service to use the same service account as the SQLServerAgent service.
D. Configure the SQLServerAgent service to use the same service account as the MSSQLServer service.
E. Configure SQL Mail to use the MS Exchange Settings MAPI profile.
F. Configure SQL Mail to use the Default Settings MAPI profile.
选项
答案
C,E
解析
Explanation:
C: SQL Mail provides a way to receive e-mail messages generated by SQL Server 2000. Messages can be triggered to provide information about the status of a job or a warning caused by an alert. SQL Mail can include a result set in a reply to e-mail messages that contain queries and allows SQL Server to send and receive e-mail by establishing a client connection with a mail server. However, SQL Mail must have a mail profile created in the same user domain account or context that is used to start an instance of SQL Server 2000, i.e. it must use the same domain account that is used by the SQLServerAgent service, as it looks for the defined mail profile in the domain account that triggered the e-mal message.
E: It must also have a mail server that is extended MAPI-compliant and must be configured to use a valid MAPI profile. In this scenario we know that a MAPI profile named MS Exchange Settings works correctly with SQLAgentMail. The servers must also be configured to use the MS Exchange Settings MAPI profile.
Incorrect Answers:
A, B: There is no need to set any security permissions on your e-mail server.
D: The MSSQLServer isn’t running. MSSQLServer should be configured to use the same account as the SQLServerAgent service (which is running), not the opposite way around.
F: There is no guarantee that a default settings MAPI profile would work. We must us the MS Exchange Settings MAPI profile since we know that it work with SQLAgentMail.
转载请注明原文地址:https://kaotiyun.com/show/3uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Writealettertoamuseum’sstafftoaskforsomeinformationaboutahistoricalexhibition.Youshouldincludethedetailsyou
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
Bobisanewsecurityadministratoratafinancialinstitution.Theorganizationhasexperiencedsomesuspiciousactivityonone
随机试题
TCP的连接拆除需要经过【】次握手过程。
一横贯性脊髓病变患者,在乳头平面以下出现浅感觉障碍,查体还可发现哪些体征
钱某,女,25岁,某公司员工。患者1年前无明显诱因出现尿频、尿急、尿痛,遂到当地医院就诊。服用药物4天后症状消失,半年前上述症状复发,经治疗,症状消失。8天前患者又出现尿频急,溺时灼热刺痛,淋沥不畅,频数短涩,溺色浑赤,小腹拘急胀痛,口燥咽干,舌苔黄腻,脉
[2010年第85题]设计单位超越其资质等级或以其他单位名义承揽建筑设计业务的,除责令停止违法行为、没收违法所得外,还要处合同约定设计费多少倍的罚款?
全淹没灭火系统的灭火剂设计浓度不得小于()。
关于借款人的权利,下列表述错误的是()。
下列有关城市维护建设税的表述中,正确的有()。(2009年原制度)
下列法律渊源中,属于不成文法的有()。(2011年真题)
Waterisakindofchemicalsubstance.
Smoking,whichmaybeapleasureforsomepeople,isaseruioussourceofdiscomfortfortheirfellows.【C1】______,medicalautho
最新回复
(
0
)