Reply to thread

Message

<blockquote data-quote="etheesdad" data-source="post: 335973" data-attributes="member: 84335">Nope. didnt work. setuptv.exe came up with --config-db. selected MSSQL and it logged in. Was fine while I was setting up channels, then when I rebooted the machine it locked out user SA again. Strangely, when I run setuptv.exe --configure-db, the test login works fine &quot;test succeeded&quot;, so I hit save, then if I try to start the TV Server configuration, it chokes, &amp; says &quot;tv server not started&quot;[code]2008-11-30 08:52:00.906250 [TVService]: Exception&nbsp;&nbsp; :Error: DatabaseUnavailableUnclassifiedGentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC4;Data Source=mediabox5\SQLEXPRESS;Connection Timeout=300; ---&gt; System.Data.SqlClient.SqlException: Cannot open database &quot;MpTvDbRC4&quot; requested by the login. The login failed.Login failed for user 'sa'.&nbsp;&nbsp; at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)&nbsp;&nbsp; at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)&nbsp;&nbsp; at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)&nbsp;&nbsp; at System.Data.SqlClient.SqlConnection.Open()&nbsp;&nbsp; at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()&nbsp;&nbsp; --- End of inner exception stack trace ---&nbsp;&nbsp; at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)&nbsp;&nbsp; at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)&nbsp;&nbsp; at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)&nbsp;&nbsp; at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)&nbsp;&nbsp; at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)&nbsp;&nbsp; at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)&nbsp;&nbsp; at TvLibrary.Implementations.TvCardCollection..ctor()&nbsp;&nbsp; at TvService.TVController.InitController()System.Data.SqlClient.SqlException: Cannot open database &quot;MpTvDbRC4&quot; requested by the login. The login failed.Login failed for user 'sa'.&nbsp;&nbsp; at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)&nbsp;&nbsp; at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)&nbsp;&nbsp; at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)&nbsp;&nbsp; at System.Data.SqlClient.SqlConnection.Open()&nbsp;&nbsp; at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()Exception&nbsp;&nbsp; :The database backend (provider SQLServer) could not be reached.Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC4;Data Source=mediabox5\SQLEXPRESS;Connection Timeout=300;&nbsp; site&nbsp; &nbsp; &nbsp; :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)&nbsp; source&nbsp; &nbsp; :Gentle.Common&nbsp; stacktrace:&nbsp;&nbsp; at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)&nbsp;&nbsp; at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)&nbsp;&nbsp; at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)&nbsp;&nbsp; at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)&nbsp;&nbsp; at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)&nbsp;&nbsp; at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)&nbsp;&nbsp; at TvLibrary.Implementations.TvCardCollection..ctor()&nbsp;&nbsp; at TvService.TVController.InitController()[/code]</blockquote>

[QUOTE="etheesdad, post: 335973, member: 84335"] Nope. didnt work. setuptv.exe came up with --config-db. selected MSSQL and it logged in. Was fine while I was setting up channels, then when I rebooted the machine it locked out user SA again. Strangely, when I run setuptv.exe --configure-db, the test login works fine "test succeeded", so I hit save, then if I try to start the TV Server configuration, it chokes, & says "tv server not started" [code] 2008-11-30 08:52:00.906250 [TVService]: Exception :Error: DatabaseUnavailableUnclassified Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached. Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC4;Data Source=mediabox5\SQLEXPRESS;Connection Timeout=300; ---> System.Data.SqlClient.SqlException: Cannot open database "MpTvDbRC4" 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() at TvService.TVController.InitController()System.Data.SqlClient.SqlException: Cannot open database "MpTvDbRC4" 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() Exception :The database backend (provider SQLServer) could not be reached. Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC4;Data Source=mediabox5\SQLEXPRESS;Connection Timeout=300; site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String) source :Gentle.Common stacktrace: 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() at TvService.TVController.InitController() [/code] [/QUOTE]

Verification