version 1.0.2
I have had media portal working fine for a long time but today I decided to upgrade my antivirus on the HTPC to MCAFEE.
When the computer restarted I noticed that the MCAFEE firewall was asking permission for certain programs including sql to go through the firewall. I clicked ok but when I went into MediaPortal all my tv recorded tv programs were absent and my TV guide did not work.
I disabled and then removed MCAFEE and performed numerous restarts but nothing has fixed the fault.
The following entry appears in the log:
I have checked the usual sql settings and they all seem to be fine. Surface area configuration is set for "TCP/IP and named pipes" and "shared memory TCP/IP and named pipes are all listed in SQL configuration manager.
I have run curports and have noticed that nothing is running on Port 1433 which is a bit suspicious. From my googling I think that port should be listed as a TCP connection for SQL server. Port 1434 is listed as a UDP port to the SQL browser process on all interfaces("::").
Can someone confirm that I am missing port 1433 which is the TCP port and that this is the reason MediaPortal will not display my TV guide and recorded TV. Bonus points if you can point me in the right direction to fix this.
Thanks for reading
I have changed the SQL ports from dynamic to static on 1433. Cur ports is now displaying port 1433 for SQL but MediaPortal is still unable to access the database.
I have had media portal working fine for a long time but today I decided to upgrade my antivirus on the HTPC to MCAFEE.
When the computer restarted I noticed that the MCAFEE firewall was asking permission for certain programs including sql to go through the firewall. I clicked ok but when I went into MediaPortal all my tv recorded tv programs were absent and my TV guide did not work.
I disabled and then removed MCAFEE and performed numerous restarts but nothing has fixed the fault.
The following entry appears in the log:
Code:
2009-06-17 23:16:55.876256 [TVService]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=***;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDb;Data Source=htpc-PC\SQLEXPRESS;Connection Timeout=300; ---> System.Data.SqlClient.SqlException: Cannot open database "MpTvDb" requested by the login. The login failed.
Login failed for user 'sa'.I have checked the usual sql settings and they all seem to be fine. Surface area configuration is set for "TCP/IP and named pipes" and "shared memory TCP/IP and named pipes are all listed in SQL configuration manager.
I have run curports and have noticed that nothing is running on Port 1433 which is a bit suspicious. From my googling I think that port should be listed as a TCP connection for SQL server. Port 1434 is listed as a UDP port to the SQL browser process on all interfaces("::").
Can someone confirm that I am missing port 1433 which is the TCP port and that this is the reason MediaPortal will not display my TV guide and recorded TV. Bonus points if you can point me in the right direction to fix this.
Thanks for reading
I have changed the SQL ports from dynamic to static on 1433. Cur ports is now displaying port 1433 for SQL but MediaPortal is still unable to access the database.