The e-mail address of one or more recipients is not valid error from SSRS

Our current sql server is SQL Server 2005 and we use Exchange 2007.

Today we attempted to use SSRS to send a report outside of our domain and when the report ran, we noticed that subscription’s status was “The e-mail address of one or more recipients is not valid”.

Subscription Status

Subscription Status

We knew we had good email addresses, so we decided to look elsewhere for the answer to the issue.

Our SSRS email settings looked like this

SSRS email settings

SSRS email settings

Based on the answer here we modified the Allowed Relay properties and added the sql server’s ip address to the “Receive mail from remote servers that have these IP addresses” section (While in the Exchange Management Console, select Hub Transport under Server Configuration, select Receive Connectors, then right click on the Allow Relay entry…Select the Network tab, then add or edit the sql server ip address in the “Receive mail from remote servers that have these IP addresses” section).

After adding the sql server’s ip address as above, the subscription worked!

Advertisements
Posted in SSRS 2005 | Leave a comment

Change the text of an insert button

Using Telerik’s Extensions for ASP.NET MVC
Specifically the grid component

I was attempting to change the text of the Insert button and it was not obvious, to me at least, how to do so….
so jquery to the rescue!!

I’m using Telerik’s mvc grid in an MVC 2 application using Visual Studio 2008

In the view, tie the view to a javascript file

in the javascript file, type the following…
$(“.t-grid-add”).text(“Add New Invoice”);

Note that the class for the insert command in the grid is t-grid-add

as you can see from the firebug screenshot below, one of the classes for the button/link is t-grid-add

I’ve also added a shot of the button with the modified text.

Posted in mvc | Tagged | Leave a comment