Finland
I recently tried installing TV server to Vista and had new problems. When I initially (and later) tried to start setuptv, I got error telling I couldn't get access to sql service.
Last time I tried on clean install MsSQL 2005 Express SP2, but I'm pretty sure I got this with normal package too. If you are having this problem, here are some solutions:
1) You may have installed multiple intances of SQL Service or got instances named differently from default which TVServer is looking for. When you initially start up TV Server, it asks you connection type, You have to put the instance of SQL that's correctly setup for TV server use on that textbox. You can find running instance name by browsing Windows Services. If possible remove all other instances with Control Panels Programs -utility if you can.
If you however, can't even get to connection type configuration you may have following:
2) You haven't made exceptions for firewall settings. Make sure sqlservice and sqlbrowser are allowed to pass through (and tvservice too).
3) MsSQL is configured to use dynamic IP addresses (I had this one). You can force it to use port 1433 using SQL Server Configuration Manager. With Manager, select SQL Server 2005 Network Configuration -> Protocols. Select TCP/IP and right click to adjust its properties, select IP Addresses tab and go to bottom where you find IPAll, there clear the value from TCP Dynamic Ports and add 1433 to TCP Port. After this either reboot computer or restart SQL Service.
EDIT-> ADDED:
I also had trouble with MySQL running on Vista. I couldn't get the one pointed from Wiki (5.0) to install at all on Vista. I found out that 6.0 alpha did install and work with TV Server but on my machine if was way too slow for some reason. I later found out that Chemelli posted this: https://forum.team-mediaportal.com/get-support-90/mysql-5-0-51a-install-under-vista-35478/
4) When installing TV Server nightly build from fresh, I usually get gentle.config file which doesn't point to any database. In this case TV Server doesn't start up at all. So find the line for DefaultProvider and add Data Source=computername\SQLEXPRESS; as follows:
<DefaultProvider name="SQLServer" connectionString="Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=HTPC\SQLEXPRESS;" />
Please note that you have to use password you entered during mssql installation. I used default "sa" on this example.
Gentle.config is used at least on ProgramData\MediaPortal TV Server and on Program Files\Team MediaPortal\MediaPortal TV Server (maybe on MediaPortal client folder too?). So modification is needed to these files.
If your mini-EPG doesn't work but rest of your TV does with tv-server, it's likely that you have at least one gentle.config -file missing data source.
Last time I tried on clean install MsSQL 2005 Express SP2, but I'm pretty sure I got this with normal package too. If you are having this problem, here are some solutions:
1) You may have installed multiple intances of SQL Service or got instances named differently from default which TVServer is looking for. When you initially start up TV Server, it asks you connection type, You have to put the instance of SQL that's correctly setup for TV server use on that textbox. You can find running instance name by browsing Windows Services. If possible remove all other instances with Control Panels Programs -utility if you can.
If you however, can't even get to connection type configuration you may have following:
2) You haven't made exceptions for firewall settings. Make sure sqlservice and sqlbrowser are allowed to pass through (and tvservice too).
3) MsSQL is configured to use dynamic IP addresses (I had this one). You can force it to use port 1433 using SQL Server Configuration Manager. With Manager, select SQL Server 2005 Network Configuration -> Protocols. Select TCP/IP and right click to adjust its properties, select IP Addresses tab and go to bottom where you find IPAll, there clear the value from TCP Dynamic Ports and add 1433 to TCP Port. After this either reboot computer or restart SQL Service.
EDIT-> ADDED:
I also had trouble with MySQL running on Vista. I couldn't get the one pointed from Wiki (5.0) to install at all on Vista. I found out that 6.0 alpha did install and work with TV Server but on my machine if was way too slow for some reason. I later found out that Chemelli posted this: https://forum.team-mediaportal.com/get-support-90/mysql-5-0-51a-install-under-vista-35478/
4) When installing TV Server nightly build from fresh, I usually get gentle.config file which doesn't point to any database. In this case TV Server doesn't start up at all. So find the line for DefaultProvider and add Data Source=computername\SQLEXPRESS; as follows:
<DefaultProvider name="SQLServer" connectionString="Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=HTPC\SQLEXPRESS;" />
Please note that you have to use password you entered during mssql installation. I used default "sa" on this example.
Gentle.config is used at least on ProgramData\MediaPortal TV Server and on Program Files\Team MediaPortal\MediaPortal TV Server (maybe on MediaPortal client folder too?). So modification is needed to these files.
If your mini-EPG doesn't work but rest of your TV does with tv-server, it's likely that you have at least one gentle.config -file missing data source.