External SQL Server? (1 Viewer)

[SolusCado]

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]

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