Mail Fails with SQLCMD Error

Question

Mail Fails with SQLCMD Error

ramya.sqlservr

Ten Centuries

Points: 1068
More actions
March 19, 2015 at 12:01 am

#302095

Comments posted to this topic are about the item Mail Fails with SQLCMD Error

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

farhana.samad SSC Journeyman Points: 77 More actions · Answer 1

The Database Mail Profile that is used for the SQL server agent need to be a member of DatabaseMailUserRole in the msdb database.

https://msdn.microsoft.com/en-us/library/ms186358.aspx#Security

ramya.sqlservr Ten Centuries Points: 1068 More actions · Answer 2

You are right. I might have missed this point in the article - the problem here is the job worked fine when run on other databases (master,msdb etc.,) but failed only when run on user database. That's the reason it took a bit of time to narrow down the issue.

TheComedian SSCrazy Points: 2932 More actions · Answer 3

If your service account didn't have the permissions to access your database, wouldn't other jobs be failing as well? Or is this the only time you access this specific DB?

ramya.sqlservr Ten Centuries Points: 1068 More actions · Answer 4

I was setting up a new server and this was the only job accessing the user database at that point of time. When I was making sure all the setup was done properly, I encountered this issue.

Thanks,

Ramya

Don Shoemaker SSC Enthusiast Points: 160 More actions · Answer 5

I am having a new issue that is similar. However, mine appears to be unrelated to SQLAgent. My query fails when executing in SSMS. This is on a two instance install of SQL 2014, with the query working fine on Instance 1 but failing on Instance 2 . I have confirmed this on a separate dual instance installation of SQL 2014. I get "Failed to initialize sqlcmd library with error number -2147024809".

Thoughts?

ramya.sqlservr Ten Centuries Points: 1068 More actions · Answer 6

Are both the servers running on same service account? Could you please paste the query that is giving this error?

Thanks!

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 7

Thanks Buddy. Profiler suggestion helped me a lot. 🙂

Thank You.

Regards,
Raghavender Chavva

Dana Medley SSCertifiable Points: 6764 More actions · Answer 8

Thanks for this. I know this is an older article, but it just saved my bacon.

Everything is awesome!

SQL-DBA Hall of Fame Points: 3051 More actions · Answer 9

The MSSQL certification exams spend a huge amount of time explaining NUMA nodes, but they don't mention THIS! Thank you for pointing this out.

noovanoova Grasshopper Points: 11 More actions · Answer 10

thx for this.

This reply was modified 2 years, 1 month ago by noovanoova.