ASPHostDirectory.COM Cheap Reporting Service (SSRS) Hosting

Blog about Reporting Service (SSRS) Hosting and all its latest technology

ASPHostDirectory SSRS 2008 Hosting :: Steps to Solve SSRS SQL 2008 R2 User Access Control (UAC) Permissions Error

clock October 29, 2010 10:26 by author Darwin

This article contains brief tutorial about SSRS 2008. In case you’re looking SSRS 2008 hosting, you can try ASPHostDirectory as the alternatives. Only with $ 3.99/month to get hosting with us. Don’t waste this opportunity.

With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) that will assist in prohibiting unauthorized entry into SQL Server Reporting Services. Although UAC can be disabled, working within the parameters of the new technology will strengthen the security within your company infrastructure.

There is a new process that you may run into involving SSRS for SQL Server 2008 R2 when used with Vista and/or Windows 7.  There are new UAC security steps that are used during the validation process for Report Manager.

If you receive the following error when trying to make the connection to your Report Manager:

 

Follow the steps below:

Go to the report server and navigate to the following;  Start --> Administrative Tools --> Computer Management. Then Under Local Users and Groups you will see the screen below. Add the NT AUTHORITY\Authenticated Users  to the SQLServerReportServerUser group

 

Once this is done, open IE browser from the server and go to http://localhost/Reports. This will bring up Report Manager in the Home folder and display a few option. 

From the Report Manager screen, click on Folder Settings, then go add NT AUTHORITY\Authenticated Users to this group on the root folder (This can be substituted for any other group that contains all users that will be allowed access to the Report Manger)

 

Once these steps are completed, you should be able to return to the Vista and/or Win7 PC and access the Report Manager. For further permission, add specific users to each folder as you normally would. As long as Authenticated Users is in the group on the server, then each user within AD should have access once granted within Report Manager

What is so SPECIAL on ASPHostDirectory.com SSRS 2008 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 SSRS 2008 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!



ASPHostDirectory SSRS 2008 R2 Hosting :: Centralize and Control Data Access in SSRS 2008 R2

clock October 22, 2010 07:19 by author Darwin

Problem

Reporting is a common and frequent requirement of any business practice and often reports are developed by business users as well as the IT department of the organization. Data Source and Data Sets are two major entities used in any report development using SQL Server Reporting Services (SSRS) whether the report is developed using Business Intelligence Development Studio (BIDS) or report builder. To keep a track and control of the data access logic implemented on a report level, it becomes very necessary to centralize access to data from the report server for better maintenance, reducing repetitive efforts and efficient use of resources. In this tip we would take a look at how we can address this using SSRS 2008 R2 and BIDS.

Solution

Use of Shared Data Source and Shared DataSets in report development can help to centralize data access using SSRS 2008 R2. Shared Datasets is a new enhancement introduced in SSRS 2008 R2 version, and we will take a look at how this can be implemented and how this can help to improve the reuse of existing logic. We will be using the term report level dataset or data source and shared dataset or datasource frequently in the discussion ahead. By report level data source or dataset, it means a dataset or data source that is embedded in the report and is available only to the report in which it is created. Also please keep in mind that this article assumes some working level of knowledge of SSRS.

To get an idea of the problem in question, follow the below steps to create an exercise which will help us get a view of the problem in question.

1) Create a new SSRS project using BIDS and name it something relevant.

2) Create a shared data source as shown in the below screenshot, by right-clicking the Shared Data Sources folder in the solution explorer pane and selecting Add New Data Source.



3) Create a shared dataset as shown in the below screenshot, by right-clicking on Shared Datasets folder and selecting Add New Dataset. Keep in mind that shared datasets can be created only from a shared data source and they have the extension of ".rsd".



4) Create three different reports named SharedRep1, SharedRep2 and SharedRep3.

5) In SharedRep1 report create a dataset from the Shared Dataset as shown in the below screenshot. As you will be creating a report level dataset from the shared dataset, you will not be required to create an embedded data source at the report level.



6) For SharedRep2 report, create a report level data source from the shared data source and a dataset embedded at report level from the same. And for SharedRep3 report, create a data source and dataset at the report level. After you have done this, the report data pane should look like the below screenshot. Sections marked as 1, 2, and 3 represent the Report Data section of reports SharedRep1, SharedRep2 and SharedRep3 respectively.



7) Add some data on the report and deploy this solution on the report server. Navigate to the report manager and you should be able to find your reports, a folder named Data Source and Datasets. Navigate to the Shared Data Source which we have named "SharedDS" and you should be able to see options as shown in the below screenshot.



All the reports using this data source can be controlled just by managing this single data source. One key advantage of this shared data source is that you can disable processing of all the reports using this data source just by disabling it. Also when reports are moved across environments like Development to QA, and QA to Production, it becomes very easy to manage and control data source access of all the reports using this data source.

8) Navigate to the Shared Datasets folder and click on the shared dataset "SharedDS" and you should be able to see the options as shown in the below screenshot, where Dependent Items tab is selected. This helps to make an impact analysis of reports that would be affected when any change is made to this dataset. Finally, if you have business users who need access to complex datasets created by some complex logic, the same can be shared as a shared dataset and it can be used from Report Builder too by business users.



So in summary, a Shared Data Source helps to control and centralize data source connections of multiple reports using a single connection and thus making maintenance easier. And Shared Datasets help to centralize and reuse dataset logic, for IT Developers and Business Users of any organization. Follow the next steps mentioned below to experiment with the results of the above exercise.

Next Steps

1. Disable the shared data source, and check which reports still continue to execute. Try changing the reports data source to the shared data source for those reports which still continue to execute.

2. Try using the shared dataset from Report Builder 3.0 for a new report.

What is so SPECIAL on ASPHostDirectory.com SSRS 2008 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 SSRS 2008 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!



ASPHostDirectory SSRS Hosting :: Configuring Reporting Services for SharePoint 3.0 Integration

clock October 6, 2010 11:20 by author Darwin

You can configure a deployment of SQL Server Reporting Services to work with a deployment of Microsoft Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. You must perform configuration steps on both a report server and a deployment of the SharePoint product or technology before users can publish reporting documents to SharePoint libraries and get report viewing and management services on SharePoint sites. The configuration process establishes server connection information; therefore, it is important that you follow the steps in order.

Overview of Configuration Steps on a Report Server

To configure a report server for SharePoint integration, you must have an existing stand-alone report server or a scale-out deployment. You must perform the following tasks on the report server:

1. Create a report server database in SharePoint integrated mode.
This sets server properties on the report server and activates a new SOAP report server management endpoint that is used for integrated operations. Use the Reporting Services Configuration tool to create the database.

2. For deployments that include a SharePoint server farm, install a Windows SharePoint Services Web front-end on the report server computer. The Web front-end joins the report server computer to a SharePoint farm. Installing the Web front-end on the report server computer is only necessary if you deploy the report server and the SharePoint technology instance on separate computers.

3. For deployments that include placing the SharePoint databases on the same computer as the report server, configure the Report Server service to run under a domain account. This step is only necessary if the report server and application

About the Report Server Database

A report server database provides internal storage for one or more report server instances. A report server database can support native mode operations or SharePoint integration mode, but not both. The contents in the database are mode-specific and are not interchangeable across server modes. If you create a report server database to support SharePoint integrated mode, you cannot automatically convert or migrate the database to run with a native mode report server instance later. A report server database is used in the following ways depending on the server mode:

- When created for native mode operations, the report server database is the sole repository for persistent data used by the report server.

- When created for SharePoint integrated mode, the report server database stores server properties, report execution snapshots, report history, subscription definitions, and schedules. It stores a secondary copy of reports, report models, shared data sources, and resources to improve processing performance on the server. Primary storage for report documents is in the SharePoint content databases.

Creating a report server database for SharePoint integrated mode is an important first step in configuring the report server for SharePoint integration. You can use the Reporting Services Configuration tool to create the report server database and configure the connection to the report server. Only the report server connects to the report server database. The Windows SharePoint Services or Office SharePoint Server instance never connects to or retrieves data from the report server database.

About Report Server Scale-out Deployment and SharePoint Integrated Mode

If you are integrating a report server scale-out deployment with a SharePoint server farm, all report server instances that are part of the deployment must run in SharePoint integrated mode. You cannot have a combination of server modes in the same scale-out deployment. Furthermore, you must create a single point of entry to the scale-out deployment (that is, a URL that resolves to a virtual IP for an NLB cluster on which the report server instances are installed).

About Multiple Report Server Instances and SharePoint Integrated Mode

If you are installing multiple instances of Reporting Services on a single computer, but only configuring one of those instances for SharePoint integrated mode, be sure to do the following:

- Ensure that all instances of Reporting Services are the same version. SQL Server 2008 Reporting Services (SSRS) introduces an updated version of the Reporting Services Windows Management Instrumentation (WMI) provider. You cannot have SQL Server 2008 Reporting Services (SSRS) and pre-SQL Server 2008 Reporting Services (SSRS) versions on the same computer. Therefore, it is necessary that all report server instances run SQL Server 2008 Reporting Services (SSRS) or later, even if you do not require SQL Server 2008 Reporting Services (SSRS) features for all of the instances.

- If you run SQL Server 2008 Setup for each report server instance at different times, restart the WMI service after you install the second instance of SQL Server 2008 Reporting Services (SSRS).

Overview of Configuration Steps on a SharePoint Server

To configure integration on the server running the SharePoint product or technology, you must do the following:

1. Download and install the Reporting Services Add-in for SharePoint Technologies.
The add-in installs program files and application pages, including pages that you open in Central Administration to set the report server URL and other integration settings. You can specify report server integration settings for a SharePoint farm or a stand-alone SharePoint Web application.

2. Activate the report server feature if you did not install the add-in on a root site collection.

3. Use SharePoint Central Administration to configure report server integration. Configuration settings include specifying a single report server URL, setting an authentication type on requests directed to the report server, granting database access permissions to the Report Server service account.

4. Optionally, in SharePoint Central Administration, you can set report server defaults that enable logging, ad hoc reporting, and limits for report history and time-out values.

SharePoint products and technologies can be deployed as a farm or as a stand-alone server. A farm contains one or more virtual servers, where each virtual server is a SharePoint Web application. A report server integrates at the farm level. From the perspective of storage integration, there can only be one report server database for a farm. You can use SharePoint Central Administration to manage integration settings for all the servers in the farm.

Each SharePoint Web application in a farm can be configured to use different authentication providers. This does not affect report server integration in any way. The report server deployment will handle requests for each server in the farm regardless of the authentication provider it uses.

Each Web application has a default top-level site. You can set permissions differently on each top-level site to vary the availability of report server items and operations across all the servers in a farm.

Service Account Configuration

A report server is implemented as a single Windows service that runs under a built-in account or a local or domain Windows user account. In SharePoint integrated mode, the service must connect to the SharePoint content databases with write and execute permissions. Because the service connects to the SharePoint content databases, the account that you use to run the service will have different requirements depending on whether remote connections are used and whether the report server URL proxy endpoint connection uses Windows integrated security or Trusted Account mode.

About SharePoint Service Account Configuration

Service account recommendations for Windows SharePoint Services and Office SharePoint Server state that for a server farm deployment you should run the application pool process as a domain user account, and not as Network Service. Although a domain user account is recommended, it is not required. However, it is important to realize that if you configure a SharePoint Web application to run as Network Service, and the report server is on a remote computer, you will encounter errors when accessing reports and report server features from a SharePoint site if the report server URL proxy endpoint connects in Trusted Account mode.

What is so SPECIAL on ASPHostDirectory.com Sharepoint 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 Sharepoint 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!



ASPHostDirectory.com SSRS Hosting :: How to Display Row and Column Headers on Multiple Pages

clock July 29, 2010 06:57 by author Darwin

To repeat rows with column headings in a column group area

1. In Design view, right-click the corner handle for a selected tablix data region, and then click Tablix Properties.

2. On the General tab, under Column Headers, select Repeat header columns on each page.


3. Click OK. 

4. Preview the report. The rows that contain the column headings repeat at the start of each page

To repeat rows with column headings for a table with row groups

1. In Design view, select the table. The Grouping pane displays the row groups.


2. On right side of the Grouping pane, click the down arrow, and then click Advanced. The Grouping pane displays static and dynamic tablix members for each group. You can only set properties on a static tablix member.


3. In the Row Groups pane, click the static tablix member for the row that you want to repeat. When you select a static tablix member, the corresponding cell on the design surface is selected, if there is one. The Properties pane displays the properties for the selected tablix member.

4. Set the KeepWithGroup property in the following way:
- For a static row that is above a group, click After
- For a static row that is below a group, click Before.

5. Set the RepeatOnNewPage property to True.

6. Preview the report. If possible, the row repeats with the group on each vertical page that the row group spans.


To repeat columns with row headers in a row group area

1. In Design view, right-click the corner handle for a selected tablix data region, and then click Tablix Properties.


2. On the General tab, under Row Headers, select Repeat header rows on each page.


3. Click OK.


4. Preview the report. If possible, the columns that contain the row headers repeat on each horizontal page.


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!

 



ASPHostDirectory.com SSRS Hosting :: Microsoft CRM 4.0 SSRS 2008 Integration

clock July 27, 2010 05:30 by author Darwin

Setup CRM Data Connector for SSRS 2008 Scaled Out Deployment

The CRM Data Connector acts as a IFD authentication service for SSRS.  The setup wizard is straight forward but there are two potential snags

The first snag is that the Data Connector setup can’t automatically handle a Scaled Out deployment which you almost certainly will be using.  To work around this you must run the Data Connector from the command prompt and specify the install-config.xml file and path.  The Data Connector install-config.xml file tells the setup program where the instances of SSRS are located.  Were you to run the setup program without specifying the install-config.xml file you would get the following error:

Error message in the Environmental Diagnostic wizard when you try to install the Microsoft Dynamics CRM Connector for SQL Server Reporting Services: “Unable to validate SQL Server Reporting Services Report Server installation”

Here are the instruction for modifying the install-config.xml and running setup from the command line.

1. Copy all the files in the SrsDataConnector folder on the installation CD to a folder on drive C. For example, copy the files to the following folder:

C:\SrsDataConnector

Note The SrsDataConnector folder is located in the following folder on the installation CD:

drive:\Server\i386

The drive placeholder represents the CD drive.

2. Locate the folder in which you copied the installation files. Right-click the Install-config.xml file, and then open the file in Notepad.

3. Add the following information to the Install-config.xml file:

The reportserverurl tags

The URL for the server that is running SQL Server 2005 Reporting Services

For example, if the server that is running Reporting Services has a named instance of Titan, the reportserverurl tags resemble the following example.

<reportserverurl>http://servername/Reportserver$Titan</reportserverurl>

If the server that is running SQL Server 2005 Reporting Services has a named instance, modify the instancename tags.

For example, if the server that is running Reporting Services has a named instance of Titan, the instancename tags resemble the following example.

<instancename>Titan</instancename>

After you complete steps 3 and 4, click Save on the File menu, and then close the Install-config.xml file.

Open a Command Prompt window, and then locate the folder in which you copied the installation files in step 1.

At the command prompt, type the following command, and then press ENTER:

C:\SrsDataConnector> SetupSrsDataConnector /CONFIG path of the folder that contains the Install-config.xml file\install-config.xml

The second item to note is that it’s important to choose the “Update installation files”, when the setup wizard first runs. Basically, the process will fail if you don’t choose this option.

You can read further information at http://support.microsoft.com/kb/947060

Map SSRS2008 Web Service URL to work with a named instance

When you install Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008 and SQL Server 2008 Reporting Services all on the same server, you may receive the following error message:

“The specified path is not a metabase path.” Platform Error: System.Exception: Action Microsoft.Crm.Setup.Server.RSConfigAction failed. —> System.ArgumentException: The specified path is not a metabase path.

This issue occurs when the path of Reporting Services does not exist on the server.

To work around this issue, create a Web site that runs on the same port and the same URL that the Reporting Services server is using. In SQL Server 2008 Reporting Services, IIS is not used for accessing reports. However, if Microsoft Dynamics CRM 4.0 is installed on the same server, Microsoft Dynamics CRM 4.0 must find a Web site that has the same URL to bypass the error. To verify the URL of Reporting Services, follow these steps:

1. Click Start, click All Programs, click Microsoft SQL Server 2008, click Configuration Tools, and then click Reporting Services Configuration Manager.

2. Click connect to connect to your report server instance.

3. Click the Web service URL, and see what the report server Web service URL is. For example, the URL may be http://SQLServername:8181/ReportServer.

In Windows Server 2008, follow these steps:

1. Click Start, click Run, and then type inetmgr.

2. Expand the server name, right-click Sites, and then click Add Website.

3. Enter a name for the site, and then select a physical path.

4. Enter the port number of the report server Web service. For example, enter 8181.

5. Click OK.

In Windows Server 2003, follow these steps:

1. Click Start, click Run, and then type inetmgr.

2. Expand the server name, right-click Web Sites, click New, and then click Web Site.

3. Enter a description for the site, and then click Next.

4. Enter the port number of the report server Web service. For example, enter 8181, and then click Next.

5. Enter a path for the Web site, and then click Next.

6. On the Permissions page, click Next.

7. Click Finish.

Configure Microsoft Dynamics CRM with Deployment manager

1. Configure the Microsoft Dynamics CRM Application to point to the new SQL Server and SQL Server Reporting Services. To do this, follow these steps:

2. On the computer that is running Microsoft Dynamics CRM Server, click Start, point to All Programs, point to Microsoft Dynamics CRM, and then click Deployment Manager.

3. Click Organizations.

4. Right-click the organization that you moved to the new computer that is running SQL Server, and then click Disable.

5. Right-click the organization that you disabled, and then click Edit Organization.

6. Type the new name of the SQL Server and the new URL for the SQL Server Reporting Services server.
Note This step publishes the reports that are in Microsoft Dynamics CRM to the new computer that is running SQL Server Reporting Services server that you specify.

7. Click Next two times, and then click Apply.

Right-click the organization that you disabled in step 4c, click Enable, and then click Yes.

Use embedded data-sources

Microsoft CRM 4.0 does not support shared data-sources which is basically the default for SSRS2008.  Be sure to change any shared data-sources to embedded data-sources as follows:

1. Open the report in Report Designer.

2. On the Data tab, click the lookup button to the right of the Dataset list.

3. Click the lookup button to the right of the Data Source list.

4. Click to clear the Use shared data source reference check box.

5. Click Edit to the right of the Connection box.

6. In the Server name box, type the server name. Then, select the authentication method and the correct database name.

7. Click OK two times.

8. On the File menu, click Save as.

9. Save the report on the Microsoft Dynamics CRM server, and then add the report.

Rollup 2 is required if you are using stored procedures in your reports

When you attempt to run a report from CRM 4.0 you likely will receive the following error:

“Query execution failed for data set dsNorthwind”.

There are two possible solutions for this.  Either apply the hotfix found in the link below or apply Rollup 2 for Microsoft CRM 4.0.  Since Rollup 2 for Microsoft CRM 4.0 includes the aforementioned hotfix we recommend this approach.  Also to get the hotfix files separate from Rollup 2 you will have to contact Microsoft.

For more information, please visit http://support.microsoft.com/kb/956852

Conclusion

If you’re looking for SSRS 2008 hosting, you can choose ASPHostDirectory to host your site. You can start as low as $ 3.99/month to get SSRS 2008 hosting. We guarantee it.



ASPHostDirectory.com SSRS Hosting :: Creating a Shared Data Source in SSRS 2008

clock July 26, 2010 06:12 by author Darwin

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 in Report 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 to Reporting 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 Microsoft SQL Server from the dropdown list.

4. For the Connection String, click the Edit... button on the right of the textbox. The Connection Properties dialog will prompt you for values.

5. Use the Server Name dropdown to select your Server 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!

 



ASPHostDirectory.com SSRS Hosting :: Using SSRS 2008 x64 with MYSQL

clock July 15, 2010 06:24 by author Darwin

Are you looking for SSRS 2008 hosting? Find the best, quality, and cheap SSRS 2008 hosting at ASPHostDirectory. Only with $ 3.99/month  to get SSRS 2008 hosting. The article below describes brief information about how to using SSRS 2008 x64 with MYSQL.

Here we go:

1. Download and Execute onto the server that is hosting your Report Manager
mysql-connector-odbc-5.1.6-winx64.msi.

2. Once that is installed then Confirm the driver is being recognized:
A.Go to Start/Administrative Tools/Data Sources (ODBC)
B. Select the Driver tab and validate it is in the list.

3. Setting up the System DSN for the MYSQL Connection will allow you to create a MYSQL data source in Report Manager.
A.Go to Start/Administrative Tools/Data Sources (ODBC)
B. Select System DSN tab
C. Press Add
D. Select the MySQL Driver in the list and press Finish
E. Fill in the goodies and Test

4.Log onto your Report Manager
A.Create a new Data Source
B. Select ODBC for Data Source Type.
C. In the Connection String box type DSN=(Your DSN Name you gave the mysql connection)
D. Select Credentials stored securely in the report server, pass your user name and password for the mysql connection.

You should now be able to you this data source to post reports using the mysql database.

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!

 



ASPHostDirectory.com SSRS Hosting :: How to configure Reporting Services 2008 in SharePoint 2010

clock July 13, 2010 07:58 by author Darwin

If you have a SharePoint 2010 site and you navigate to site settings and try to click on "Managed Services Schedule" you will get this error:Unsupported Reporting Services Functionality

This is because your SharePoint configuration is not configured with Reporting services server.

To fix that, follow below steps:

1) Login to the Reporting Services server and make sure that the service is up and running, and double check that the reporting server is working:

a) Open SQL Reporting configuration manager
b) Select Report Manager Url.
c) click on the url to make sure it is working.
For example: http://SERVERNAME/Reports/

2) Open SharePoint Central administration:

a) Select General Application Settings.
b) Select Reporting Services Integration.
c) Set the report server url.
d) Select authentication mode, Windows if the reports show personalized data.
OR select the trusted account that will be used for impersonation.
e) Click on Ok, You will get a successful page.
f) You might get the following error:
"Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages"

This means that the SSRS is not configured to run with SharePoint Integrated Mode, to change it,read below article "Overview of Configuration Steps on a Report Server":
http://technet.microsoft.com/en-us/library/bb326356.aspx

3) Go to your sharepoint site settings and enable Report Integration feature on site collection features.

4) Go to your site and add reporting services webpart in your page and configure it to your report.

Note: It is recommended to have a library that has all your reports in one place and all SQL Reporting services webparts are connecting to this library.

Conclusion

If you looking for SSRS 2008 hosting, entrust your site to ASPHostDirectory. You’ll get the best service with an affordable price. We guarantee that!!

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!

 



ASPHostDirectory.com SSRS Hosting :: 5 Cool New Features in SQL Server 2008 R2

clock July 3, 2010 06:48 by author Darwin

It hardly seems possible, but SQL Server 2008 R2 is almost ready. Like most R2 releases, SQL Server 2008 R2 builds on the functionality of the base SQL Server 2008 release by improving scalability as well as BI features. Here are five of the most important features you should watch for in SQL Server 2008 R2:

1. Support for 256 logical processors
Organizations pushing the high end of scalability will want to take advantage of SQL Server 2008 R2 support for up to 256 logical processors (which requires Windows Server 2008 R2). This is a big improvement over the previous maximum of 64 processors.

2. Improvements in multi-server management
SQL Server Management Studio (SSMS) has always been great for managing SQL Server. However, SSMS was really for single server management and wasn’t strong in the area of multi-server management. New wizards, dashboards, and enhancements to Policy Based Management will boost SQL Server 2008 R2’s multi-server management capabilities.

3. Master Data Services
Almost all large organizations face the problem of multiple data definitions where the same data is defined and used differently in various locations. SQL Server 2008 R2’s new Master Data Services (MDS) feature provides a central portal from which administrators can create and update master data members and hierarchies, with the goal of ensuring data consistency across the enterprise.

4. Geospatial visualizations in Reporting Services
Building on the geospatial data types in the base SQL Server 2008 release, SQL Server 2008 R2’s Reporting Services will support reports with visual geographic mapping. New geospatial features include visualizations for mapping routine and custom shapes and support for Microsoft Virtual Earth tiles.

5. Self-service BI with Project Gemini
Project Gemini is the core feature of the SQL Server 2008 R2 release. Its goal is to enable organizations to more easily adopt and take advantage of SQL Server’s BI capabilities. It provides self-service BI through a powerful Excel add-in and integrates with SharePoint for centralized management. Project Gemini will require Excel 2010 and SharePoint 2010. For more about Gemini, check out Sheila Molnar’s interview of Microsoft’s Donald Farmer, InstantDoc ID 102613, in this issue of SQL Server Magazine.

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!

 



ASPHostDirectory.com SSRS Hosting :: New Data Visualizations in SQL Server Reporting Services 2008 R2

clock July 3, 2010 06:44 by author Darwin

New Data Visualizations in SQL Server Reporting Services 2008 R2 how they can help you effectively communicate insights in your data.

Maps.  Maps can be very powerful visualizations.  They can consume and visualize SQL Server geospatial and geometry data directly “regular” data, and combine multiple datasets using map layers.  Maps can integrate ESRI shape files, as well as directly integrate with Bing Maps. 

Sparklines.  Sparklines are defined as “data intense, word-sized graphics” and are commonly used in tables to show trends. 

Data Bars.  Data bars, much like sparklines, are small charts typically found in the cells of a matrix or table.  Instead of containing many values though, they usually contain one or just a few values.

Indicators.  Indicators are small icons you can use to denote status or trends in your reports. While Report Builder 3.0 contains several pre-configured indicators, you can mix and match icons from different indicator sets to create your own unique sets.  You can even provide your own images to be used as indicators!  Indicators can also be embedded inside gauge report items. 

If you like to host your SSRS 2008 R2 hosting, you can choose ASPHostDirectory as the alternatives. You can get the best service wit an affordable price.

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!