Skip to main content

Posts

Showing posts with the label SSRS Reports

The Report Server Cannot Access The Private Key For The Service Account

The Report Server Cannot Access The Private Key For The Service Account Error The report server cannot access the private key for the service account. This key is used to decrypt the symmetric key that protects content in the report server database. This condition might occur after the password is reset for the report server service account. You must either restore a backup key or delete all encrypted content. (rsKeyStateNotValid) Solutions Open Report Services Configuration Connection Connect Server Click on  "Encryption Keys" right side  "delete Encrypted Content"  delete Apply
Post a Comment
Read more

SMTP Check Port 25 with the Telnet Command

SMTP Check Port 25 with the Telnet Command You can check your SMTP Server on SMTP port 25 with the following Telnet command: Open a command line and type telnet smtp-server.domain.com 25 If your server is online a connection will be established on port 25 (SMTP). An Exchange Server answers with the following output: 220 mailserver.domain.com Microsoft ESMTP MAIL Service, Version: 5.0.2195.5329 ready at Sat, 22 May 2006 08:34:14 +0200 When you type the ‘help’ command the available commands are listed: 214-This server supports the following commands: 214 HELO EHLO STARTTLS RCPT DATA RSET MAIL QUIT HELP AUTH TURN ATRN ETRN BDAT VRFY Try the following to send an eMail from the command line: 220 mailserver.domain.com Microsoft ESMTP MAIL Service, Version: 5.0.2195.5329 ready at Sat, 22 May 2006 09:01:29 +0200 helo myserver.domain.com 250 mailserver.domain.com Hello [10.1.11.133] mail from:< myname@mydomain.com > 250 2.1.0 myname@mydomain.com....Sender ...
Post a Comment
Read more

SSRS Table Header Repeat in Every Page

Right click Report Report.rdl View Code. Look for TablixRowHierarchy Below that there will be a TablixMember that corresponds to the header row. to that header and any other header rows ( Tablix Member) add the three element properties. KeepWithGroup After /KeepWithGroup RepeatOnNewPage true /RepeatOnNewPage KeepTogether true /KeepTogether You should see the header rows repeating.
Post a Comment
Read more