Symptoms

Diagnoses

Resolution



We have a SQL Server Instance set up with impersonate. When we execute a smart object with certain users we get the attached error.
However other users do not have the same problem.


Resolution:

1- Go to SQL server
2- Security
3- Expand Logins

Make sure if the users whose get this error have been added, If yes, Right click on the user > properties > User Mapping > Select CCMS database
> give the user the right permission (from role membership)

-------------------------------

If the users whose get this error have not been added to the logins

right click on the logins > new login > Add Login Name (i.e ADIFS/ddonoghue) > User Mapping > select CCMS database > give the user the right permission (from role membership)


More info about Authentications methods here:

http://help.k2.com/onlinehelp/K2blackpearl/DevRef/current/default.htm_ServiceBrokerAuthentication.htm