Exception thrown when creating a project due to SQL permissions

 Product(s):Promis.e, Bentley Substation
 Area:Database Platform Support

Error or Warning Message

When trying to create a new project using Project Manager, the following error message is displayed. A folder is created but not recognized as a project folder.

Internal Error
Error Message: Exception has been thrown by the target of an invocation.
TargetSite: System.Object _InvokeMethodFast(System.Object, System.Object[], System.SignatureStruct ByRef, System.Reflection.MethodAttributes, System.RuntimeTypeHandle)
DeclaringType: System.RuntimeMethodHandle
Attributes: private
MemberType: Method


In one case this was caused by using a SQL login that did not meet the [[Minimum SQL user permissions]] for connecting the software to the project database. Specifically, the login had public, db_datareader, and db_datawriter roles, but the corresponding user had not been granted Execute permission on the database.

How to Avoid

Follow the steps described in the [[Minimum SQL user permissions]] article.

 Original Author:Matt_P