Email Subscription Can't Use External Domain

Apr 7, 2008

Hi there,

I have successfully set up a Report Subscription and it sends the report to our internal users at a given time each day.

I recently added an external email address in the 'CC' & 'BCC' boxes but i got an error saying the address was invalid (i've tried with just the 'To' box as well). There's nothing special about the external address, i've tried with gmail, BT, and Yahoo.

So it would seem that any address outside of my local domain is invalid.

Is there some config setting that i'm overlooking? Has anyone had this problem?

I'm using SQL Server 2005 Standard Edition.

Any help would be great.

Thanks,
Lee.

View 5 Replies


ADVERTISEMENT

How Do I Configure SQL Server 2005 Reporting Services To Deliver Subscription E-mails To Addresses External To My Windows Domain

Jun 10, 2007

Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?

I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.

For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.

Any insights?

View 1 Replies View Related

Reporting Services :: Data Driven Email Subscription With Different Email Per Report Page

Jul 6, 2015

I have a report that gets sends out through a subscription and sometimes the report has multiple pages and all those pages appear within one email.Is it possible to set the subscription in such a way that an email is sent per page when the subscription executes.

View 2 Replies View Related

Sql Reporting Services - Subscription To External Emails - Help

Sep 21, 2007

Hi
I have report subscription to send mail to external emails.
It works fine for Internal email id's, external email id's doesn't work.
Any body knows what configuration changes we need to do.
Please let me know if any body knows.
Thx
vijji

View 4 Replies View Related

Sending External Email From Within A Scheduled Job

Jul 23, 2005

I'm not a newbie, but I've not been able to find out how to do thisparticular task, and BOL isn't being too cooperative.My application sits on a SQL Server backend (SQL Server 2000).The application is a Document Distribution system. Some subscribershave elected to be notified by e-mail that a new revision of a documentis available.I want to run a daily job that would search for new revisions and emailany electronic subscribers. Pseudo code example:DECLARE MailList CURSOR FORSELECTEMailAddressFROMCustomersINNER JOIN DocumentDistribution ONCustomers.CustomerID = DocumentDistribution.CustomerIDWHEREDocumentDistribution.DocumentID = @DocumentID ANDCustomers.EMailEnabled = 1OPEN MailListFETCH NEXT FROM MailListWHILE @@FETCH_STATUS = 0BEGIN/* Format and send the email to the customer here */FETCH NEXT FROM MailListENDCLOSE MailListDEALLOCATE MailListWhat do I need to do on the server to make this work?Many thanks in advanceEdward--The reading group's reading group:http://www.bookgroup.org.uk

View 1 Replies View Related

Query To Get The Domain From The Email

Jul 20, 2005

Hi,I wanted to get the domain name from the email in a query..So if the email is Join Bytes!, I just to display hotmail.comThanks in advance for the help.AJ

View 2 Replies View Related

Cross Domain Email

Jul 8, 2015

We are using SQL Server 2012 . We have configured the Database mail Services. Issue is, the mails are going to only inside the domain not going cross domain Email address like hotmail,gmail and etc. But from outlook client the mails are going to cross domain Emails. Same issue is in SSRS Email Services also. We have checked the SMTP Server, we could not figured it out.

View 2 Replies View Related

Email Subscription

Jul 2, 2007

Hi

I have uploaded a report onto my 2005 Reporting Manager and want to create a daily email of the report... How do I set up the email facility? Can someone give me a link?
I not sure what to do because the company uses Exchange Server and not SMTP....

Thanks

View 5 Replies View Related

Email Subscription

Dec 14, 2007

All,

I have this subscription using email outside my domain. for example. I'd like to send reports using subscription, and when the recipient email address's outside my domain (for example xxx@hotmail.com or fff@yahoo.com, etc), the subscription fails.

Anybody know how to solve this?

Regards,
Addin

View 2 Replies View Related

PATINDEX - Search For More Than One Email Domain

Sep 30, 2014

I want to search a table and display only results that contain particular Hotmail and yahoo email addresses. The code I am using currently is:

Select Name, Email, PATINDEX('%Hotmail%, Email) From tblPerson

How do I search for more than one email domain? Do I use a case statement, if so how?

View 2 Replies View Related

How To Extract Domain Name From An Email Address??

Aug 2, 2007

Hi

do you know incase a script which extracts domain names from an email address?

like foreg. we have xyz@dmc.com or abce@dmc-int.com

should give

dmc and
dmc-int


View 7 Replies View Related

Mass Subscription Email Changes

Nov 15, 2007



The company i work for changed names and all email addresses within the company have changed. While it was OK for a while they are no longer going to be forwarding email to the old addresses to the new ones. There are Tons of subscriptions and tons of email addresses that need to be changed to the new names.

If i could find the table with the TO: part of the subscription held in it i could just run an update on that field and it would be solved...however, i cannot find that field...


So,
Without going into every subscription in report manager, how can i change the email addresses? Any Suggestions?

Thanks in advance

View 1 Replies View Related

Email Subscription To Hotmail?

Jan 3, 2007

Hello...

I have a Virtual PC running SSRS 2005. I keep getting the following error when I try to specify my hotmail account as the To line in the email subscription:

"The e-mail address of one or more recipients is not valid."

I am trying to set it up such that I can send email subscriptions to my hotmail account, or at least let the SMTP Service accept these emails. I don't necesarily need to have these emails delivered, but I would like them to at least be accepted by the SMTP Service. I have added the following to my rsreportserver.config file:

<PermittedHosts>
<HostName>hotmail.com</HostName>
</PermittedHosts>

I am sure I need to configure the IIS SMTP Server settings somehow, does anyone know how to configure my local SMTP Service to allow @hotmail.com email addresses to be placed into the "Drop" folder?

TIA

View 2 Replies View Related

Email Address Domain Strip Of Query

Oct 1, 2007

Could this query be made more efficient?
It takes ages to run it. It strips of everything from an email address and keeps only the domain.

SUBSTRING(Mailaddress, CHARINDEX('@', Mailaddress) + 1, CHARINDEX('.', SUBSTRING(Mailaddress, CHARINDEX('@', Mailaddress) + 1, 100)) - 1) AS mail_domain

View 4 Replies View Related

Email Subscription Error On Credentials

Sep 18, 2007

Hello,

When trying to subscribe to an report via email I get to following error


The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)


Can anybody help me with this issue.

Greetings
Vinnie

View 15 Replies View Related

Problem Setting Up Email Subscription

Jan 31, 2008

Hi,

I have several data driven subscriptions successfully running on my server, but have been having problems setting up a standard subscription. The subscription appears to be successfully created in the Reports Manager interface, I can see the schedule job set up in SQL Server, and in the job history the subscription apparently runs with no errors. However if I look on the Reports Manager interface there is nothing in the "Last Run" column and no report email is received. When I check the Reporting Services logs I can see the following:

ReportServerWebApp log file:

w3wp!extensionfactory!1!1/02/2008-10:21:58:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!1/02/2008-10:21:58:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.

ReportServer log file:

w3wp!library!1!02/01/2008-10:21:58:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
w3wp!extensionfactory!1!02/01/2008-10:21:58:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).

These errors occur at the time I set up the subscription (not the scheduled execution time). I can run the job manually "Start job at step..." in SQL Management Studio and the report is sent/received. I have seen a few posts similar to this but as yet haven't seen anyone resolve this problem. Can anyone help me?

Regards,

Greg

View 4 Replies View Related

Reporting Services, Subscription Email

Feb 3, 2008

I am getting the following error when I set up a subscription, I am able to send smtp messages from the same server using a winclient, I also made sure that the user that runs the RS service is the same as the winclient.

Read all the ms docs about setting the email settings, have tried quite a lot of them, but for some reason i have been getting the following error. Just unable to bypass this!

I wonder if someone has had a similar exp.

Failure sending mail: The server rejected the sender address. The server response was: 454 5.7.3 Client does not have permission to Send As this sender

Installing a local SMTP might not work as our polocies are to run smtp from exchange.

Any help is appreciated.

Regards
S

View 5 Replies View Related

Subscription Email Rendering Badly

Apr 3, 2007

I have created a very simple report that includes a single table with three cells per row.



When I view the report in Visual Studio, on the Report Server, in any format, it looks fine. However, the version that gets emailed as a subscription looks awful. The width of my table cells is not preserved, so they shrink to be as narrow as possible with all the words wrapping.



Basically, the table gets smooshed so that it's much narrower than it should be. All the words wrap when they shouldn't.



CanShrink is set to False. I have tried CanGrow on both False and True and it didn't make any difference.



Remember, the problem is only with the emailed version of the report.





Any idea if there's a solution for this?



Thanks,

Dan

View 4 Replies View Related

Error Delivering Subscription Email

Mar 19, 2008

Env: SQL Server 2000 Reporting Services - 8.00.1042.00 on Windows Server 2003 SP1 - Microsoft Windows NT 5.2.3790.0

I configured a report subscription to send an email out, but I did not realize that the mail send was tied to my account. When someone removed my windows login from the local admin group, the report delivery errored with:

"Failure sending mail: The permissions granted to user '<Domain><user>' are insufficient for performing this operation."

My login has been reinstated, but how do I configure the send mail to use a different account? Note that he report server is running under the "NT AuthorityNetworkService" account (unfortunately). I'm hoping I don't have to deal with the unattended execution account because the docs on that are awkward.

TIA,

-Peter

View 4 Replies View Related

How To Disable The Attachments Sent Through Email-subscription

Mar 31, 2008



i need to send a report as e-mail. so i'm trying it through email subscription. i'm rendering the report in MHTML format.
I'm able to get the report in mail but the problem is the images (i,e bar graph,charts and embedded images) in the report are getting displayed below the actual report and all images in the report are added as attachment.
i need only the generated report as mail and not these extra images that gets embedded in the email.Is there is any way to get this done??

View 9 Replies View Related

Unable To Send Email Via Subscription

May 23, 2007

Some Background: SQL Server 2005 Developer Edition SP1 on Windows 2003 Server R2 SP1. This SQL Server 2005 named instance was recently upgraded from Standard Edition to Developer Edition.

Now the problem:
I've set up a simple report, that creates a snapshot on a schedule, which sends an email once the report has been run. However, no email is being sent, and when I go to the subscriptions tab for the report, I see the following Status for the Subscription that is failing:

Failure sending mail: Retrieving the COM class factory for component with CLSID {CD000001-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 8007007e.

A little research indicates that error 8007007e is 'The specified module could not be found'.

So, I scheduled the report to create a snapshot once a minute so that I could generate the error frequently, and then ran Process Monitor to look for any problems. In the log I found a lot of 'NAME NOT FOUND' entries for the ReportingServicesService.exe and SQLAGENT90.exe as they were looking for INETCOMM.dll (Microsoft Internet Messaging Library). I did a search for that file on the server, and was unable to find it.

Is the absence of this dll my problem, and if so, how do I restore it? If it isn't, any other ideas on troubleshooting this problem?

View 3 Replies View Related

Subscription Based Report Via Email

Aug 23, 2007

I cant imagine this to be possible, but I currently have a report setup and a subscription that email the report to some users, I was curious to know if possible that if the report returns no records to not have the report sent?

View 1 Replies View Related

Like Condition - Retrieving All Email Address Using Particular Domain Extension

Oct 30, 2014

I am trying to retrieving all email address using particular domain extension for e.g. gmail.com

I wrote the below query

Select policyid,emailaddress from policyholder
WHERE policyholder.EmailAddress like '%gmail.com%'

It works fine, but i want to use the LIKE condition against ‘emailaddress’ column in email table as I have more than 100 domain extensions

I wrote something like

WHERE policyholder.EmailAddress like (select emailaddress from email) but I am getting the below error

Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

View 4 Replies View Related

Pass Paramenter In Subject Of Subscription Email

Sep 29, 2007

Hello there,

how can i pass my own parameter values in the subject of Subscription email?.for example i want to pass the employee ID in the subject.

View 4 Replies View Related

URL Link In Subscription Email Does Not Render Report

Apr 25, 2008

I have set up a test subscription that sends an email that includes both the report and the url link to the report. However, the report does not render when user clicks on url link in subscription email. The parameter toolbar sorta appears at top of page but buttons are not showing correcty. I saw similiar issue posted in another forum but no one had resolved yet. We all noticed that the subscription email uses /reportserver folder instead of /Reports folder.

The report does appear fine in the email so I believe the problem is the URL.

Can anyone tell me how to resolve?

Thanks,
Tammy


The URL from Report Manager is

http://dss0vw037.svr.us.jpmchase.net/Reports/Pages/Report.aspx?ItemPath=%2fIOC+Metrics%2fDCS+Emergency+Contact+List

The URL in subscription email


http://dss0vw037.svr.us.jpmchase.net/reportserver?%2fIOC+Metrics%2fDCS+Emergency+Contact+List&rs%3aParameterLanguage=en-US



View 1 Replies View Related

Subscription Error: Invalid Email Address

Apr 11, 2007

(NOTE: FROM a NON-IT PERSON) We've implented SQL 2005 and Reporting Services, but our subscriptions only work internally: when we try to send reports via subscriptions to valid external email addresses, we get a message: invalid email address and the entire subscription does not work.. PLEASE ADVISE. IT WILL BE GREATLY APPRECIATED!



View 1 Replies View Related

SSRS 2005 Email Subscription Problem

Feb 13, 2006

Hi,

We have a new SSRS 2005 instance running with a number of reports. We have setup a subscription on one of these to run at 8am every Monday. However this is not working. No email is being sent and it does not appear the subscription is being run, nothing is ever written in the Last Run column.

I have looked in the logs and the only thing I can see is the following warning

w3wp!extensionfactory!5!13/02/2006-14:42:03:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!13/02/2006-14:42:03:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.

We had this working succesfully with SSRS 2000. The new instance was a clean install.

Cheers

Dave

View 1 Replies View Related

Snapshot Executes But Subscription Does Not Email To User

Sep 6, 2006

I have a problem with a report set up to execute a snapshot and subscription on day 1 of each month. On July 1, it ran and was emailed to the user; on 8/1 it created the snapshot but did not send to the user because of a user error in the subscription, so it was sent manually. the parameters issues were corrected and on 9/1 the snapshot executed but the subscription did not send. In the subscription window, the last good email of a snapshot was sent 7/1. So again 9/1 was sent manually. After fixing the parameters shouldn't this have emailed the snapshot correctly on 9/1?

Do I need to delete this subscription and create a new one to get it to send on 10/1 now?

any suggestions?

the set up is now verified to be identical to other reports which created a snapshot and emailed successfully, the only difference is the original problem with only the 7/1 subscription the only one you see when you look at the "subscription tab" for this report in Reporting services:

Description:Send e-mail to name.one@plife.com, name.two@plife.com

Trigger:SnapshotUpdated

Lastrun: 7/1/2006 7:00 AM

Mail Sent to:Mail sent to name.one@plife.com, name.two@plife.com

Snapshots successful






5/1/2006 7:00:02 AM



6/1/2006 7:00:03 AM



6/1/2006 8:26:31 AM



7/1/2006 7:00:07 AM



8/1/2006 7:00:24 AM



9/1/2006 7:00:19 AM




Logfile for "Ops Specialists/1035 Exchange Issue - Details (200407-R01)" report
Portion of log file:
ReportingServicesService!dbpolling!f!9/1/2006-07:00:04:: EventPolling processing item e869f577-b189-4e6a-a9be-37b61d737340
ReportingServicesService!dbpolling!13!9/1/2006-07:00:04:: EventPolling processing item 2b275311-0ee4-4cef-972d-86de48f4f360
ReportingServicesService!dbpolling!c!9/1/2006-07:00:04:: EventPolling processing item 3df3960a-ee28-4d5e-a46e-326ab5a0060d
ReportingServicesService!library!c!9/1/2006-07:00:04:: Schedule e11a00d3-56b6-46b3-b2d3-9e3156805be8 executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!library!13!9/1/2006-07:00:04:: Schedule 177e9473-2c81-4152-a89f-137d25a556e1 executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!library!4!9/1/2006-07:00:04:: Schedule 89071f26-435c-4cc7-bd9a-23907ef32b5c executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!library!f!9/1/2006-07:00:04:: Schedule 3720d20c-460e-4549-9b57-c3cc97919f5f executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!schedule!13!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Ops Specialists/1035 Exchange Issue - Details (200407-R01)
ReportingServicesService!schedule!c!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Ops Specialists/1035 Exchange Bridged - Details (200407-R01)
ReportingServicesService!schedule!f!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Ops Specialists/Policy Counts (200401-R01)
ReportingServicesService!schedule!4!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Inforce Admin/CAAB226 (200501-R03)
ReportingServicesService!dbpolling!d!9/1/2006-07:00:08:: EventPolling processing 4 more items. 8 Total items in internal queue.



View 8 Replies View Related

Failed Email Data Driven Subscription

Dec 26, 2007



I have several email data driven subscriptions setup. They have been working fine for the past couple of weeks. We have recently gone through some layoffs. Now the subscriptions are starting to fail.

I am assuming the smtp server is not allowing invalid email address to go. But if I have one invalid email address why would the entire job fail? How can SSRS see if each email address is valid at the time of processing?

Is there a setting to allow invalid email address to not fail the job? They only solution that I could think of is to create distribution email groups. This would be rendered on the smtp server and not in Reporting Service Service.

Does anyone have any good solutions they would like to share?


Log file:

at ReportingServicesCDOInterop.MessageClass.Send()
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!library!10!12/26/2007-10:43:15:: Data Driven Notification for activation id ac381bd5-7a04-4e8e-b5cf-510a3833c4f0 was saved.
ReportingServicesService!library!10!12/26/2007-10:43:15:: Status: The e-mail address of one or more recipients is not valid.
ReportingServicesService!notification!10!12/26/2007-10:43:15:: Notification 65af159a-b2c6-4667-905b-b2342898a28f completed. Success: False, Status: The e-mail address of one or more recipients is not valid., DeliveryExtension: Report Server Email, Report: Tech Lead Program - District Summary, Attempt 0
ReportingServicesService!dbpolling!10!12/26/2007-10:43:15:: i INFO: NotificationPolling finished processing item 65af159a-b2c6-4667-905b-b2342898a28f
ReportingServicesService!library!4!12/26/2007-10:43:16:: i INFO: Call to RenderFirst( '/Marketing/TTL/Tech Lead/Tech Lead Program - YTD Technician Summary' )
ReportingServicesService!dbpolling!c!12/26/2007-10:43:18:: i INFO: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!11!12/26/2007-10:43:18:: i INFO: NotificationPolling processing item a6731001-092e-4a48-841e-bd22640956d7
ReportingServicesService!processing!12!12/26/2007-10:43:18:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1.
ReportingServicesService!library!11!12/26/2007-10:43:19:: i INFO: Call to RenderFirst( '/Marketing/TTL/Tech Lead/Tech Lead Program - Customer Detail Report' )
ReportingServicesService!library!11!12/26/2007-10:43:22:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!11!12/26/2007-10:43:22:: Error sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!11!12/26/2007-10:43:22:: Error sending email. System.Runtime.InteropServices.COMException (0x8004020F): The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay for xxxxx@searshc.com

View 4 Replies View Related

Subscription And Email Issues With Browser Role.

Dec 15, 2005

We have our user's set up in the Browser role.  We are having an issue in that none of them can create a subscription on a  report or email a report.  If they set up a subscription, it is displayed but the report does not run.  When they try to email a report, the To: box is greyed out.  Has anyone encoutered this issue?  Does anyone have any suggestions on why this is happening?

Thanks.

Vicki

View 17 Replies View Related

Reporting Services :: SSRS Email Subscription Not Working?

May 20, 2015

sql server edition-2008 enterprise evaluation edition

Operating System- Window Server 2008 R2

I've Created Local Smtp to use gmailid for Subscription of SSRS Report by Email as we don't have an Exchange Server.

User this link to Create local SMTP

Studied few blogs that related it to agent service running under local system account, on my machine it was running on NT/NetworkService change it to Administrator of local Machine. Did same change for Database Engine of Service of SQL Instance.

FYI- My Machine is not in Domain, so used local administrator for giving rights to service mentioned above.

Below is the Screen Shot of rsreportserver.Config File

ERROR : on Report Manager

Below is report log on after time report was executed.

library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 executed at 05/20/2015 13:19:05.
schedule!WindowsService_16!2b30!05/20/2015-13:19:05:: Creating Time based subscription notification for subscription: ea7fc6ce-00df-4f6a-9050-e713986307ca
library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 execution completed at 05/20/2015 13:19:05.

[code]....

PS: Local SMTP is working, i.e. i am able to receive email if i place an email.text file in C:inetpubmailrootpickup

View 7 Replies View Related

Cannot Get Subscription Email When Including Report, But Can Get It When Just Sending Link

Jul 12, 2007

When I set up an email subscription for a report, I can get the email notification if I only include a link to the report, but get the generic "Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information." error message when I attempt to include the actual report in the email; either as "Web Archive," or PDF." When I consult the ReportServer log file, I do not see any sort of exception that would indicate the true source of the error.



I have set the file security on the RSTempFiles folder to allow the IIS_WPG group to modify the folder, but when I looked into the RS config files, it looked as though SSRS wasn't configured to use temporary storage.



Any suggestions?



-Matthew

View 3 Replies View Related

SSRS 2005, Subscription Email Addressing Is Greyed-out

Nov 8, 2007

I have SSRS 2005 installed. User wants to change email address on subscription to send to external customer or others in our organization.

If I modify right "Manage individual subscriptions" to enabled for his security profile, the email address box is greyed-out.

I tried changing value <SendEmailToUserAlias>xxxx</ SendEmailToUserAlias> to FALSE in rsreportserver.config, with SSRS restart, but address box is greyed-out.

If I modify right "Manage all subscriptions" enabled for his security profile, the address box is not greyed-out, but can now see-edit everyone's subscriptions for that report.

How can I turn on address box is not greyed-out, but not open view of ALL subscriptions to my users?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved