SQL Mail Agent Error, Trying To Set Up

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

arbert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

roshkm

How to Use CDO for Microsoft Windows NT Server (CDONTS) for sending email from SQL Server:

http://support.microsoft.com/view/tn.asp?kb=312839

OR You can go for creating a VBScript for sending and recving emails. Copy the follwoing and save as .vbs file.

Set objEmail = CreateObject("CDO.Message")
objEmail.From = "sender@mail.com"
objEmail.To = "Recv@mail.com"
objEmail.Subject ="Subject on " & now()
objEmail.HTMLBody = strHTML
objEmail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

'Your mailserver address
objEmail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "mail.hotmail.com"
objEmail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objEmail.Configuration.Fields.Update
objEmail.Send

Call the VBScript using XP_CMDShell / Write as a job/ Windows scheduled job.

Regards,
RKM

ASKER

Jaffa and Arbert,

I have followed those two articles and have done as instructed.
I can set up the profile and test it and it works...

However, I am getting that wierd error message and need to know how I can fix it.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I am running service pack 3

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Please read my original message for the answer to this.

Thanks.

"proper" = domain account ?

ASKER

I set it up to use the Administrator login for the machine and to use a pop3 for the profile...

Administrator on local machine ?

It needs to be a domain account.

ASKER

It has to be a domain account even with pop3? I don't have a domain account with admin rights... does that matter? Or can I just add that user name to the admin group on the local machine?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I have read that article in my research before... thanks for trying though.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Yes.

I'm not sure what else to look for. You might want to use that white paper to double check the settings. it must be an authentication issue. Do you have an exchange server you can try, rather than pop3 ?

ASKER

Yes, I have exchange but it says you have to have the domain login match the exchange login... which I don't have.

I would definitely try to acquire it. There isn't nearly as much documentation on setting up pop3 as I'm sure you have found out. What are the odds of you getting that information ?

ASKER

Less than 1% :)

I work for a huge company and getting admin rights let alone a domain email box would be impossible.
I am also using SQL Server Personal Edition its not even a real server. :)

SOLUTION

arbert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Ok, I was getting SQL Mail and SQLAgent Mail confused. I was able to get the operator set up by setting the profile in the SQL Agent Mail instead of trying to use the SQL Mail. I'm not sure how to allocate points on this...

JaffaKREE 499
Arbert 1

arbert

"JaffaKREE 499
Arbert 1"

Aren't you silly...Give them to Jaffa, it's apparent he's more deserving (just look at the previous post)