|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hello all,
I am having a problem trying to send an email using SQL MS RS. I have the web sites in one server and the DB in another DB. I have a domain account running ReportServer service and the SQLAgent (same account for both services.) I have windows integrated and impersonate in true. I have UNselected Anonymous in IIS. I have only windows integrated. When I create a new subscription, the job is created in the SQL correctly. It sets as the owner the ReportServer services account and in the Subscriptions table is saves the credentials passed by IIS in the OwnerID column. The Job runs fine and an Entry is added to the Event table. But then, I don't know what else is done but the Credentials saved in the OwnerID are verified against windows (this is after the jobs has ran and completed successfully). Then, there is a line like this: Event Class: SQL:BatchStarting TextData: EXECUTE msdb.dbo.sp_sqlagent_has_server_access @login_name = N'DOMAIN\LOGIN' ApplicationName: SQLAgent - Job Manager NT User Name: ntservices LoginName: <DOMAIN>\ACCOUNT which is throwing an error. Then the email is not sent. I found this info regarding the error this is returning: http://sqlteam.com/forums/topic.asp?TOPIC_ID=18553 http://support.microsoft.com/?kbid=834124#3 http://support.microsoft.com/default.aspx?kbid=241643 http://www.giac.org/practical/Joe_Partlow_GSEC.doc My question is: how are people configuring these thing???? Any help will be greatly appreciated. Alex. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > SQL Rep. Serv. Not Sending Email |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|