Geek Answers Handbook

SQL Server - a simple tool for remote reporting?

I want to give the client access to an instance of SQL Server so that they can execute the stored process or run the view, but ideally I do not want to give them SQL Server Management Studio because they are not technical.

Are there free and easy to use remote administration / reporting utilities for SQL Server?

+4
source share
5 answers

If you are on SQL Server 2008, Report Builder 2.0 (a free download) is a tool designed to enable end users to create reports from a variety of data sources, including views and report models.

More details here .

+1
source

Not that I know.

It seems to me that it would be better for you to create a simple form / form on the Internet that gives the client access only to specific functions and processes that they need. This will avoid confusion with the client with all the unnecessary complexity with which the management studio will present them.

I am not a programming guru, but I create something in common together, say, using .NET, it can be done in a couple of hours, including as a reliable protection. I suspect that you could find all the information you need to do this in ASP.Net tutorials.

http://www.asp.net/learn/

+1
source

MS Access is not free, but if they already have one, then you are configured. Simply create a project of access data (adp) to the database and let them access the views / stored processes you want to use. This is a simple click and click to run sproc, and it queries them for parameter values.

0
source

If its specific stored procedure or its viewing of a certain kind, why not write your own single-purpose application? It does not take much time, and then you will manage the interface.

0
source

I know this post is very old, but I am still posting for others. I created a small web application that does just that. Basically you enter the server, directory, user, password and sql query, and you get a url that points to this query / report. You specify the URL for the intended users, and they will be represented by the data received from the request in tabular format. It also includes features such as pagination, filtering, and sorting. You can download it from http://klauscam.imtqy.com/EasyReportingTool .

0
source

More articles:


All Articles