Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Common Issues After Upgrading to SSRS 2014 Video


By:   |   Updated: 2015-02-10   |   Comments (2)   |   Related: > Reporting Services Migration



 






Enter your business email address to
get free SQL Server tips.

Problem / Solution

Now that SQL 2014 is readily available, report designers will begin to develop new reports using SSDT-BI for Visual Studio 2013 to build, test and deploy SSRS reports. Unfortunately, "out of the box" many report designers and developers are running into an error when attempting to preview reports in SSDT-BI. This issue is caused by the Net.Pipe Listener service not being started after an install, and thus must be started and set to run automatically in order to preview reports without an error. Furthermore, when previewing reports a command window now opens and if a report designer closes this command window while previewing a report, a similar issue occurs. I have created a "tidbits" tip which covers this particular issue plus two other items which is available at : http://www.mssqltips.com/sqlservertip/3428/sql-server-data-tools-ssdt-is-missing-after-installing-sql-server-2014/.

Key Learning Items

The video covers how to:

  • Common Error when attempting to Preview an SSRS report in SSDT
  • Solution/Project Properties to be checked after upgrading
  • Checking for Unused Datasets via BIDS Helper
Read Companion Tips

Click Here



Last Updated: 2015-02-10


get scripts

next tip button



About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Sunday, February 15, 2015 - 1:38:44 PM - Dave Clark Back To Top

Good video Scott - thanks for the information.

The issues mentioned seem like a bit of a pain for a developer, but now at least I will be prepared when I start using MS SQL Server 2014.

Thanks,

Dave Clark


Tuesday, February 10, 2015 - 1:51:42 PM - Vamshi Back To Top

Thats really cool tip Scott. Thank you very much and for introducing SQL SERVER RS 2014 .  :-)

 

Cheers, 

-Vamshi


Learn more about SQL Server tools