SharePoint Report Error: Cannot create a connection to data source ‘dataSource1’.

2010-05-10 / SharePoint, SQL / 1 Comments

Problem:
You recieve the following error when running a report from report builder.

Report Execution error the report might not be vaild or the server could not process the data.
for more information about this error navigate to the report server on the local server machine, or enable remote errors
—-
Cannot create a connection to data source ‘dataSource1’.

An error has occurred during report processing.

 

Resolution
In my case the problem was the login that was used when running the report did not have access to the catalog and the sql server. I granted the correct access to the databases in sql manager and the user was able to run the report.

Read More

Installing Reporting Services 2008 SharePoint Add-on

2010-03-05 / SharePoint / 0 Comments

When installing rsSharePoint_x64.msi I always run the setup with:

“rsSharePoint_x64.msi SKIPCA=1”

This will install the files but will not configure the service. After running the SKIPCA command we can run the rsCustomAction.exe from the %temp% directory on the server with the following commands:

rsCustomAction.exe /i

You need to run this under the setup account used for SharePoint with approprate security.

This will begin to install the reporting service add-on. Once complete the dos box will prompt with:

Calling HCInstal for lcid ‘1028’
 Outcome code is: 4

Cab files installed successfully.
Stopping W3SVC service.
Starting W3SVC service.
The command completed successfully

Read More

How To Slipstream SQL 2008 with SP1

2010-03-04 / SQL / 0 Comments
Procedure 1: Basic slipstream steps


Follow the following steps to create a slipstream drop that you can use for installing the original media and a service pack at the same time.

  1. Install the following prerequisites for SQL Server 2008.
    1. .NET Framework 2.0 SP2 for SQL Server 2008 Express Edition
      You can obtain the .NET Framework 2.0 SP2 from the following Web site in Microsoft Download Center:
      http://www.microsoft.com/downloads/details.aspx?FamilyID=5b2c0358-915b-4eb5-9b1d-10e506da9d0f&displaylang=en
    2. .NET Framework 3.5 SP1 for other editions
      To download and install the .NET Framework 3.5 SP1, visit the following Microsoft Web site:
    3. Windows Installer 4.5
      To download and install Windows Installer 4.5, visit the following Microsoft Web site:
    4. Download the service pack package that matches you system architecture. For example download the x64 package of SQL Server 2008 Service Pack 1 if your system is an x64-based system.
  2. Extract the service pack by running the following command:
    SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SP1
  3. Run the service pack to install Setup files on the computer. You will receive a Setup Support Files dialog box if the Setup support files have not been installed. You can also run the following file to install the setup support files:
    C:\SP1\x64\setup\1033\sqlsupport.msi
  4. Run the Setup.exe file from the SQL Server 2008 source media by specifying the /PCUSource parameter. For example:
    Setup.exe /PCUSource=C:\SP1
 
Read More

Installing and Configuring MOSS 2007 and SQL 2008

2010-02-24 / SharePoint / 0 Comments

When installing SharePoint on the initial servers we need to do an full install as follows:

1. Install from CD ->Click Advanced

Click Complete and Finish Install

When setting a service account as the application pool you must grant DCOM permissions as follows

—-
You may see this error – more than once – when working with your Microsoft Office SharePoint Server (MOSS) 2007 deployment. This animal / error generally shows itself after you have applied an upgrade to an existing deployment. For example, when upgrading from B2 MOSS to B2TR MOSS – or when applying a special service pack from MSFT – you may begin to see a lot of these errors pop up in the SYSTEM event log.

The error CLSID is followed by a class ID for the DCOM+ application that the service account trying to activate that application – does NOT have permission to activate.

For example, let’s say I installed MOSS on a server, and used the account mossService as the service account (a least privileged, user account you created to run the MOSS service(s))., when I get this error, I could very well see an error like the following:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{61738644-F196-11D0-9953-00C04FD919C1}

to the user <serverName>\mossService SID (S-1-5-21-<serviceSID>). This security permission can be modified using the Component Services administrative tool.

Copy the GUID following the CLSID above, and Start–>Run–>regedit

With the registry editor open, ensure that your cursor is on the computer at the beginning of the tree (make sure you are not in the middle of some previous edit session in the registry editor).

Edit–>Find and paste in the GUID. It’ll stop at the application entry – and you will want to note the application name on the right side pane. In this example, it was the IIS WAMREG admin service that popped up.

Now, open Component Services (typically, from the server – Start–>Administrative Tools–>Component Services), expand Component Services, Computers, My Computer, DCOM Config. Scroll down and find the application (IIS WAMREG in this case). Right-Click–>Properties and select the Security tab. You’ll have some options here – the first block Launch and Activation Permissions – ensure that the Customize radio button is selected, and click Edit. Now, add your service account – giving it launch and activate – and in some requirements – remote launch / activate permission.

Restart IIS and continue on.

NOTE: This is not applicable to MOSS setups only – and hopefully this will help someone else that sees these annoying DCOM errors in their SYSTEM event log.
—–

Read More