home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
TVService keeps crashing, logs point to SQL authentication
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="u095538" data-source="post: 541202" data-attributes="member: 79639"><p><strong>MediaPortal Version</strong>: 1.0.2.0</p><p><strong>MediaPortal Skin</strong>: X Factor</p><p><strong>Windows Version</strong>: Vista Ultimate</p><p><strong>CPU Type</strong>: El-Cheapos AMD dual core (90+% CPU usage for 1080p h264, non-dxva (obviously) with 1x something special post-processing enabled (eg: de-interlacing)</p><p><strong>HDD</strong>: Seagate 250GB 7200 SATA2</p><p><strong>Memory</strong>: 2GB cheap generic Corsair DDR2</p><p><strong>Motherboard</strong>: ASUS M3N78-VM</p><p><strong>Video Card</strong>: intergrated on mobo. Nothing special. NVidia chipset which supports DXVA</p><p><strong>Video Card Driver</strong>: No idea</p><p><strong>Sound Card</strong>: intergrated on mobo. Nothing special. VIA chipset I believe</p><p><strong>Sound Card AC3</strong>: intergrated on mobo. Nothing special. VIA chipset I believe</p><p><strong>Sound Card Driver</strong>: no idea</p><p><strong>1. TV Card</strong>: Hauppagge Nova T-500</p><p><strong>1. TV Card Type</strong>: Dual tuner</p><p><strong>1. TV Card Driver</strong>: no idea</p><p><strong>MPEG2 Video Codec</strong>: ffdshow</p><p><strong>MPEG2 Audio Codec</strong>: ffdshow</p><p><strong>h.264 Video Codec</strong>: ffdshow</p><p><strong>Satelite/CableTV Provider</strong>: FTA (Aussie-land, DVB-T)</p><p><strong>HTPC Case</strong>: Antec Fusion Black</p><p><strong>TV - HTPC Connection</strong>: HDMI</p><p></p><p></p><p>Hello All.</p><p></p><p>I am using a single-seat setup with MP's TVServer and 4therecord. The TVService is continually <s>crashing</s> 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:</p><p></p><p>[code]</p><p>2009-11-30 12:59:48.231000 [TVService]: Exception :Error: DatabaseUnavailableUnclassified</p><p>Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.</p><p>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.</p><p>Login failed for user 'sa'.</p><p> at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)</p><p> at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)</p><p> at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)</p><p> at System.Data.SqlClient.SqlConnection.Open()</p><p> at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()</p><p> --- End of inner exception stack trace ---</p><p> at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)</p><p> at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)</p><p> at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)</p><p> at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)</p><p> at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)</p><p> at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)</p><p> at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)</p><p> at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)</p><p> at TvLibrary.Implementations.TvCardCollection..ctor(IEpgEvents epgEvents)</p><p> at TvService.TVController.InitController()System.Data.SqlClient.SqlException: Cannot open database "MpTvDb" requested by the login. The login failed.</p><p>Login failed for user 'sa'.</p><p> at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)</p><p> at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)</p><p> at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)</p><p> at System.Data.SqlClient.SqlConnection.Open()</p><p> at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()[/code]</p><p></p><p>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.</p><p></p><p>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 <em>start</em> 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.</p><p></p><p>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 <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown :(" loading="lazy" data-shortname=":(" /> It happens nearly daily</p></blockquote><p></p>
[QUOTE="u095538, post: 541202, member: 79639"] [b]MediaPortal Version[/b]: 1.0.2.0 [b]MediaPortal Skin[/b]: X Factor [b]Windows Version[/b]: Vista Ultimate [b]CPU Type[/b]: El-Cheapos AMD dual core (90+% CPU usage for 1080p h264, non-dxva (obviously) with 1x something special post-processing enabled (eg: de-interlacing) [b]HDD[/b]: Seagate 250GB 7200 SATA2 [b]Memory[/b]: 2GB cheap generic Corsair DDR2 [b]Motherboard[/b]: ASUS M3N78-VM [b]Video Card[/b]: intergrated on mobo. Nothing special. NVidia chipset which supports DXVA [b]Video Card Driver[/b]: No idea [b]Sound Card[/b]: intergrated on mobo. Nothing special. VIA chipset I believe [b]Sound Card AC3[/b]: intergrated on mobo. Nothing special. VIA chipset I believe [b]Sound Card Driver[/b]: no idea [b]1. TV Card[/b]: Hauppagge Nova T-500 [b]1. TV Card Type[/b]: Dual tuner [b]1. TV Card Driver[/b]: no idea [b]MPEG2 Video Codec[/b]: ffdshow [b]MPEG2 Audio Codec[/b]: ffdshow [b]h.264 Video Codec[/b]: ffdshow [b]Satelite/CableTV Provider[/b]: FTA (Aussie-land, DVB-T) [b]HTPC Case[/b]: Antec Fusion Black [b]TV - HTPC Connection[/b]: HDMI Hello All. I am using a single-seat setup with MP's TVServer and 4therecord. The TVService is continually [s]crashing[/s] 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: [code] 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()[/code] 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 [i]start[/i] 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 [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
TVService keeps crashing, logs point to SQL authentication
Contact us
RSS
Top
Bottom
