Connecting to Reporting Services in SSMS as an admin - If you do not see some options are disabled

 If the options or menus for the jobs, security or shared schedules etc. are disabled, then you need to connect to SSRS via SSMS as an admin.

Problems related to Exercises 1-3 in pp. 557 - 560 (the TK 70-448 book)

I keep getting the error message: an error occurred during client rendering an error occurred during report processing. Cannot create a connection to data source 'xxxxx'.

To fix the problem, change the instance to the mixed mode authentication. In this way, the SQL Server login ReportExecution should be fine.

Note 1: The database should the AdventureWorks2008 or AdventureWorks2008R2, not the DW ones.

Note 2: The user in the msdb does not need to be in the db_datawriter role.

Note 3: The UNC path for a local folder could be: \\MachineName\theSharedFolder, localhost should be OK too to replace the MachineName.

Note 4: The credential for accessing the shared folder on p.560 should be the Windows user created earlier.

Finally solved- "Error while loading code module: 'ReportCustomMethods, version=0.0.1.1, culture=neutral, PublicKeyToken=null' Details: Could not load file or assembly "TK 448 Ch11 CustomAssembly", Version=0.0.1.1 ... or one of its dependencies. The system cannot find the file specified."

Problem:

I have both VS 2008 and 2010 on my Win 7 PC, and have used VS 2008 and SQL Server 2008R2 for Exercise 4 - Use Methods from a Custom Assembly on p.514 of the TK-448 book, but I got the error as in the title.

Solution:

Copy the .dll file to the right place as below:

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies
(not the one in C:\Program Files\...........)

Errors in the encryption library: Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change.


Problem:

Encounter the error as shown in the titile when processing a cube.

Solution:


  1. Stop the SSAS service
  2. Make a backup of the project: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\TK 448 Mining Models Project.0.db
  3. Delete SSAS database, that is, delete the contents of C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\TK 448 Mining Models Project.0.db directory.
  4. Delete the "TK 448 Mining Models Project.0.db.xml" from the project data folder "..Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\"
  5. Start the SSAS service again and deploy/process your cube again using BIDS.


How to Fix the problem - No Data for the 5 views in AdventureWorksDW2008R2


Problem:

Today, I found there are no data for the 5 views in the AdventureWorksDW2008R2 database.

Solution:


  1. Detach the current AdventureWorksDW2008R2 (disconnect the current connection first if necessary)
  2. Run the codes below  in the Instawdwdb file (from the downloaded AdventureWorks 2008R2 Data Warehouse) in SQLCMD mode.
  3. Change the file path if necessary based on the error messages.


Note: 

:setvar SqlSamplesDatabasePath   "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\"
(the mdf and ldf files may need to be deleted from this location for re-run)

:setvar SqlSamplesSourceDataPath "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008R2 Data Warehouse\" (the last part is the path on my machine - this is where all of the data files are)

/*======================================================================
  File:     instawdwdb.sql

  Summary:   Creates the AdventureWorks 2008R2 data warehouse sample database.

  Date:     June 14, 2008
  Updated: March 28, 2012

  -- TODO: Verify
  SQL Server Version: 10.50.1600
------------------------------------------------------------------------------
  This file is part of the Microsoft SQL Server Code Samples.

  Copyright (C) Microsoft Corporation.  All rights reserved.

  This source code is intended only as a supplement to Microsoft
  Development Tools and/or on-line documentation.  See these other
  materials for detailed information regarding Microsoft code samples.

  THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY
  KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
  IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
  PARTICULAR PURPOSE.
=======================================================================*/

-->> WARNING: THIS SCRIPT MUST BE RUN IN SQLCMD MODE INSIDE SQL SERVER MANAGEMENT STUDIO. <<--
:on error exit

/*
 * In order to run this script manually, either set the environment variables,
 * or uncomment the setvar statements and provide the necessary values if
 * the defaults are not correct for your installation.
 */

:setvar SqlSamplesDatabasePath   "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\"
:setvar SqlSamplesSourceDataPath "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008R2 Data Warehouse\"
===================

The rest are omitted