Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

BBIS Troubleshooting – No ConnectionString setting found in web.config with name “BBInfinity”

By: Joseph Styons

Posted on: April 16, 2013

 

Today’s post is a simple problem/solution.

 

If you see this error in your BBIS Test Page:

image

 

Then the solution is to add (or modify) the keys in this script as shown below.

 

EXEC dbo.Usp_get_key_access;

insert into setting(id,name,value) values (55,'BBAppFXUser',EncryptByKey(Key_GUID('sym_BBInfinity'),convert(nvarchar(1000),'')));

insert into setting(id,name,value) values (56,'BBAppFXPassword',EncryptByKey(Key_GUID('sym_BBInfinity'),convert(nvarchar(1000),'')));

insert into setting(id,name,value) values (57,'BBAppFXDatabaseToUse','BBInfinity');

CLOSE SYMMETRIC KEY sym_bbinfinity

 

 

If those keys are missing, then BBIS assumes the default of “BBInfinity”.

The BBAppFXDatabaseToUse key must match the one in your CRM installation’s web.config file, found under [crm installation root]\bbappfx\vroot\Web.config.

 

Obligatory link to the handbook

Leave a Reply

Privacy Policy | Sitemap | © 2011 Blackbaud, Inc. All Rights Reserved

Digital Ocean