https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87748#M38418 @Ricardo, please advise further on how I can achieve this, previously configured groups in database security options Thu, 18 Jan 2018 11:56:00 GMT RamashitaRamutl 2018-01-18T11:56:00Z https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87745#M38415 I am attempting to configure a database for Active Directory Single Sign-on, 1. BP Security groups created. 2. Users added to admin group. 3. SQL Server login granted fro each user in ssms.exe. I am getting error, "Single Signon Failed - you are not in any groups that are authorised to log in. Blue Prism will now exit. Contact your network administrator to resolve these configuration problems"   Any advice? Mon, 15 Jan 2018 12:59:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87745#M38415 RamashitaRamutl 2018-01-15T12:59:00Z https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87746#M38416 If you haven't already done so, maybe try restarting BP server and client? Mon, 15 Jan 2018 14:18:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87746#M38416 John__Carter 2018-01-15T14:18:00Z https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87747#M38417 Hello Ramashita, You also need to add the AD groups in the SQL Server itself. Best regards. Wed, 17 Jan 2018 21:31:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87747#M38417 RicardoAlqueidã 2018-01-17T21:31:00Z https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87748#M38418 @Ricardo, please advise further on how I can achieve this, previously configured groups in database security options Thu, 18 Jan 2018 11:56:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87748#M38418 RamashitaRamutl 2018-01-18T11:56:00Z https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87749#M38419 Hi Ramashita, I assume you are connecting your clients directly to the DB server? If so (and if it's possible) search through my posts, I've posted instructions on how to do this previously. If not, you will need to run the Blue Prism Server service that you've setup on your application server as a domain account that has at the very least db_datareader and db_datawriter as memberships. I would also suggest the following: bpa_ExecuteSP_DataSource_bpSystem bpa_ExecuteSP_DataSource_custom bpa_ExecuteSP_System Hope this helps. Steve Thu, 18 Jan 2018 15:54:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87749#M38419 SteveBoomer 2018-01-18T15:54:00Z https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87750#M38420 Hi Ramashita, as told by Ricardo, add the AD groups in database under ""Security -> Users"". Thu, 18 Jan 2018 19:19:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Signon-Failed-you-are-not-in-any-groups-that-are/m-p/87750#M38420 Anonymous 2018-01-18T19:19:00Z