SCOM 2012 SP1 – Publish Visio Dashboard in SharePoint 2010 Walkthrough

There are many posts including TechNet article about publishing Visio dashboards in SharePoint 2010 using the Microsoft Visio 2010 and SharePoint 2010 Extensions for System Center 2012 . I found most of these article have a lack of information either the posts are for SCOM 2007 R2 or they do not cover the SharePoint side and so on. What I am missing is a kind of step-by-step guide with details and pictures. Therefore, I will try to fill this gap and write one more post…

I assume you installed SharePoint 2010 Enterprise server in your environment. In my case the SharePoint is installed on a Windows Server 2008 R2 SP1 box and fully functional.

Ok let’s start…

Step 1 – Install SCOM Console

One thing you need to understand that you need to install the SCOM 2012 console on your SharePoint server. Yes, on your SharePoint server. Run the SCOM 2012 SP1 setup on the SharePoint and choose the Operations console…

1

Leave the default directory and click Next…

2

If the MS ReportViewer 2010 is missing, click on the link provided, download the source, and run the ReportViewer 2010 setup…

3

The ReportViewer 2010 setup starts and just click Next, Next, Finish….

5

Run the Prerequisites Check again and everything should be o.k….

4

Accept the license agreement, click Next….

6

Select the CEIP settings as you need, click Next…

7

Check the Installation Summary and click Next and Close…

8

Step 2 – Install SCOM Dashboard Web Part

The next step is installing the dashboard Web Part into SharePoint which enables you to add SCOM dashboard URL’s from your SCOM web console to integrate SCOM dashboards into your SharePoint site. Because I want to demo this solution for the customer I am also going to install this Web Part. In this post I am just showing you how to add the Web Part if you need any more details how to configure it, some time ago I wrote a 2 part blog post about publishing SCOM dashboards in SharePoint.

You can find the solution on your SCOM 2012 SP1 install media in /Setup/AMD64/SharePoint. Copy the SharePoint folder locally to the SharePoint server…

10

Copy SharePoint folder to C:\Install\SharePoint on the SharePoint server…

11

Run the SharePoint 2010 Manager Shell…

12

Set the execution policy to RemoteSigned…

13

Run the following command to install the Web Part to the entire server…

14

Note: If you want to remove the Web Part because you made a mistake you can run the following command…

15

Part 3 – Check Visio Web Service

Again make sure you have SharePoint 2010 ENTERPRISE edition installed, because only this edition has the Visio Web Service available. Go to the Central Administration website under Site Actions choose Site Settings…

16

Select Manage site features…

17

Make sure the SharePoint Server Enterprise Site Features are installed and Active…

18

Part 4 – Configure Visio Graphics Service Application

In my case I needed to add a Visio Graphics Service Application in SharePoint. We need this in order to run the upcoming PowerShell InstallOpsMgrDataModule.ps1 script which will register the necessary data module with this Visio Graphics Service Application. Go to the Central Administration website and under Application Management select Manage service applications…

20

Choose Visio Graphics Service…

21

Give this Service Application exactly this name Visio Graphics Service. I created a new application pool called vgs (=vgs stands for visual graphic service but you can name it whatever you want) and used the SharePoint service account…

22

Make sure you will see the following entry after clicking OK…

23

Part 5 – Install Trusted Data Provider for Visio Services

Next we need to add Trusted Data Provider for Visio Graphic Services to SharePoint. We can do this by executing the InstallOpsMgrDataModule.ps1. You can find this script after you executed the OpsMgrDataModule.msi from the Microsoft Visio 2010 and SharePoint 2010 Extensions for System Center 2012 . Ok, let’s start. Download the Microsoft Visio 2010 and SharePoint 2010 Extensions for System Center 2012 and extract and save the Visio Plugin folder e.g. in C:\Install\ in the Server directory you will find the OpsMgrDataModule.msi…

31

Execute the OpsMgrDataModule.msi, note this will only extract some file into the given directory…

The extraction of the Visio Services Data Provider is basically Next, Next, Finish…

32

33

34

35

36

Open the SharePoint Management Shell and change into the directory where you extracted the files from above and run the InstallOpsMgrDataModule.ps1 as shown in the Screenshot…

37

If you receive an error like this…

38

make sure you have the Visio Graphics Service configured correctly and named as described before!

Part 6 – Configure Service Account

In Part 4 I assigned the SharePoint service account (sharepoint) to a dedicated application pool (vgs). Add this service account (sharepoint) to the Read-Only Operator role in SCOM 2012 SP1…

image

At this point SharePoint is ready to run Visio web drawing files!

Part 7 – Configuring Visio  & Saving Diagram

Install Visio 2010 Professional or Premium on your client. Then install the client Visio Add-In as described on TechNet. Create a diagram and link the shapes with SCOM 2012.

If you want to save the diagram go to “Speichern und Senden” (screenshot is in German, sorry :), “Save and Send” translated to English) and select “Speichern unter” or “Save as” in SharePoint…

 70

In the dialog where you enter usually file name enter the SharePoint URL e.g. http://sharepointserver/monitoring . This will provide you with libraries to store the *.vdw file e.g. Documents, then give the file a name and click Save…

71

As a next step go to your SharePoint site and click edit. The menu will appear and you are able to click Web Part. Go to Business Data and select Visio Web Access and press Add…

80

In the middle of your site the Web Part will be added, select the checkbox and click Edit Web Part…

81

A menu on the right side will appear, click on the “…” next to Web Drawing URL…

82

Navigate to you web drawing and click OK…

83

You Visio web drawing will be added and now you can click Save & Close…

84

That’s it! Of course there are some parameters which you could configure for the Web Part but this you need to find out yourself.

Part 8 – Troubleshooting

You might are going to face some of these errors…

Problem: There are no addresses available for this application

900

Solution: Go to the Central Administration site under System Settings, select Manage services on server…

90

Make sure Visio Graphics Service is started!

91

Problem: The server failed to process the request

955

Solution: Go to Central Administration site Security/Configure service accounts…

95

I assigned to the vgs application pool the sharpoint service account…

96

as a final step restart IIS…

97

Problem: You might see an error “The Unattended Service Account Application ID is not specified or has an invalid value.”  when you go to Central Administration / SharePoint Health Analyzer.

Solution: The solution can be found on sharepointsolutions.com

If you need more troubleshooting hints check TechNet or if you encounter other dashboard errors check an older blog post.

I hope you like this post and it saves you some time…

I had prepared this post some time ago and finally managed to publish it. Well today I found out that Tim McFadden also has done a similar post. Well, if you combine both posts you will definitely manage your Visio / SharePoint problems :).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s