Can not backup Carousel database

Applies to

• Carousel 7.0.0 - 7.0.2

Symptoms

• You receive an error in Front Door stating "Could not back up database carousel50;multipleactiveresultsets=true. Incorrect syntax near 'multipleactiveresultsets'...."

Cause

This issue is caused by a software bug within the FrontDoor application.  The piece of code that detects the name of the Carousel database within SQL server is incorrectly interpreting the database name as "carousel50;multipleactiveresultsets=true" instead of "carousel50"

Workaround

1. From the Windows desktop of your server navigate to C:\TRMS\Configuration\ 
   If you don't see a C:\TRMS\Configuration\ folder, check D:\TRMS\Configuration\
   
   
2. Open connectionStrings.config in notepad.
   
   
3. Find the following entry
   

   connectionString="data source=(local);Integrated Security=SSPI;initial catalog=Carousel50;MultipleActiveResultSets=true;"
   
   

4. Change the entry to match this configuration order:
   

   connectionString="data source=(local);Integrated Security=SSPI;initial catalog=Carousel50;MultipleActiveResultSets=true;"

5. Save the file
   
   
6. Restart IIS
   
   
7. You should now be able to backup the database.

Additional Information

The TRMS engineering team plans to fix this issue for release in Carousel 7.0.3.