Arvixe and Reporting Services Deploying (Part 3 of 7)

In Part 1 of this series, we talked about SSRS in general and then in Part 2 confirmed SSRS was installed and configured properly. This article will show you how to use VS2012 Business Intelligence Reporting Services Template to deploy a Report to Arvixe. Although this process is the same no matter who is hosting SQL, this article is dedicated to Arvixe implementation. The first thing to do is to launch Visual Studio 2012 and select New Project and then Report Server Project (Figure 1)

SSRSDeploy1 Figure 1

A – Name of the Project
B – Leave as the Default
C – This is the name of Solution
D – Specify the Directory to hold this project.
E – Select this Template under Reporting Services
F – Chose Reporting Services.

2. After entering this then hit OK.
Once Visual Studio Creates the solution and project you should see this in the Solution Explorer. (Figure 2)
SSRSDeploy2

(Figure 2)

3. Right Click on Shared Data Sources and select Add New Data Source. (Figure 3)

SSRSDeploy3 (Figure 3)

4. Enter a name for the datasource (my example is datasource1)

5. Click on edit. Once you do this then a dialog like Figure 5 will come up. Enter the following options.

SSRSDeploy4aFigure 4

SSRSDeploy6Figure 5

A Server Name: This will be the server that your sql database is on. It will probably look like [xxx].arvixe.com
B This user name for the SQL Server that you can find in the Arvixe Control Panel of SQL Server. (Enter password right below)
C If you have configured everything properly then you should see a list of your databases.
D To make sure everything is configured properly you can click on ‘Test Connection’. If everything is correct you should see a screen telling you that the test passed successfully.

6. Press OK

7. Click on Credentials (This is an important step. Click on Use this user name and password and enter the user name and password from above step.) (Figure 6)

SSRSDeploy9Figure 6

Once you done this then you should then see this.

SSRSDeploy8Figure 7

NOTE: This datasource will be used on your reporting services server.

Build your report using this datasource (outside the scope of this article)

SETTING THE DEPLOYMENT PROPERTIES FOR ARVIXE.

To set up the Deployment properties specifically to Arvixe.

8. Right click on your project (in my case it is DeploySSRS. You should see the following (Figure 8)

SSRSDeploy10Figure 8

Click on Properties (Figure 9)

NOTE: Pay attention to the bolded items.

SSRSDeploy11Figure 9

OverwriteDatasets False
OverwriteDataSources If you want to overwrite the datasource on the server then set this to ‘TRUE’
TargetDatasetFolder Leave this as Datasets
TargetDataSourceFolder This is location will create a folder on the server and place the datasource you created from above. Normally I just leave this alone as well.
TargetReportFolder This is report location to place the report in on the server.
TargetReportPartFolder You can publish parts of a report, such as charts, tables, logos, and other such parts. End-users will have the ability, using Report Builder 3.0 to create reports using the published report parts. This identifies the location (folder) for those parts.
TargetServerURL This is the actual url that you received from Arvixe. This is what they call ‘Report Server Manager’ but it is not the whole url they provide. It is the first part so if you are given the following url http://trout.arvixe.com/ReportServer_SQL_Service/Pages/Folder.aspx?ItemPath=%2fanglertobe then you would enter http://trout.arvixe.com/ReportServer_SQL_Service. This is also the same part as verifying SSRS in part 2 of this series.
TargetServerVersion This is a good way to once again verify that everything is working well. Once you get all of the settings above then you can click on this and ask to verify the version. It will prompt you for login and password. This is the login and password to Reporting Services provided by Arvixe. (See Part 1 for details)

At this point you should be able to click on deploy and everything should deploy without errors.

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 = 2

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>