Continuing on from Part 1, this article will discuss some tests you can do to make sure that Reporting Services is configured and working properly at Arvixe. If any of these items do not pass, then you need to contact Arvixe support staff or drop me an email to see if I can help. Specifically with Arvixe, you can verify 3 key areas. If these areas all pass, then you are ready to start building and enjoying Microsoft SQL Server Reporting Services at Arvixe.
The only tool needed is Internet Explorer, Firefox, etc. For the purposes of this article I will be using Internet Explorer 10. If you get confused on any of these tests then just close the browser down and start that test again. I will be using the same url from Part 1. You can also see it below. (Figure 1)
1. Verify accessibility to SSRS Server
- Open up a browser and enter the url that matches the Report Server Url(D)
- After a few minutes you should be prompted for Login and Password (figure 3).
- Enter Username (F) and Password (G) (see note below *)
If everything goes well you should see the screen below after a 20-40 second delay. The url will change slightly to http://trout.arvixe.com/ReportServer_SQL/Pages/Folder.aspx. You can use either one in the future.
If you see something similar to this then Validation 1 has passed. Move to Validation 2 This is where you will come to upload / deploy your reports manually.
*Note: If the login windows keeps coming back then try entering two backslashes \\. and then Enter login and password. In my example it would be.
login: \\angler2be_report
password: 1Password1
2. Verify accessibility to Report Server Manager
* Open up a browser and enter the url that matches the Report Server Manager (B) * After a few minutes you should be prompted for Login and Password (Figure 5)
* Enter Username (F) and Password (G) (see note below *)
If everything goes well you should see the screen below after a 20-40 second delay (Figure 6).
If you see something similar to this then Validation 2 has passed. Move to Validation 3.
3. Verify accessibility to SSRS Web Service
* Open up a browser and enter the url the has the same format as the following
http://trout.arvixe.com/ReportServer_SQL_Service/ReportExecution2005.asmx
You will need to use the first part of Report Server Manager (B) and then add the ReportExecution2005.asmx
* After a few minutes you should be prompted for Login and Password (Figure 7)
* Enter Username (F) and Password (G) (see note below *)
If everything goes well you should see the screen below after a 20-40 second delay. Figure 8
(Note: This is used to access the Web Service for Reporting Services. Something that you may or may not use. However; I use it as the primary method of consuming reports
4. Verify connection between SSRS and SQL Data.
Although I stated earlier that there were three ways to verify SSRS is configured and ready to use there is a fourth way but we will talk about this in the next article and is really between SSRS and SQL (where your data is located)
Looking for quality web hosting? Look no further than Arvixe Web Hosting!