Cannot Connect to Database (1 Viewer)

[rmartes]

I am trying to connect the client to the TVserver (My TV) and get the following error message after entering the ip address of the server:

Connected to TVServer unable to connect to the database.

I followed all the instructions from the training videos and had no problem at all.

I am using the latest build as of today and SVN

Thanks

 

[Marcusb]

Can you give some more information?
"Followed instructions" isn't enough unfortunately.

Are you trying to connect from a different PC or is the client on the same PC?
List the steps you have followed. Did you make sure the firewall isn't stopping any MP signals?
System Specs?
Log files? Look in Team MediaPorta\MediaPortal\logs

 

[rmartes]

Yes... I am trying to connect to another computer. The log file you requested:


2007-04-08 20:00:19.796875 [ERROR][MPMain]: 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=TvLibrary;Data Source=rmlaptop\SQLEXPRESS; ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
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 TvPlugin.ChannelNavigator.ReLoad()System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
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()
2007-04-08 20:00:19.812500 [ERROR][MPMain]: Exception :The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=******;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=rmlaptop\SQLEXPRESS;
2007-04-08 20:00:19.812500 [ERROR][MPMain]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
2007-04-08 20:00:19.828125 [ERROR][MPMain]: source :Gentle.Common
2007-04-08 20:00:19.843750 [ERROR][MPMain]: 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 TvPlugin.ChannelNavigator.ReLoad()
2007-04-08 20:00:59.984375 [ERROR][MPMain]: OnMessage exceptionystem.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.ThrowHelper.ThrowArgumentOutOfRangeException()
at TvPlugin.ChannelNavigator.SaveSettings(Settings xmlwriter)
at TvPlugin.TVHome.SaveSettings()
at TvPlugin.TVHome.OnPageDestroy(Int32 newWindowId)
at MediaPortal.GUI.Library.GUIWindow.OnMessage(GUIMessage message)
2007-04-08 20:01:03.906250 [ERROR][MPMain]: No translation found for id 101002
2007-04-08 20:01:05.359375 [ERROR][MPMain]: 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=TvLibrary;Data Source=rmlaptop\SQLEXPRESS; ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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 TvPlugin.ChannelNavigator.ReLoad()System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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()
2007-04-08 20:01:05.359375 [ERROR][MPMain]: Exception :The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=********;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=rmlaptop\SQLEXPRESS;
2007-04-08 20:01:05.375000 [ERROR][MPMain]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
2007-04-08 20:01:05.375000 [ERROR][MPMain]: source :Gentle.Common
2007-04-08 20:01:05.390625 [ERROR][MPMain]: 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 TvPlugin.ChannelNavigator.ReLoad()

I did try the single seat setup and everything worked just fined. I also added the server name and ip address to the client's hosts file. SQL Server browser is running along with the other SQL Server services.

Specs:

Sony VIAO Laptop: Intel(R) Core(TM) 2 CPU T7200 2.00GHz
1.99 GHz, 2.00 GB of Ram

All Firewall Settings are set to allow for both SQL Server and MediaPortal

 

[Marcusb]

Have you tried turning off both firewalls completly, just to rule them out?
This is always best for testing when you have connection problems.

Also, I'm going from memory here, but there is one step in the install where you have to adjust a setting to allow remote connections. You did that ok?

And (I know this is obvious but has to be asked) are you sure the password is correct?

 

[James_3]

I am having a similar problem here connecting from a client to the server here is my output log attatched to next post
Server does not have a firewall on it

 

[funkydoctor]

Same problem here, both server and clients have firewalls off:

2007-04-22 20:59:15.640625 [ERROR][MPMain]: 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=TvLibrary;Data Source=hilwihtpc\SQLEXPRESS; ---> System.Data.SqlClient.SqlException: Fehler beim Herstellen einer Verbindung mit dem Server. Beim Herstellen einer Verbindung mit SQL Server 2005 kann dieser Fehler dadurch verursacht werden, dass unter den SQL Server-Standardeinstellungen Remoteverbindungen nicht zulässig sind. (provider: SQL-Netzwerkschnittstellen, error: 26 - Fehler beim Bestimmen des angegebenen Servers/der angegebenen Instanz)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
bei System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
bei System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
bei System.Data.SqlClient.SqlConnection.Open()
bei Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
--- Ende der internen Ausnahmestapelüberwachung ---
bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
bei Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
bei Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
bei TvPlugin.ChannelNavigator.ReLoad()System.Data.SqlClient.SqlException: Fehler beim Herstellen einer Verbindung mit dem Server. Beim Herstellen einer Verbindung mit SQL Server 2005 kann dieser Fehler dadurch verursacht werden, dass unter den SQL Server-Standardeinstellungen Remoteverbindungen nicht zulässig sind. (provider: SQL-Netzwerkschnittstellen, error: 26 - Fehler beim Bestimmen des angegebenen Servers/der angegebenen Instanz)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
bei System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
bei System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
bei System.Data.SqlClient.SqlConnection.Open()
bei Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
2007-04-22 20:59:15.640625 [ERROR][MPMain]: Exception :The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=pfm01w;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=hilwihtpc\SQLEXPRESS;
2007-04-22 20:59:15.640625 [ERROR][MPMain]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
2007-04-22 20:59:15.640625 [ERROR][MPMain]: source :Gentle.Common
2007-04-22 20:59:15.656250 [ERROR][MPMain]: stacktrace: bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
bei Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
bei Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
bei TvPlugin.ChannelNavigator.ReLoad()
2007-04-22 20:59:20.171875 [ERROR][MPMain]: OnMessage exceptionystem.ArgumentOutOfRangeException: Der Index lag außerhalb des Bereichs. Er muss nicht negativ und kleiner als die Auflistung sein.
Parametername: index
bei System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bei System.ThrowHelper.ThrowArgumentOutOfRangeException()
bei TvPlugin.ChannelNavigator.SaveSettings(Settings xmlwriter)
bei TvPlugin.TVHome.SaveSettings()
bei TvPlugin.TVHome.OnPageDestroy(Int32 newWindowId)
bei MediaPortal.GUI.Library.GUIWindow.OnMessage(GUIMessage message)
2007-04-22 20:59:21.703125 [ERROR][MPMain]: No translation found for id 101002
2007-04-22 20:59:38.062500 [ERROR][MPMain]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=pfm01w;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=hilwihtpc\SQLEXPRESS; ---> System.Data.SqlClient.SqlException: Fehler beim Herstellen einer Verbindung mit dem Server. Beim Herstellen einer Verbindung mit SQL Server 2005 kann dieser Fehler dadurch verursacht werden, dass unter den SQL Server-Standardeinstellungen Remoteverbindungen nicht zulässig sind. (provider: SQL-Netzwerkschnittstellen, error: 26 - Fehler beim Bestimmen des angegebenen Servers/der angegebenen Instanz)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
bei System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
bei System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
bei System.Data.SqlClient.SqlConnection.Open()
bei Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
--- Ende der internen Ausnahmestapelüberwachung ---
bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
bei Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
bei Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
bei TvPlugin.ChannelNavigator.ReLoad()System.Data.SqlClient.SqlException: Fehler beim Herstellen einer Verbindung mit dem Server. Beim Herstellen einer Verbindung mit SQL Server 2005 kann dieser Fehler dadurch verursacht werden, dass unter den SQL Server-Standardeinstellungen Remoteverbindungen nicht zulässig sind. (provider: SQL-Netzwerkschnittstellen, error: 26 - Fehler beim Bestimmen des angegebenen Servers/der angegebenen Instanz)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
bei System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
bei System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
bei System.Data.SqlClient.SqlConnection.Open()
bei Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
2007-04-22 20:59:38.062500 [ERROR][MPMain]: Exception :The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=pfm01w;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=hilwihtpc\SQLEXPRESS;
2007-04-22 20:59:38.062500 [ERROR][MPMain]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
2007-04-22 20:59:38.062500 [ERROR][MPMain]: source :Gentle.Common
2007-04-22 20:59:38.062500 [ERROR][MPMain]: stacktrace: bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
bei Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
bei Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
bei TvPlugin.ChannelNavigator.ReLoad()
2007-04-22 20:59:42.984375 [ERROR][MPMain]: Exception ystem.ArgumentOutOfRangeException: Der Index lag außerhalb des Bereichs. Er muss nicht negativ und kleiner als die Auflistung sein.
Parametername: index
bei System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bei System.ThrowHelper.ThrowArgumentOutOfRangeException()
bei TvPlugin.ChannelNavigator.SaveSettings(Settings xmlwriter)
bei TvPlugin.TvFullScreen.SaveSettings()
bei TvPlugin.TvFullScreen.OnPageDestroy(Int32 newWindowId)
bei TvPlugin.TvFullScreen.DeInit()
bei MediaPortal.GUI.Library.GUIWindowManager.Clear()
bei MediaPortalApp.OnExit()
bei MediaPortalApp.Main(String[] args)
2007-04-22 20:59:42.984375 [ERROR][MPMain]: Exception er Index lag außerhalb des Bereichs. Er muss nicht negativ und kleiner als die Auflistung sein.
Parametername: index
2007-04-22 20:59:43.000000 [ERROR][MPMain]: site :Void ThrowArgumentOutOfRangeException(System.ExceptionArgument, System.ExceptionResource)
2007-04-22 20:59:43.000000 [ERROR][MPMain]: source :mscorlib
2007-04-22 20:59:43.000000 [ERROR][MPMain]: stacktrace: bei System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bei System.ThrowHelper.ThrowArgumentOutOfRangeException()
bei TvPlugin.ChannelNavigator.SaveSettings(Settings xmlwriter)
bei TvPlugin.TvFullScreen.SaveSettings()
bei TvPlugin.TvFullScreen.OnPageDestroy(Int32 newWindowId)
bei TvPlugin.TvFullScreen.DeInit()
bei MediaPortal.GUI.Library.GUIWindowManager.Clear()
bei MediaPortalApp.OnExit()
bei MediaPortalApp.Main(String[] args)
2007-04-22 20:59:43.000000 [ERROR][MPMain]: MediaPortal stopped due 2 an exception Der Index lag außerhalb des Bereichs. Er muss nicht negativ und kleiner als die Auflistung sein.
Parametername: index mscorlib bei System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bei System.ThrowHelper.ThrowArgumentOutOfRangeException()
bei TvPlugin.ChannelNavigator.SaveSettings(Settings xmlwriter)
bei TvPlugin.TvFullScreen.SaveSettings()
bei TvPlugin.TvFullScreen.OnPageDestroy(Int32 newWindowId)
bei TvPlugin.TvFullScreen.DeInit()
bei MediaPortal.GUI.Library.GUIWindowManager.Clear()
bei MediaPortalApp.OnExit()
bei MediaPortalApp.Main(String[] args)

 

[funkydoctor]

Ah, uh, ... shame on me.

https://forum.team-mediaportal.com/another_unable_connect_database_error-t19042.html fixed the problem. Just had to turn on the SQL Server Browser.... Everything working fine now.

:sorry:

 

[James_3]

my sql browser is on and it is still not connecting

here are all my logs from client pc.

The Server works ok and can view all channels etc but client pc will not connect to the database

 

[James_3]

solved (sort of)

The problem is definitely witht the client pc as it works fine on another pc i tried it on using exactly the same installers etc. no av/firewalls so i dont know what it could be, but at least i know the server is ok now

 

[happyf1sh]

May have a solution but not an explanation

Hello,

I have posted this just in case it may help some others.

I have recently tried connecting a client to a server across my wireless network using the SQL Server Express.

I always got the message "connected to tv server, unable to connect to the database"

I followed the instructions in the user manual and went through the videos - all without any progress.
I then used another copy of the SQL Server Management Studio Express on the client machine to try and resolve the database connection issue. Even then I couldn't connect to the database.

Eventually I found that I could connect using the a Servername <myserver> NOT <myserver\SQLEXPRESS>, as is normally documented (even in the microsoft database assistance videos).
What I have found is that the \SQLEXPRESS part stopped the connection.

Back to mediaportal.

I then modified the connection string in gentle.config that sits on the server machine (Documents and Settings\All Users\Application Data\Tv Media Portal\) - removing the \SQLEXPRESS in the 'Default Provider' string.
The client server link works!!!!

What I don't understand is a) why? and b) why is my database configuration different

Any explanations would be most appreciated.

Cheers
happyf1sh