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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.