Setup Instructions

Follow these steps to create the MAUDF objects within a PPSMonitoring database

Enable the CLR

In order to enable the CLR on the SQL Server where the PPSMonitoring database is located run the following T-SQL code in SSMS.

SP_CONFIGURE 'clr enabled', 1
GO
RECONFIGURE
GO 

Set TRUSTWORTHY ON

Ensure that the PPSMonitoring database has its TRUSTWORTHY property set to ON so the CLR code can run

-- Check if PPSMonitoring has TRUSTWORTHY set to ON
SELECT
  is_trustworthy_on 
FROM sys.databases 
WHERE [name] = 'PPSMonitoring'

-- if the result above is 0 set it ON
ALTER DATABASE PPSMonitoring
SET TRUSTWORTHY ON

Create MAUDF Objects

Files required

  • MAUDF.dll
  • MAUDF.XmlSerializers.dll
  • CreateMAUDF.sql

Procedure

  • Create a directory (e.g. C:\MAUDF) and drop the MAUDF.dll and MAUDF.XmlSerializers.dll files into it
  • Open the MAUDFCreate.sql file in SSMS
  • Edit the value in the @AssemblyPath variable to point towards the directory where the MAUDF.dll and MAUDF.XmlSerializers.dll files are located.
SET @AssemblyPath = 'C:\MAUDF'
  • Edit the value in the @WebServiceURL variable to point towards the web service URL for the PerformancePoint instance in question.
SET @WebServiceURL = 'http://<YourMonitoringServerName>:40000/webservice/pmservice.asmx'
  • Ensure the PPSMonitoring database is selected (you can change the name when setting the server up but the default name is PPSMonitoring)
  • Run the script to register the assemblies and create the appropriate objects within the database

Last edited Jun 2, 2008 at 11:29 AM by NickBarclay, version 28

Comments

No comments yet.