Tuesday, December 16, 2014

Deployment of SSRS report for Multiple instances in AX 2012

How to deploy  SSRS reports based on specific AOS .



Scenario:

If you are having multiple AOS in the same computer and you need to deploy reports of second instance.

Resolution: 

 By default,the reports can be deployed by entering below command in the Microsoft Dynamics Ax 2012 management shell .









The above command by default deploys the report of first instance.

If you want to be more specific and need to deploy the reports on 2nd AOS instance.
You need to give three parameters to ensure that report deployment for specific AOS is successful

Three parameters:


-id : It is the report server instance.
        You can find this in Reporting services Configuration Manager.
       
-servicesAOSname : It is the Application object server name
                                   You can find the name in services window
                                  
-servicesAOSWSDLPort : It is the services wsdl port number allocated for that particular AOS.
                                            You can find this in Server configuration Utility




simply use the below command to deploy the reports of a particular AOS.








WSDL port number plays a vital role in deploying the reports based on the AOS  Configuration.

Happy Daxing.




Monday, December 15, 2014

Configure multiple instances of SSRS in one computer.

Configure multiple instances of SQL Server Reporting Services in same machine.

I would like to share information on how to configure multiple instances of SQL server reporting services in the same machine.

Initially install the reporting services and it becomes the Default instance.
If you want to configure another instance of reporting server(Named instance) follow the below steps.

Step 1:
 Run the SQL server 2012 Setup and select Installation tab




Step 2: In the installation Type,select the first option.


Step 3: In the setup role select SQL Server Feature Installation.



Step 4:




 Step 5:



 Step 6:



Step 7:


 Step 8:

 

This  will create a new service in the services window.

Now we need to configure the reporting services using reporting services configuration manager.