Showing posts with label SharePoint. Show all posts
Showing posts with label SharePoint. Show all posts

05 February 2011

How to configure Reporting Services 2008 in SharePoint 2010

Requirments :
You should have SP1 CU7 to get RS 2008 to work with SP 2010.

Please follow these steps to integrate reportaing services with SharePoint:

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.

14 January 2011

Installing and configuring SharePoint 2010 with Web application and Site Collection

List of Prerequisites Software
  1. Windows server 2008 with SP 2 / Windows 7 / Vista
  2. Windows 2008 R2 and Windows Server 2008 KB971831
  3. WCF Fix article for Windows 2008 R2 and Windows 7 KB976462
  4. Microsoft SQL Server 2008 Native Client
  5. Microsoft "Geneva" Framework Runtime
  6. Microsoft Sync Framework Runtime v1.0 (x64)
  7. Microsoft Chart Controls for Microsoft .NET Framework 3.5
  8. Microsoft SQL Server 2008 Analysis Services ADOMD.NET
  9. SQL Server 2008 SP1
  10. .NET Framework 3.5 Service Pack 1 (Full Package) KB959209 KB967190


Create our top level web application 

07 January 2011

Common Microsoft SharePoint Server 2010 Installation Issues and Resolutions

ISSUE #1: when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

Failed to create the configuration database.
An exception of type System.Security.Cryptography.CryptographicException was thrown. Additional exception information: The data is invalid.

To resolve the issue you can perform the following steps:

Modify the ACL on the 14 directory under %commonprogramfiles\Microsoft Shared\Web Server Extensions.

Right-click on the folder %commonprogramfiles%\Microsoft Shared\Web Server Extensions\14, and then select the Security tab.
On the 14 Properties dialog under the Security tab, select Edit.
On the Permissions for 14 dialog click Add… and enter Network Service in the Enter the object names to select and then click OK.
On the Permissions for 14 dialog select Full Control under Permissions for NETWORK SERVICE and click OK.
On the 14 Properties dialog click OK.

NOTE
The previous steps are applicable only prior to running the SharePoint 2010 Products Configuration Wizard. If you have run the SharePoint 2010 Products Configuration Wizard, follow the steps below:

Open an elevated Command Prompt and change directories to %commonprogramfiles%\Microsoft Shared\Web Server Extensions\14 and enter psconfig –cmd –configdb disconnect to disconnect from the current configuration database.
Open SQL Server Management Studio or SqlCmd and delete the existing configuration database.
Follow the previous steps to modify the ACL on the 14 directory and run the SharePoint 2010 Products Configuration Wizard to create and configure the server farm.

NOTE
In the event the steps above do not immediately resolve the issue, open the Registry Editor and delete the "SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\FarmAdmin" Registry key and then run the SharePoint 2010 Products Configuration Wizard.

ISSUE #2: when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

An exception of type Microsoft.Office.Server.UserProfiles.UserProfileException was thrown. Additional exception information: Unrecognized attribute 'allowInsecureTransport'. Note that attribute names are case-sensitive. (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebClients\Profile\client.config line 56).

To resolve the issue you can perform the following steps:

Download and install KB976462 from http://support.microsoft.com/kb/976462 for Windows Server 2008 R2 or KB971831 from http://code.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=KB971831&DownloadId=7285 for Windows Server 2008 and run the SharePoint 2010 Products Configuration Wizard.

ISSUE #3: when running Setup.exe for Microsoft SharePoint Server 2010 you may experience the error:

Setup is unable to proceed due to the following error(s):
A system restart from a previous installation or update is pending. Restart your computer and run setup to continue.

To resolve the issue you can perform the following steps:

For the list of pre-requisites needed to install the product please refer to:
http://go.microsoft.com/fwlink/?LinkId=106209
Correct the issue(s) listed above and re-run setup.

Check the value of the following Registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\UpdateExeVolatile - if the value of the UpdateExeVolatile Registry key is anything other than 0 you will see this message.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations - if the PendingFileRenameOperations Registry key has any value you will see this message.

To remove an orphaned UpdateExeVolatile registry key value

Open a registry editor, such as Regedit.exe or Regedt32.exe.
Navigate to HKLM\SOFTWARE\Microsoft\Updates\
In the right navigation pane, double-click the UpdateExeVolatile key.
Configure the key with a value of 0
Close Registry Editor.
To delete the orphaned PendingFileRenameOperations registry key
Open a registry editor, such as Regedit.exe or Regedt32.exe.
Navigate to HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\
In the right navigation pane, right-click the PendingFileRenameOperations key and select Delete.
Close Registry Editor.

ISSUE #4: when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

Failed to register SharePoint services.
An exception of type System.ServiceProcess.TimeoutException was thrown. Additional exception information: Time out has expired and the operation has not been completed.
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)

Run Setup.exe when the steps above have been completed.

To resolve the issue you can perform the following steps:

Download and install KB976462 from http://support.microsoft.com/kb/976462 for Windows Server 2008 R2 or KB971831 from http://code.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=KB971831&DownloadId=7285 for Windows Server 2008 and run the SharePoint 2010 Products Configuration Wizard.

ISSUE #5: when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

Error: Cannot add the specified assembly to the global assembly cache: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\policy\Policy.11.0.Microsoft.SharePoint.dll.

To resolve this issue you can perform the following steps:

Delete the contents of %commonprogramfiles%\Microsoft Shared\Web Server Extensions\14\policy\ and run the SharePoint 2010 Products Configuration Wizard.

ISSUE #6: when running Setup.exe for Microsoft SharePoint Server 2010 you may experience the following error:

The language of this installation is not supported by your system

This issue is largely caused by corruption of the binaries, you can use the extract command in a Command Prompt and check the log to determine the health of the binaries; otherwise, download a new copy of the binaries and retry setup.

Thanks to Bill Baer
Technical Product Manager (SharePoint), Microsoft Certified Master for SharePoint 2007, Microsoft Corporation.