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 |
|
markm
Starting Member
2 Posts |
 Posted - 2003-10-18 : 10:21:46
|
| Hello, I have a Windows 2003 Enterprise server, acting as the primary domain controller, with SQL Server 2000 Enterprise, Active Directory, and Exchange 2003 running on it. Both sql server and sql server agent use the same domain startup account. I set up a mail profile for both sql server and sql server agent. I used this profile to configure SQL Mail and everything is working properly. However, when I try to configure the sql server agent in EM using the sql server agent properties dialog box under the general tab, the mail session group box is grayed out. I tried creating a mail profile just for sqlagentmail, but under EM, the mail session/mail profile input box is still grayed out. Please tell me what I need to do to get sqlagentmail working. Thanks, Mark |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-19 : 00:18:55
|
quote:
Originally posted by markm
Hello, I have a Windows 2003 Enterprise server, acting as the primary domain controller, with SQL Server 2000 Enterprise, Active Directory, and Exchange 2003 running on it.
That configuration is highly not recommended.quote:
Originally posted by markm
Both sql server and sql server agent use the same domain startup account. I set up a mail profile for both sql server and sql server agent. I used this profile to configure SQL Mail and everything is working properly. However, when I try to configure the sql server agent in EM using the sql server agent properties dialog box under the general tab, the mail session group box is grayed out. I tried creating a mail profile just for sqlagentmail, but under EM, the mail session/mail profile input box is still grayed out. Please tell me what I need to do to get sqlagentmail working.
Did you follow everything in this article?:[url]http://support.microsoft.com/support/kb/articles/Q263/5/56.asp[/url]Tara |
 |
|
|
markm
Starting Member
2 Posts |
Posted - 2003-10-21 : 19:17:01
|
quote:
Originally posted by tduggan
quote:
Originally posted by markm
Hello, I have a Windows 2003 Enterprise server, acting as the primary domain controller, with SQL Server 2000 Enterprise, Active Directory, and Exchange 2003 running on it.
That configuration is highly not recommended.
Could you please explain to me why this configuration is highly not recommended?quote:
Originally posted by markm
Both sql server and sql server agent use the same domain startup account. I set up a mail profile for both sql server and sql server agent. I used this profile to configure SQL Mail and everything is working properly. However, when I try to configure the sql server agent in EM using the sql server agent properties dialog box under the general tab, the mail session group box is grayed out. I tried creating a mail profile just for sqlagentmail, but under EM, the mail session/mail profile input box is still grayed out. Please tell me what I need to do to get sqlagentmail working.
quote:
Originally posted by tdugganDid you follow everything in this article?:[url]http://support.microsoft.com/support/kb/articles/Q263/5/56.asp[/url]Tara
Yes I have. Under the heading "How To Set Up SQL Mail With Exchange" is the sentence "If you are using SQL Server 7.0 or SQL Server 2000, also configure SQLAgentMail with the same profile. You can test SQLAgentMail by sending mail to an operator." I did this and SQL Mail is working, but I cannot choose this or any mail profile under SQL Server Agent properties. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-21 : 19:50:39
|
| SQL Server is a memory hog. Any other applications running on it could and probably will suffer in performance. SQL Server will also suffer in performance because the other applications will be taking memory that SQL Server needs. Even if you add memory to the box to account for this, it is still not recommended. I don't think that it is recommended to run Active Directory and Exchange together either. All 3 of those should be separate boxes. If cost is an issue, you should consider buying cheaper boxes for AD and Exchange.Tara |
|
|
|
|
|
|
|
|
SqlAgentMail - unable to select mail profile