Link to home
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)Flag for United States of America

asked on

Configuring SMTP in CR XI scheduled object

CR XI
i am trying to use the CMC to schedule a report to run and be sent to me via email.

i have successfully added the report object, tested and verified that the report runs ok in preview.  i am having problems configuring CR to use SMTP.  SMTP is installed and running on my test computer (XP MCE, SP2)

here is the error i see in the scheduler:
 Error Message:  server error. SMTP_E_TCPSOCKET_OPEN(2): CrystalEnterprise.Smtp

i am pretty sure the problem is with the Server config in CMC.  i have enabled SMTP in both Destination Job Server and Crystal Reports Job Server.  in both of those, on the Properties tab, i have the following:
domain name: <same name that shows up under IIS SMTP domains, which happens to be the name of my test computer>
server: Default SMTP Virtual Server
port: 25
authentication: login   (i changed this setting from None to Login as a recommendation given here:
http://www.forumtopics.com/busobj/viewtopic.php?p=340625)
SMTP user name: <blank>
SMTP password: <blank>
From: <external email address>
To: <blank>


i don't think the other settings will make a difference...
under the Object settings, in the scheduling tab, i have changed it from using the default job server settings to:
From: <same external email address as above>
To: <my external email address>

what settings should i be checking to resolve the error?
thanks
Avatar of harperse
harperse
Flag of United States of America image

Check the port number that SMTP is running on, both on your test server and in CR.  Also, check to make sure the account running your Job Server has write access to C:\<systemroot>\system32.

Best of luck,
harperse
Avatar of zephyr_hex (Megan)

ASKER

i have checked SMTP by telnetting to port 25 and i was able to successfully send an email to my account.
in CMC, i did not change the default port... it is still 25

the account running the job server has write access to system32.  it is a local Administrator.
ok, i have the problem resolved.

the issue was the server name in the Destination settings of the CMC report object and destination object servers.  i had:  Default SMTP Virtual Server
as the name of the SMTP server (which is the name that shows in IIS).  i'm not sure if that requires quotes around it or what... but i replaced the name with the IP address of the SMTP server and it worked.
ASKER CERTIFIED SOLUTION
Avatar of Vee_Mod
Vee_Mod
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial