| Author |
Topic |
|
pcnetnet
Starting Member
7 Posts |
 Posted - 2007-07-15 : 07:00:51
|
| Hi All, I try setup SQL mail in SQL 2000, but cannot send mail, i try send testing mail from sql server , testing message is success , but i need stop the sql agent and then open the outlook 2003 click send , then the testing mail is send , so the SQL server cannot auto send ????? why ???? i think is outlook hold the mail , how to set ??? Thanks |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-15 : 07:33:10
|
| you need to configure outlook en sql mail under the sqlservice account in windows, else you get it not worked, ive got about 14 sqlservers wich are generating auto mails but thats over exchange, i don't know what you use., try reinstall outlook, and configure sql mail under the sqlservice account.Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
pcnetnet
Starting Member
7 Posts |
Posted - 2007-07-15 : 10:14:12
|
| Thanks ! i use pop3 account connect to mail server , i use the sql server service account access the outlook , because start the agent , i cannot open the outlook , the error is cannot access the pst file , when i stop the sql agent , i can open outlook and send the pending mail ???? why ???? THANKS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-15 : 20:49:31
|
| You need create mail profile for sql agent service account on sql server. |
|
|
|
pcnetnet
Starting Member
7 Posts |
Posted - 2007-07-15 : 23:12:23
|
| i have mail profile for SQL , i logon to admin account (this account also for agent startup) , control panel -> mail , create the profile , and in sql server choose this profile, ??? thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-16 : 22:48:45
|
| Is it domain account? |
|
|
|
pcnetnet
Starting Member
7 Posts |
Posted - 2007-07-17 : 01:52:20
|
| no the account is local administrator |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2007-07-17 : 02:50:37
|
| To run SQL Mail, you will have to run SQL server and Agent under domain account.http://support.microsoft.com/kb/263556ThanksSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
pcnetnet
Starting Member
7 Posts |
Posted - 2007-07-19 : 09:00:25
|
| sqlservre and sqlangent as same domain account ? or not ? |
|
|
|
|
SQL Mail