[dba-VS] MS SQL Server Reporting Services Hosting Providers

[Gustav Brock]

Hi Shamil

I use a standard connection on port 1433 and ODBC to connect. From your network page on AWS you can control which IP addresses can gain access or select public access.

I haven't worked with Reporting Services on an SQL Server so I don't know about port requirements. Should be easy to find out, though.

If you wish to provide access to the reports only via a URL, you'll have to, I guess, either to have the PDF generated in advance and saved in a folder ready for download, or to have the web server of the URL to call the Reporting Service to generate the PDF and then offer it for download. The first method will be fast for the user, if the report has been generated; the second will allow for repeated calls, each time producing an updated report. In both cases I think HTTPS shouldn't raise a problem except, of course, that a trustworthy certificate must be purchased for the server. This is just thoughts - I haven't built a setup for this.

/gustav

________________________________________
Fra: dba-VS <dba-vs-bounces at databaseadvisors.com> på vegne af Salakhetdinov Shamil <mcp2004 at mail.ru>
Sendt: 21. august 2015 17:04
Til: Development in Visual Studio
Emne: Re: [dba-VS] MS SQL Server  Reporting Services Hosting Providers

 H Gustav --

Thank you for your comment. I do have AWS Dev Account so I should be able to get a VM with an MS SQL Server (Express) + MS SQL Server Reporting Services instances up & running there.
How do you connect to an MS SQL Server Instance running on your AWS VM? I mean what next work connection protocol do you use - TCP/IP with a fixed IP address (provided by AWS?) via TCP port 1433?

Also I'm still unsure what should be the way for communicate with MS SQL Server Reporting Services (SSRS):

- the customer's app (Silverlight 5) should talk (provide a set of parameters)  to a RESTFul (/or SOAP but RESTFul is preferrable) web service, and
- should get back an SSRS report converted to PDF,
- this report should then be viewed in ComponentOne ReportViewer Control for Silverlight (http://helpcentral.componentone.com/nethelp/C1ReportViewerSL/index.html#!Documents/componentonereportvi2.htm) (for starters, it can change).

I'd prefer to not "pipeline" PDF report, requested via RESTFul web service from SSRS, back to Silverlight client via RESTFUl web service but return to the Silverlight client just a URL of such a generated report. Also, all the communication between Silverlight client, RESTFul web service and SSRS should be performed via HTTPS...

Do you.anybody here know any ready to use skeleton apps for outlined here use case? Also I have no experience with "passing" established HTTPS connection from a RESTFull (IIS) web service to a SSRS: assuming that the RESTFul web service (ISS), MS SQL and SSRS all will be running on the same box such an "HTTPS connection delegation" shouldn't be a big issue to develop/configure?

Link to SSRS info:
https://msdn.microsoft.com/en-us/library/bb934283.aspx

Thank you.

-- Shamil


>Friday, August 21, 2015 10:12 AM UTC from Gustav Brock <gustav at cactus.dk>:
>
>Hi Shamil
>
>I run an instance of SQL Server on a VM at AWS running Windows Server 2008. I use to host an SQL Server database I attach from Access 2013. The VM is completely "normal" and I can access it via Remote Desktop as any other remote machine.
>
>I have not checked but, as far as I know, just about any version of SQL Server is available at AWS also in evaluation versions which might fit your need.
>
>AWS also has a free tier:
>
>     https://aws.amazon.com/ec2/pricing/
>
>where you as a new customer can have 750 hours of computing for free. As you know, you can turn your "machine" on an off at will though minimum charged hours is one.
>
>Speed for my tiny instance is not superfast but it has the advantage that it is much easier to optimize code and queries because any improvement is visible at once.
>
>/gustav
>
>-----Oprindelig meddelelse-----
>Fra: dba-VS [mailto:dba-vs-bounces at databaseadvisors.com] På vegne af Salakhetdinov Shamil
>Sendt: 20. august 2015 21:39
>Til: Development in Visual Studio < dba-vs at databaseadvisors.com >
>Emne: [dba-VS] MS SQL Server Reporting Services Hosting Providers
>
> Hi All --
>
>Do you have any experience with using hosted MS SQL Server Reporting Services? - I mean I need a reliable MS SQL Server Reporting Services provider for such a hosting for a very urgent project. I have found one -   http://tinyurl.com/nju8nxa   -    not sure if it will fit my and my customer needs "out-of-the-box". Do you know any other, which you have used in your projects and you know they are reliable?
>
>Thank you.
>
>
>--
>Салахетдинов Шамиль