Another Unable to connect to database error (1 Viewer)

[testlab]

MediaPortal Version: 0.2.2.0
Engine Version: tvengine3-02-07-2007--12-46h--Rev12886.zip
svn Version: MediaPortal-svn--02-07-2007--01-07-Rev12880.exe
Windows Version: XP SP2


Hi, I have installed the server and client on my Media center using the tutorial Videos.
Part 1: Introduction and Downloads
Part 2: TV-Server Installation
Part 3: TV-Server Configuration
Part 5: MediaPortal Multi Seat (Network) Installation

It all works perfectly on my Media center.

Now Im installing Part 5 on another machine (under windows xp sp2 also). I've installed it all and it's good up to the point where you have to select what media server you want to connect to. I have set it using both IP and Hostname. I get a msg saying it connected to the server but also an error msg saying It can not connect to the DATABASE.

I don't have any kind of firewall enabled on any machine. On the Server Installation I have enabled sql Server to work with TCP-IP. I have even installed the Sql - Server pre-requisites on the 2nd computer (just in case something was required).

I have also done a search but not found any answers on the forum. Apologies if this has already been asked and there is already an answer. If that is the case, can you plz point it out ?

Thanks guys.

 

[chenks]

i would make a guess that you've forgotten to enable local AND remote connections in the SQL config

http://wiki.team-mediaportal.com/TV-Engine_0.3/config-SQL-Server

 

[testlab]

Hi again,

Sorry, been out for a bit. I do have it selected as per document you linked

 

[testlab]

forgot to mention than it is as per document and it doesn't work

 

[testlab]

Hi again,

Just tried on a 2nd client and have the same problem so I guess it's something to do with the server. Any thoughts appreciated.

 

[Paranoid Delusion]

Are the Server and clients running with full admin access.

Only a thought.

 

[richbayliss]

Post your log - this shows the connection string that didn't work.

 

[testlab]

Done a bit more digging (looking at logs and all)

Tried an ODBC Connection from the server box and it's all fine. Created one from the 2 clients and can't connect. Firewalls are all disabled. Double checked the settings on server again and TCP/IP is enabled

Here is the log:

2007-02-13 18:28:07.443645 [ERROR][MPMain]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=adminpassword;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=mc\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()

 

[testlab]

ok, after loads of digging, found out that the problem was that the 'SQL Server Browser' service was disabled by default on my comp. I've set it to automatically start and I can now connect.

Now I get an error saying that the channels are not mapped to any card . Will investigate that one now.

Thanks for your help on the connectivity issues. I dunno why,, but it was disabled by default

 

[testlab]

Well, a reboot solved the last problem. All working fine from all clients now. I'm a very happy bunny