YOUR STORY PLAYS HERE
Home » Categories » Multiple Categories

FrontDoor fails to backup Carousel database

Applies to

  • Carousel 7.0.0 - 7.0.2

Symptoms

  • You receive an error 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. Update connectionString="data source=(local);Integrated Security=SSPI;initial catalog=Carousel50;MultipleActiveResultSets=true;"
    to read
    connectionString="data source=(local);Integrated Security=SSPI;MultipleActiveResultSets=true;initial catalog=Carousel50;"
  4. Save the file
  5. Restart IIS
  6. 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.  

Custom Fields
  • Bug Status: Pending
0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How do I migrate my database and content to another server?
Viewed 2332 times since Mon, Sep 22, 2014
Internet Explorer cannot crop a web picture block.
Viewed 994 times since Mon, Oct 20, 2014
Carousel for BrightSign software version release history
Viewed 961 times since Thu, Aug 20, 2015
Carousel operating system compatibility
Viewed 1925 times since Tue, Nov 10, 2015
Carousel 7.0 Upgrade Guide
Viewed 1673 times since Wed, Jan 4, 2017
How to perform a system database migration
Viewed 1402 times since Thu, Jul 30, 2015
My new Carousel player will not connect to my server
Viewed 1835 times since Tue, Nov 11, 2014
Carousel Does Not Load when Logged in with Usernames that Contain Periods
Viewed 91 times since Mon, Sep 18, 2017
Carousel - Warranty Options
Viewed 501 times since Wed, Feb 15, 2017
Submitting a bug report to Tightrope
Viewed 1632 times since Thu, Jan 8, 2015