Creating subscriptions is a topic with many scenarios. I have mostly looked at Windows Authentication as it is the most easiest to look at.

I did work out most of the...

Microsoft has been using microservices for various things:-) including DocumentDB. It is going to come out with a preview beta for the Azure Service Fabric in its next meeting. Probably...

Well rounded post:-). The SQL Server Provider and the SQLPS.exe may be mentioned as it simplifies the coding.

http://hodentekmsss.blogspot.com/2015/04/can-you-use-windows-power-shell-to-find.html

Unfortunately Microsoft requires .

you to have a Ph.D in linked servers

The tweaks they suggest to create a linked server is so convoluted. it is amazing. I an not new to...

What about the setup rules? Did you skip it?

I

There is a SQL Server Express Advanced version and it installs SSMS as well as Reporting Services.

I could show you an image in my computer but I can only upload...

After running in RB 3.0 did you save it to the Report Server and then run the report on the Report Server or Report Manager?

Have you deployed the report and the sub-report to the server?

Run Get-wmiObject commandlet and find more details of your report server configuration.

Simplest way would be to use the For XML clause in your query. Persist the query to the file system. Now you can connect to this using Report Builder.

I do...

This is just an experiment I want you to try.

Save your report to the file system. Pick up the report in Report Builder. Now deploy it to the server. Do...

You design your report using Report Designer in Visual Studio. Try SSDT

In order to do this you could use the BI template for generating reports as you can get the...

First of all it is important to know the following:

Your platform OS and architecture.

What is your SQL Server installation if any?

If I assume Windows 7 (x64) bit then it is...

Can you email me the file? I would like to check and will get back to you.

mysorian@gmail.com

Watch out for truncation