| This article will provide an example of how to create a | | | | your decision. At ASPHostDirectory, we pride |
| Shared Data Source and publish it to your Report | | | | ourselves in our commitment to our customers and |
| Server. You may use the data source while | | | | want to make sure they have all the details they need |
| developing reports in Report Designer and Report | | | | before making that big decision. |
| Builder 2.0 tools. For this example, we will be using SQL | | | | We will work tirelessly to provide a refreshing and |
| Server Business Intelligence Development Studio 2008. | | | | friendly level of customer service. We believe in |
| This article assumes the following: | | | | creativity, innovation, and a competitive spirit in all that |
| - SQL Server 2008 and Reporting Services installed | | | | we do. We are sound, honest company who feels |
| - Business Intelligence Development Studio (BIDS) or | | | | that business is more than just the bottom line. We |
| Report Builder 2.0 | | | | consider every business opportunity a chance to |
| - AdventureWorks database | | | | engage and interact with our customers and our |
| - Limited exposure to Reporting Services | | | | community. Neither our clients nor our employees are a |
| Create Report Server Project1. Open Business | | | | commodity. They are part of our family. |
| Intelligence Development Studio from Start >> All | | | | The followings are the top 10 reasons you should trust |
| Programs >> Microsoft SQL Server 2008 | | | | your online business and hosting needs to us: |
| >> SQL Server Business Intelligence | | | | - FREE domain for Life -ASPHostDirectory gives you |
| Development Studio | | | | your own free domain name for life with our |
| 2. From the menubar, select File >> New >> | | | | Professional Hosting Plan and 3 free domains with any |
| Project | | | | of Reseller Hosting Plan! There's no need to panic |
| 3. Select the Report Server Project template. Give the | | | | about renewing your domain as ASPHostDirectory will |
| project a name and save to your desired path location. | | | | automatically do this for you to ensure you never lose |
| 4. Click OK. | | | | the all important identity of your site |
| Set Deployment Properties1. From the Solution | | | | - 99,9% Uptime Guarantee - ASPHostDirectory |
| Explorer pane, right click and select Properties. | | | | promises it's customers 99.9% network uptime! We |
| 2. The Property Pages diaglog will open up. Enter the | | | | are so concerned about uptime that we set up our |
| following values for the properties: | | | | own company to monitor people's uptime for them |
| - OverwriteDataSources = False | | | | called ASPHostDirectory Uptime |
| - TargetDataSourceFolder = Data Sources | | | | - 24/7-based Support - We never fall asleep and we |
| - TargetReportFolder = DataSourceDemo | | | | run a service that is opening 24/7 a year. Even |
| - TargetServerURL = | | | | everyone is on holiday during Easter or Christmast |
| 3. Click OK. | | | | New Year, we are always behind our desk serving |
| Create Shared Data Source | | | | our customers |
| 1. From within the Solution Explorer pane, right click | | | | - Customer Tailored Support - if you compare our |
| Shared Data Sources >> Add New Data Source | | | | hosting plans to others you will see that we are |
| 2. Enter "AventureWorks" for the Name field. | | | | offering a much better deal in every aspect; |
| 3. For Type, select Microsoft SQL Server from the | | | | performance, disk quotas, bandwidth allocation, |
| dropdown list. | | | | databases, security, control panel features, e-mail |
| 4. For the Connection String, click the Edit... button on | | | | services, real-time stats, and service |
| the right of the textbox. The Connection Properties | | | | - Money Back Guarantee - ASPHostDirectory offers |
| dialog will prompt you for values. | | | | a ‘no questions asked' money back guarantee with |
| 5. Use the Server Name dropdown to select | | | | all our plans for any cancellations made within the first |
| your Server location, or if you are running it locally, | | | | 30 days of ordering. Our cancellation policy is very |
| simply enter a period "." (without the quotes) for a | | | | simple - if you cancel your account within 30 days of |
| value. | | | | first signing up we will provide you with a full refund |
| 6. For the Log on to the Server section, select Use | | | | - Experts in Reporting Service Hosting - Given the |
| Windows Authentication option. | | | | scale of our environment, we have recruited and |
| 7. For the Connect to Database section, select Select | | | | developed some of the best talent in the hosting |
| of enter database name option. Using the dropdown, | | | | technology that you are using. Our team is strong |
| find AdventureWorks database. | | | | because of the experience and talents of the |
| 8. Click the Test Connection button to test. You should | | | | individuals who make up ASPHostDirectory |
| received Test Connection Succeeded. | | | | - Daily Backup Service - We realise that your website |
| 9. Click OK to save changes. | | | | is very important to your business and hence, we |
| 10. Click OK again to close Shared Data Source | | | | never ever forget to create a daily backup. Your |
| Properties window. | | | | database and website are backup every night into a |
| You should see the AdventureWorks data source in | | | | permanent remote tape drive to ensure that they are |
| your Solution Explorer pane. | | | | always safe and secure. The backup is always ready |
| Publish Data Source | | | | and available anytime you need it |
| 1. Right click on the AventureWorks.rds >> Deploy | | | | - Easy Site Administration - With our powerful control |
| You can see the result. | | | | panel, you can always administer most of your site |
| What is so SPECIAL on Reporting Service | | | | features easily without even needing to contact for |
| Hosting?We know that finding a cheap, reliable web | | | | our Support Team. Additionally, you can also install |
| host is not a simple task so we've put all the | | | | more than 100 FREE applications directly via our |
| information you need in one place to help you make | | | | Control Panel in 1 minute! |