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