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 |
|
shan1430
Yak Posting Veteran
86 Posts |
 Posted - 2008-03-30 : 22:55:46
|
| Hi, i need to send emails from sql server. to configure the setting i need to open database mail configuration windows right? But i dont have database mail icon or tab under management folder. I only have archieve under server roles. Help me.. Urgent.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-30 : 23:29:01
|
| Are you in sql2k5? Sql2k5 express doesn't have db mail. |
 |
|
|
shan1430
Yak Posting Veteran
86 Posts |
Posted - 2008-03-31 : 00:27:24
|
| ya im using sql 2005. then how to configure my setting? thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 00:34:24
|
| 1) Tell your network guys to install SMTP in your server if you don't have any.2) Go to SQL surface area config - Enable Database Mail.3) Configure outlook express or any mail services and test.4) Go to Sql Server agent properties and enable database mail5) Go to management- Database mail- Configure database mail6) setup profile( Let me know if any probs) 7) You have to restart SQL server agent if you are running any jobs and sending email. |
|
|
|
shan1430
Yak Posting Veteran
86 Posts |
Posted - 2008-03-31 : 01:43:50
|
| where do i find server agent? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 09:26:39
|
| SQL 2005 Express edition doesn't Support SQL Server agent. |
|
|
|
shan1430
Yak Posting Veteran
86 Posts |
Posted - 2008-03-31 : 21:54:20
|
| i dont understand. when sql 2005 doesnt support all this, then how to 4) Go to Sql Server agent properties and enable database mail5) Go to management- Database mail- Configure database mail??Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 23:36:02
|
| Looks like you don't know what you have, run 'selsct @@version' and post result here. |
|
|
|
|
|
|
database mail