Issues with SSRS 2012 SharePoint Integrated mode and SharePoint 2010

2012-10-26 / SharePoint, SQL / 0 Comments

Problem:

I continued to run into issues with Kerberos and error message like Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ when using SharePoint Reporting Services and a SQL DB that I was reporting on a different server.

Solution:

When configuring Kerberos with previous SQL versions and SharePoint it was easy to set the delegation to “Trust this user for delegation to any service”. after setting SPNs you would be good to go.

However, with SSRS 2012 things have changed and SharePoint now uses the Claims To Windows Service to get authenticated correctly. I had it half way right and the fix was to add “trust this user for delegation to specified services only” on both the Claims To Windows Account and the SharePoint SSRS 2012 account. I found a sweet video on what needs to be done here:

http://technet.microsoft.com/en-us/video/Video/hh858469

Read More

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

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