2. 计算机
  3. 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

admin2009-05-19  41
问题 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

微软认证

相关试题推荐
随机试题
最新回复(0)