Invalid object name error when upgrading ERM database


You receive the following error when you run the 5.4 to 5.5 database upgrade script on the Microsoft Prodiance Enterprise Risk Manager (ERM) database:

Msg 208, Level 16, State 6, Procedure fn_SIDToString, Line 37 Invalid object name 'dbo.fn_SIDToString'.


The database is missing a function that is used by certain reports.


Run the RoleSecurityReport.sql script on the ERM database before you run the upgrade script:

1. Open SQL Management Studio.

2. Connect to the ERM database server.

3. Right-click the ERM database and select New Query.

4. Paste the RoleSecurityReport.sql script and then click Execute.

ID d'article : 2806042 - Dernière mise à jour : 30 janv. 2013 - Révision : 1