Step 6 - Create the SQL Rules Extension

  • Article

Applies To: Windows Server 2008, Windows Server 2008 R2

In this step we will be creating the SQL Management Agent rules extension.

Creating the SQL Management Agent Rules Extension

The following steps show how to create the SQL MA rules extension.

To create the SQL MA rules extension

  1. Log on to RES-DC.resource.fabrikam.net as Administrator

  2. Click Start, click All Programs, click Microsoft Identity Integration Server, and click Identity Manager.

  3. In Identity Manager, go to the top and select Management Agents.

  4. On the Management Agents screen, click SQL and then select Create Extension Projects from the right. This will bring up the Create Extension Project dialog box.

  5. On the Create Extension Project dialog box, select Visual C# from the drop-down next to Programming Language.

  6. On the Create Extension Project dialog box, select Rules Extension from the drop-down next to Project Type.

  7. On the Create Extension Project dialog box, leave the default of SQLExtension next to Project name.

  8. On the Create Extension Project dialog box, leave the default for Project Location.

  9. On the Create Extension Project dialog box, leave a check in Launch in VS.NET IDE.

  10. On the Create Extension Project dialog box, click OK. This will launch Visual Studio.

Note

When this project opens the Visual Studio Conversion Wizard will start so that it can convert the project to a Visual Studio 2008 version. Simply click Next and then Finish. Then select Load this project normally. Then close the conversion wizard.

  1. In Visual Studio, under the Solution Explorer, double-click SQLExtension.cs.

  2. Delete all of the code that appears in the large window on the left. Copy the code from Appendix D – SQL MA Extension into this area.

  3. In Visual Studio, at the top, select Build and then select Build Solution. Down at the bottom, in the Output section, you should see Build: 1 succeeded or up-to-date, 0 failed, 0 skipped. Close Visual Studio. This will return you to the Options dialog box.

  4. On the Management Agents screen, click SQL and then select Properties from the right. This will bring up the Properties dialog box.

  5. On the Properties screen, select Configure Extensions on the left and then ensure SQLExtension.dll is specified in the Rules extension name box.

  6. Close Properties.

  7. Close Identity Manager.