Arvixe and Reporting Services Verify (Part 2 of 7)

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)

2figure1

1. Verify accessibility to SSRS Server

    1. Open up a browser and enter the url that matches the Report Server Url(D)
    2. After a few minutes you should be prompted for Login and Password (figure 3).

Figure3Figure 3

    1. 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.

Figure4

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)

Figure3Figure 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).

Figure6Figure 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)

Figure3Figure 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

Figure8Figure 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!

Tags: , , , , , , , , , , , , , , | Posted under Programming/Coding | RSS 2.0

Author Spotlight

David Bauernschmidt

David Bauernschmidt

I live in the historical triangle of Virginia where I am married with two daughters. I have spent over 13 years working for a Fortune 500 company in the computer area. I started in VB 6.0 and by the time I ended my employment I was supervising a development team where we built many web applications. When my first daughter was born I wanted to spend more time with her so I left and became a programmer analyst for local government as well as launch my own company. Since then I have grown James River Webs into a profitable web design and application company helping small businesses create a big presence on the internet. As an employee I have created web application used by citizens and other companies. I enjoy fly fishing, and spending time with my family. I also enjoy learning new approaches and development tools when it comes to developing applications.

Leave a Reply

Your email address will not be published. Required fields are marked *


× 6 = 42

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>