How to resolve error 201 - Oops! Unable to find {ConnectionStringName} ConnectionString in web.config?

Hardik Shah -

In general, you will see this error at the time of installing any Emgage product or on the license page in following conditions:

  1. Your SharePoint WFE is missing connection string in web application.
  2. You are using SharePoint Farm with multiple WFEs and one of the WFE is missing connection string in web application.

In order to resolve the issue, you need to connect to all your WFEs and manually generate and add connection string to web.config. Connection strings are added to ConnectionStrings section in web.config. 

Here is an example of default sql authentication connection string for all products assuming you are using default database names provided by Emgage product installer:

<!-- licensing database connection string, required for ALL products -->
<add name="AteraPrimeLicensing" connectionString="Persist Security Info=False;Initial Catalog=Licensing;Data Source=<Database-Server>;User ID=ateraLicenseUser;Password=<Password>;" providerName="System.Data.SqlClient" />

<!-- settings database connection string, required for PRIME & TURBO VIEW products --><add name="AteraSettings" connectionString="Persist Security Info=False;Initial Catalog=PrimeSettings_SP;Data Source=<Database-Server>;User ID=primeSettingsUser;Password=<Password>;" providerName="System.Data.SqlClient" />

<!-- turbo database connection string, required for TURBO BUILDER product -->
<add name="TurboApps" connectionString="Persist Security Info=False;Initial Catalog=TURBOApps;Data Source=<Database-Server>;User ID=ateraTURBOUser;Password=<Password>" providerName="System.Data.SqlClient" />

Here is an example of default windows authentication connection string for all products assuming you are using default database names provided by Emgage product installer:

<!-- licensing database connection string, required for ALL products -->
<add name="AteraPrimeLicensing" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Licensing;Data Source=<Database-Server>" providerName="System.Data.SqlClient" />

 <!-- settings database connection string, required for PRIME & TURBO VIEW products --><add name="AteraSettings" connectionString="Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=PrimeSettings_SP;Data Source=<Database-Server>" providerName="System.Data.SqlClient" />

<!-- turbo database connection string, required for TURBO BUILDER product --><add name="TurboApps" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TURBOApps;Data Source=<Database-Server>" providerName="System.Data.SqlClient" />

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk