The database backend (provider SQLServer) could not be reached. (1 Viewer)

[mazou]

Hi,

I have erase all my soft. And re-install them.
The error is the same.
I have make a test with SQL Server Management Studio Express with since the pc client and that does not work either!
However the firewall is desactived and SQL server accepted distant connections (theoretically!).

PS : I have installed the last version of SQL server (pack 2)

 

[hans]

I am having the same problem here. On the local machine MP can connect to the TVserver, but not from a client.

All firewalls are disabled, initial connection to the server works, but no channels are transfered.

I have edited gentle.config on the server:

<DefaultProvider name="SQLServer" connectionString="data source=192.168.1.4\SQLEXPRESS;initial catalog=Test;user id=xxx;password=xxx;packet size=4096" />

...and restarted the SQL server

I still get no picture but only the error message:
2007-01-01 21:39:34.640625 [Info.][MPMain]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=tv;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=SERVER\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: 28 - Server doesn't support requested protocol)

Where can you specify that the SQL server allows remote connections. Could this be the problem?

T

 

[zeroathome]

Solution

I think I've found a solution for the Problem:

I had the same error, but now it seems to be fixed.

The only thing I did is to start the service for the SQL Server Browser.
Best way to do so is going to Start->Execute (Ausführen...just using German XP ) there you type: services.msc
In the new Window there should be an entry for SQL Server-Browser.
You just have to set the startup type to Automatic and then start the service manually (you won't have to do that in the future).

This should fix the problem...hopefully

hope this helps some of you to get in the favour of watching tv in the garden...(about 10°C here in the middle of germany

zero

 

[mazou]

Thanks zeroathome !

I test that in a few day.

 

[Frodo]

Perhaps reading the wiki is not a bad idea.
The 'sql browser' solution is mentioned in the wiki since 18-oct 2006!!

http://wiki.team-mediaportal.com/TV-Engine_0.3/troubleshooting-Troubleshooting

 

[mazou]

Ho !
I have read the wiki... But not this page... I don't know why... surely because the other titles are not links

Sorry