首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
50
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Writeane-mailofabout100wordstoaforeignteacherinyourcollege,invitinghim/hertobeajudgefortheupcomingEnglish
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
Whateverhappenedtothedeathofnewspaper?Ayearagotheendseemednear.Therecessionthreatenedtoremovetheadvertising
随机试题
报表系统中,QM()函数代表的意思是()。
通过调动或晋升,激发下级进取心、责任感的激励方法称为()激励。[2005年真题]
无风险收益率的大小由纯粹利率和通货膨胀补贴两部分组成。()
下列公民实施的民事行为有效的是()。
下列何项属于行政处罚()。
2012年7月31日,国务院新闻办公室在北京举行建军85周年新闻发布会。国防部新闻事务局局长、国防部新闻发言人耿雁生,总参应急办公室副主任吴喜铧,总政办公厅政研室副主任王永胜,总后司令部战勤计划局局长贾祥玉,总装综合计划部综合局副局长林柏,围绕“中国军队是
根据所给材料。回答以下问题。“我负了爱我自己的生物/我却温了你的眼睛/我生了时代的心/我将说出我的眼泪/无限一切的生物/也没望见来复苏的大地/世界悲剧的角色/那时候的人们。”这篇名为《世界悲剧的角色》的诗歌出自人工智能“小冰”。据了解,它还“写”了一部
根据宗教改革的结果,简述欧洲民族教会的特征(以英国为例)
第三代数据库系统是指把()技术与数据库技术相结合的数据库系统。
John:Whatplasticproductsdoyouhaveinmindthatareeasytorecycle?Tom:Shampoobottles,detergentbottles,medicinebott
最新回复
(
0
)