Lost Office 2010 Product Key

Leave a comment

Found this great link to a program that will grab your product key from a current installation of a slew of Microsoft products including Office & Windows. Great when you lose a product key, but still have the software installed. Follow the link . . .

Recover Office 2010 Product Key

Advertisements

Tricky lil SSRS Email Headache

Leave a comment

While setting up email functionality in SQL Server Report Server I came across a peculiar error.

“The server response was: 5.7.1 Client does not have permissions to send as this sender.”

 

Double checked the Email and Execution Account in Reporting Services Configuration Manager and both were set correctly, but I was still receiving the error. During my Google search I cam across an article explaining the issue in detail and my explanation (below) is specific to SQL Server 2008 and Exchange Server 2010.

First line of business is to create a new receive connector in the Hub Transport Server role, this is done from within the Exchange 2010 Management Console. The definition and role of the Hub Transport can be found here for further clarification.

To create the new receive connector, navigate via the Navigation Pane to Server Configuration>Hub Transport, then right-click in the empty space in the receive connectors window in which you then click “New receive connector”.

 

 

Following the completion of the Receive Connector you can now set the properties. Begin by adding the IP of the SSRS server to the “Receive mail from these remote servers that have these IP addresses:” under the Network Tab and check Anonymous Users under the Permissions tab (below).

Bingo!

SSRS Email Subscription Cannot be created

Leave a comment

Received this amazingly wonderful error message earlier today when trying to create an email subscription for an Reporting Services report.

“Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.”

Simple solution.

Under the properties tab in SQL Report Server’s Report Manager, go to the Properties tab for the report having the issue.

Basically, the data source credentials that are passed need to be changed from “Windows Authentication” to “Credentials stored securely in the report server”.

Just remember to set this to an account with only the minimum amount of rights needed to run the report.

Bingo!

%d bloggers like this: