External SQL Server? (1 Viewer)

SolusCado

Portal Member
December 11, 2012
5
0
44
Washington, District of Columbia
Home Country
United States of America United States of America
I have found the article on using SQL Server 2008 Express SP1 as my database system for the TV Server, but it appears to still be using SQL on the local machine (the machine that hosts the TV Capture card). I'd prefer to use an external database server (running SQL Server 2012, ideally).

Is this at all possible? It seems like I would just need some script to establish the necessary database/s, schema/s, etc. and then connect to it when I'm setting up the TV Server.
 

mm1352000

Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    Hello SolusCado

    Yes I think it should be possible.
    During the install process, pay close attention at this step:
    http://wiki.team-mediaportal.com/1_MEDIAPORTAL_1/12_Installation/1_Deploy_Tool/2_Advanced_Installation#Database_Server_(SQL)

    Select SQL Server is already present and will be used for TV Server.
    Then at the end of the installation, enter the connection details for the server and make sure the connection works:
    http://users.telenet.be/Drizla/SetupDatabaseConnection.png

    If you've already installed and you want to switch to the other DB server, use the "/configure-db" command line option (available options described here) to change the DB server. Of course you will need to export any channels and schedules from the old DB so you can import them into the new DB... or just start fresh.

    Note: you will probably need to set up a user for MP TV Server to use with permission to create a schema. "SetupTv.exe /configure-db" will create the schema and tables for you as long as the DB connection is successful and the user has the necessary privileges.

    Good luck!
    mm
     
    Last edited:

    Users who are viewing this thread

    Top Bottom