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

Salakhetdinov Shamil mcp2004 at mail.ru
Fri Aug 21 10:04:16 CDT 2015

 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:

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.
>-----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.
>Салахетдинов Шамиль 
>dba-VS mailing list
>dba-VS at databaseadvisors.com

More information about the dba-VS mailing list