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 : https://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 Tip
I have a passion for crafting Business Intelligence Solutions for my user groups. My experience includes almost 15 years of SQL Server involvement with the last 12 years focused specifically on Business Intelligence, SharePoint, OLAP, SSRS, and Decision Support solutions. Currently, I am a Business Intelligence Architect in the healthcare industry, and I also teach database and analytics classes for Kennesaw State University, Southern New Hampshire University, and Reinhardt University. My education includes an MBA and an undergraduate in Accounting (yes I am a reformed accountant!), both from Kennesaw State University. I enjoy every day by trying to grow my faith and spend precious time with my family. I have been happily married to my wife of over 20 years, and we have two teenagers one who we home school with the help of a University Model School, Cornerstone Prep in Acworth, GA (cornerstoneprep.org). Our other child is a Construction Management major at KSU’s Southern Poly / Marietta campus. We are a soccer and Cross Country (XC) family who play, coach, and referee soccer or run for fun most every day. For several years, our family has volunteered (and played with the dogs and cats) at Etowah Valley Humane Society in Cartersville, GA.
- MSSQLTips Awards: Champion (100+tips) – 2016 | Author of the Year – 2015 | Author Contender – 2014, 2016-2021
