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 |
|
mcmcom
Starting Member
9 Posts |
 Posted - 2008-01-29 : 10:08:29
|
| Hi allrunning SQL Server 2000 on Win 2000 Servers (got two of them)I need to install some mail support because im having disk space issues lately. Anyways i have a smtp server on this network ready to go but i am having quite a time getting mail profiles hooked up.i tried the following1. Control Panel > Mail (oops no mail icon there)2. Installed outlook express and created a mail profile (still no mail icon in cp)3. Went back to Ent manager. Support Services > SQL Agent Mail - still cant see any profiles i created on the computer.i read somewhere i need Outlook 2000 or better to work with SQL Server 2000 is this true? My servers do not run office (as they are database servers) do i need to purchase Outlook 2K just to get simple Mail alerts set up? Any alternatives or workarounds? TIA,mcm |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-29 : 10:39:17
|
| nope that's what you have to do... install outlook...you might create a windows service that you install on your db servers that performs the checks and sends emails using SMTP._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2008-01-29 : 12:46:54
|
| One option to send mail without using Sql Mail is by cdosys mail. And if you want your sql mail working, you need MS Outlook installed (not outlook express).Donn Policarpio |
|
|
|
|
|
|
SQL Agent Mail + Outlook 2000 only ?