How to add Sql Reporting Services in Wordpress

• To install correctly this sql-reporting-services.zip .
• Fisrt Download the sql-reporting-services.zip to your computer
• Extract/Open sql-reporting-services.zip to Your Computer.
• Then, Find readme.txt file inside sql-reporting-services.zip and Open readme.txt .
• Now, Read the Requirements of this plugin. Which Wordpress Version and PHP Version are required to run this Plugin in Your Wordpress Site.
• Then, Follow the Tips Below.

Step-1 : Download " sql-reporting-services.zip " to Your Local Computer.

Step-2 : Then, Login to your " yourdomain.com/wp-admin " Dashboard.

Step-3 : Then, Click on " Plugins " + " Add New " from left Side Menu of Dashboard.

Step-4 : Now, Click on " Upload Plugin " button.

Step-5 : Now, Browse " sql-reporting-services.zip " Downloaded plugin from your computer, Where you downloaded " sql-reporting-services.zip " According to Step – 1 Above then, click on " Install Now "

Step-6 : Now, Click on " Active Plugin "

Step-7 : Then, See left Side Menu. " Sql Reporting Services " folder is added on left Side Menu. Now, Click on " Sql Reporting Services " folder.

Noted that: If you do not see " Sql Reporting Services " folder on left Side Menu then, see at left Side Menu " Settings " or " Tools ".

Step-8 : Now you configure yourself oR Watch video tutorial below about Sql Reporting Services Configurations and Settings or How to work " Sql Reporting Services " in your WordPress site.

After Activated Plugin According to Step-6 then,

1. Go to " Plugins " + " Installed Plugin " from Wordpress Admin Panel Leftside Menu.
2. or Direct go to: https://yourdomain/wp-admin/plugins.php
3. Then, Find " SQL Reporting Services – SSRS Plugin for WordPress " Activated Plugin from Plugin List.
4. Then, Click on " Settings " from Plugin that is SQL Reporting Services – SSRS Plugin for WordPress
5. Now, Edit/Add/Config the setting and Click on " Save Changes " button,

Please be sure to review the plugin requirements are met before installing the plugin.

Requirements

1. This plugins provides access to reporting services so you must have a Microsoft SQL Server Reporting Services server running in order to connect the plugin to it, versions 2008 – 2017 are currently supported
2. The SOAP extension must be installed and enabled within PHP, if it is not already, see below for more information
3. Your Microsoft SQL Server Reporting Services server must support basic authentication in the rsreportserver.config file, see this article for more information how to enable this if it is not already
4. Minimum version of WordPress 3.7.1
5. Minimum version of PHP 5.3

AUTOMATED Installation

From within WordPress dashboard:
1. Go to “Plugins” -> “Add New”
2. Search for “SQL Reporting Services” by Module Masters
3. Click “Install”
4. Click “Activate”
5. Opt-In, this is optional but recommended as it verifies your installation
6. Go to “Settings” -> “SQL Reporting Services”, register your report server (e.g. http://server/reportserver) and enter your active directory credentials to access the server
7. From a blog entry or page, add the ssrs shortcode (e.g. [ssrs reportpath="/TestReports/ParmTest" height="1200px" width="100%"] )

MANUAL Installation

1. Instead of the quick installation above, you can download and unzip the plugin to your computer
2. Upload the sql-reporting-services folder to the /wp-content/plugins directory of your WordPress site
3. Activate the plugin through the “Plugins” page
4. Opt-In, this is optional but recommended as it verifies your installation
5. Go to “Settings” -> “SQL Reporting Services”, register your report server (e.g. http://server/reportserver) and enter your active directory credentials to access the server
6. From a blog entry or page within your WordPress site, add the ssrs shortcode (e.g. [ssrs reportpath="/TestReports/ParmTest" height="1200px" width="100%"] )

PHP SOAP Extension

This plugin makes calls to the SSRS server using the reporting services API which leverages SOAP web service calls. In order for these calls to be able to be made from the PHP engine which powers WordPress, this extension must be installed. The plugin will throw an error message if it detects that this is missing so if you aren’t sure, simply do the installation and you’ll see a notification if you need to enable this. If so, don’t fret, it is easy!

For Windows
1. Find extension=php_soap.dll in php.ini and remove the semicolon(;)
2. Restart your Server

For Linux (Ubuntu)
PHP7.x
sudo apt-get install php7.0-soap
sudo systemctl restart apache2

For nginx
sudo apt-get install php7.0-soap
sudo systemctl restart nginx

For PHP5
apt-get install php-soap

Need More Help?!?!

We stand behind our work and are happy to help you. We offer premium support offerings from our paid version along with more features, but regardless, just let us know from the WordPress “Settings” menu, browse to the “SQL Reporting Services” -> “Contact Us” page or “Support Forum” page if you have questions, feedback or new feature requests!

Please see the documentation available from our website for more information!