YOUR STORY PLAYS HERE
Home » Categories » Carousel » Install & Deployment

How do I configure Carousel to work with a separate SQL instance?

Applies to

  • Carousel 7.0+

Answer

This article is for Pros Only. We will not explain SQL concepts here. If you’re having trouble understanding the concepts, you will need to seek paid assistance from Tightrope Media Systems or one of our qualified installation partners.
  1. Run the Carousel Server software installer with the REMOTE_SQL=1 flag, typically via Command Prompt.
    1. This will tell the installer to skip over installing SQL Express, as well as trying to run the SQL scripts.
  2. Copy the C:\TRMS\Database\Scripts folder to your separate SQL instance.
  3. Download the attached Carousel-CreateDB.sql script from this article.
  4. Modify the FrontDoor50-CreateDB.sql and Carousel-CreateDB.sql CREATE DATABASE commands to point to an existing physical path where you would like the databases created at.
    1. Be sure to modify both the path for the .LDF and .MDF files.
    2. You may also need to change the compatibility level of the script to match your SQL instance.
  5. Using a management console or oSql command run the FrontDoor50-CreateDB.sql script.
  6. Before running any other scripts, open Command Prompt and run the following:
    "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regsql.exe -E -d FrontDoor50 -A mrp"
  7. Using a management console or oSql command run the FrontDoor50-PopulateDB.sql script.
  8. Using a management console or oSql command run the Carousel-CreateDB.sql script.
  9. Using a management console or oSql command run the Carousel.sql script.
  10. Make sure you have a login for the web server that can access the SQL server and both the FrontDoor50 and Carousel50 databases as DBOs.
  11. Modify the C:\TRMS\Configuration\connectionStrings.config file.
  12. Reboot the Carousel Server.
  13. Continue with the Licensing portion of the Carousel Server Installation process.
Example Connection String:
<add name="CarouselConnectionString" connectionString="data source=127.0.01;User=myuser;Password=mypassword;initial catalog=Carousel50;" />

Additional Information

Your drive letter may be different depending on the directory chose when installing Carousel.

For information about running the aspnet_regsql.exe command remotely, see this Microsoft ASP.NET article.

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments (1) Attachments
Related Articles RSS Feed
How do I configure FrontDoor to pull users from Active Directory?
Viewed 1642 times since Fri, Apr 21, 2017
Where I can find pre-configured virtual machine images for a new Carousel Server?
Viewed 1117 times since Thu, Mar 23, 2017
How do I configure Carousel to work with a separate Media directory?
Viewed 866 times since Fri, Apr 21, 2017
How do I setup or configure a Carousel for BrightSign Player in 7.0?
Viewed 1702 times since Fri, Apr 21, 2017
How do I install the Carousel Player Software?
Viewed 1195 times since Fri, Apr 21, 2017
How do I install the Carousel Server Software?
Viewed 1533 times since Thu, Mar 23, 2017
How do I setup or configure a Carousel for BrightSign Player in Carousel 7.1?
Viewed 459 times since Wed, Nov 29, 2017
How do I manually configure the Prerequisites and Dependencies for the Carousel Server software?
Viewed 844 times since Fri, Apr 21, 2017
What are the Prerequisites or Dependencies for the Carousel Server software?
Viewed 1002 times since Thu, Apr 20, 2017