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
Disabling RDA
Viewed 223 times since Thu, Mar 22, 2018
How do I install the Carousel Server Software?
Viewed 3511 times since Thu, Mar 23, 2017
How do I configure Carousel to work with a separate Media directory?
Viewed 1562 times since Fri, Apr 21, 2017
How do I install the Carousel Player Software?
Viewed 3989 times since Fri, Apr 21, 2017
How do I setup or configure a Carousel for BrightSign Player in 7.0?
Viewed 4023 times since Fri, Apr 21, 2017
How do I configure FrontDoor to pull users from Active Directory?
Viewed 3400 times since Fri, Apr 21, 2017
What are the Prerequisites or Dependencies for the Carousel Server software?
Viewed 2073 times since Thu, Apr 20, 2017
.NET 3.5 does not install during Carousel installation
Viewed 158 times since Tue, Jul 17, 2018
How do I manually configure the Prerequisites and Dependencies for the Carousel Server software?
Viewed 1581 times since Fri, Apr 21, 2017