TVService keeps crashing, logs point to SQL authentication (1 Viewer)

[u095538]

MediaPortal Version: 1.0.2.0
MediaPortal Skin: X Factor
Windows Version: Vista Ultimate
CPU Type: El-Cheapos AMD dual core (90+% CPU usage for 1080p h264, non-dxva (obviously) with 1x something special post-processing enabled (eg: de-interlacing)
HDD: Seagate 250GB 7200 SATA2
Memory: 2GB cheap generic Corsair DDR2
Motherboard: ASUS M3N78-VM
Video Card: intergrated on mobo. Nothing special. NVidia chipset which supports DXVA
Video Card Driver: No idea
Sound Card: intergrated on mobo. Nothing special. VIA chipset I believe
Sound Card AC3: intergrated on mobo. Nothing special. VIA chipset I believe
Sound Card Driver: no idea
1. TV Card: Hauppagge Nova T-500
1. TV Card Type: Dual tuner
1. TV Card Driver: no idea
MPEG2 Video Codec: ffdshow
MPEG2 Audio Codec: ffdshow
h.264 Video Codec: ffdshow
Satelite/CableTV Provider: FTA (Aussie-land, DVB-T)
HTPC Case: Antec Fusion Black
TV - HTPC Connection: HDMI


Hello All.

I am using a single-seat setup with MP's TVServer and 4therecord. The TVService is continually crashing stopping (edited). I've checked the following log "c:\ProgramData\Team MediaPortal\MediaPortal TV Server\log\error.log" and it has the following repeated entry:

2009-11-30 12:59:48.231000 [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\SQLEXPRESS;Connection Timeout=300; ---> System.Data.SqlClient.SqlException: Cannot open database "MpTvDb" requested by the login. The login failed.
Login failed for user 'sa'.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
   --- End of inner exception stack trace ---
   at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
   at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
   at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
   at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
   at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)
   at TvLibrary.Implementations.TvCardCollection..ctor(IEpgEvents epgEvents)
   at TvService.TVController.InitController()System.Data.SqlClient.SqlException: Cannot open database "MpTvDb" requested by the login. The login failed.
Login failed for user 'sa'.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()

I think I did indeed change the sa password for the SQL server. I can't however find where I can specify what MP/TVServer is to use for authentication.

I should note that all I have to do is use services.msc and start the service.. and it starts fine and everything works flawlessly again. I don't know how it can start no problem with failed authentication which leads me to believe I am looking in the wrong log or something like that. I'm pretty noob to all this. Could someone possibly point me in the right direction please? I would be most grateful of any help provided.

Edit: I've logged into "SQL Server Management Studio Express" using the default 'sa' and 'MediaPortal' and got in fine, so I guess I didn't change the password. I don't know why the service is stopping It happens nearly daily

 

[Chuckyy]

I should note that all I have to do is use services.msc and start the service..

So, i suppose mysql doesn't run right from the start?

 

[Owlsroost]

Is this happening randomly while the PC is running, or just on wake up etc ?

I think I've seen this issue occasionally in the error log when the network connection has been unavailable at wake up - as this is a single seat system, you could try the MS loopback alternative

Tony

 

[u095538]

Fixed! Thanks to all for your advise. To solve the problem I actually blew away my single-seat setup and went for a server/client option. Before I installed /anything/ MP-related I cleared the system logs of all errors on both the server and client. I installed MP and everything is now working rock-solid stable! The TV Service hasn't crashed for two weeks. Fantastic.

FYI
Server: windows Home Server (Basically a slightly different version of Windows 2003)
Client: Vista Ultimate, nothing on it except MP and registered direct-show decoders. SIGH @ power-saving options.. all sorted now though.

Note: I did not attempt the MS Loopback solution so I cannot comment on it. Again, thanks for the help everyone.