March 27, 2013 at 3:06 pm
I' running SQL server 2008R2.
I have a C# app that accesses a database and then constructs and sends an email based on the info. Outlook is used to send the email.
I created an SSIS job to run this on a schedule. The app would get an error sending the email when I started it from the 'job' tab in SQL server agent, even if I signed on as the SSIS job owner. So I created a PROXY/credentials (PROXY uses an id that has access to the OUTLOOK profile I'm using to create the email) and set the SSIS job to 'run as' the PROXY. This worked and when I start the SSIS job (from SQL Server Agent) when I am signed in as the owner of the job, the emails get sent. However, if I try to start it when I'm signed on as a different user (that does have access to the OUTLOOK profile,) the app errors. I also receive the same error if the job is started using the scheduler.
The error is "Error in Outlook logon: The server is not available."
First tme asking a question here so hopfully I'm m aking sense.
March 27, 2013 at 5:11 pm
Login to the server using SQL Agent account. Open the outlook default profile and save.
Ensure that you are using the same profile in SQL Mail property.
Now let the job run under Agent Account.
Seraj Alam
March 28, 2013 at 11:40 am
Thx. I'll know tomorrow if it worked. B
March 29, 2013 at 10:05 am
Thx. Couldn't get it to work. I have to use a specific profile for outlook to send the emails.
I'll probably just rewrite.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply