Can SSRS be used on a NON MIcrosoft SQL server computers

I am installing a Visual Studio 2017 application developed on .NET framework 4.5.
The client does not use Microsoft SQL Server but I would like to use SSRS for reporting. Is there a standalone SSRS that can provide reporting without Microsoft SQL Server installed.
Paul ZeitchickLead Software ArchitectAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Sounds like the target machine doesn't have the necessary components. I use the builtin reports in .NET for several apps, and I have to deploy the Microsoft Report Viewer Runtime (actually I use my installer, Advanced Installer, do include the link to the download, and AI determines if I need the Runtime and downloads/installs it).

You also need the SQL Server CLR Types. Generally speaking, the Report Viewer Runtime will download those as needed (at least it does with my apps), so you shouldn't need a prerequisite for that.

But I'm still betting you'd have to have an instance of SQL Server for that.

I could look to others like Crystal
Crystal is a great reporting platform but I've found it to be difficult to deploy and install. It's VERY version dependent (you can't how two different versions of CR on the same machine). I'd lean more towards something like DevExpress, or JasperReports (which is open source).
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can install SSRS without installing SQL Server on that machine, but there has to be a SQL Server somewhere. When you configure SSRS, you're asked for the location of the SQL Server to be used, and if that's not available I'm not sure how you'd get around that.

Perhaps someone else has other observations, however.
0
 
Paul ZeitchickLead Software ArchitectAuthor Commented:
That makes sense. Let me add the following in case I asked the question incorrectly. I have created reports using SQL Business Intelligence in my development environment. In Visual Studio, I am using the Microsoft Reporting objects (all of which I use with SSRS Server in other environments).

I would like to publish the application with Microsoft Report objects and the RDL files (local reports, not server). The reports run but I receive errors in the report window that certain classes do not exist. Such as Microsoft.SqlServer.Types and others. If SQL is required, I could look to others like Crystal but Microsoft Reporting is the way I wanted to go.
0
 
Paul ZeitchickLead Software ArchitectAuthor Commented:
It sounds like it might be a little too much to try and get all of the components to make Microsoft reporting work and then possible not work in the end. I already have Crystal working on other sites for similar apps and the versioning is tough but manageable. Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.