首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
46
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Imaginativeworkssuchasnovels,plays,films,fairytales,andlegendspresentamoreaccurateandmeaningfulpictureofhuman
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
简述《学记》的思想。
患儿3岁,近1年多,哭甚时出现青紫,查体,心前区隆起,胸骨左缘第3~4肋间可闻及Ⅳ级收缩期杂音,可触及震颤,X线检查示:左右心室及左房增大.肺血管影增多.肺动脉段凸出此患儿最可能的诊断是
最易发生变异而在人群中造成流行的病原微生物是
A.化湿,解暑,止呕B.行气,燥湿,消积,平喘C.化湿行气,温中止呕D.化湿行气,温中止呕,止泻,安胎E.燥湿健脾,祛风湿厚朴的功效是
以下关于Excel的叙述中错误的是()。
设备大修理成本经济分析指标有()。
市场风险内部模型法的局限性不包括()。
根据民法通则和相关司法解释的规定,能够引起诉讼时效中断的法定事由是()。
面向数据流的设计方法可以直接把数据流图映射成软件结构。对于变换流,除了输入模块、变换模块和输出模块外还需要一个()。
设循环队列为Q(1:m),其初始状态为front=rear=m。经过一系列入队与退队运算后,front=15,rear=20。现要在该循环队列中寻找最大值的元素,最坏情况下需要比较的次数为()。
最新回复
(
0
)