Could not connect to database

dsd · 2007-11-14, 10:26

Hello,

I'm having some trouble with the latest TVEngine (downloaded yeasterdays build).
The version of Media Portal is RC3 with the latest SVN (from yeasterday).

I get a message saying (when I enter the IP adress (in media portal) to the TV engine) :

TV Server connected
Could not connect to database.

I've checked the settings on the server and the SQL Server Express is set to allow connections from other computers. And I can also connect to the SQL Server from the client through ODBC.

I've also deleted the database and started from scratch but I still get the same error.

Any help would be very much aprreciated.

Thanks in advance.

Regards

jan_chu · 2007-11-15, 15:14

did you set the sql browser for automatic startup under services ??? this did the trix from me.

//Jan Chu

dsd · 2007-11-15, 15:59

Hello,

thank you for the suggestion but that did not help...

How does the Media Portal client know which SQL user to use when logging in to SQL Server?
Are there a predefined useraccount I should use?
I shoud perhaps mention that I'm using a existing SQL Server 2005 Express.

Thanks in advance.

Regards

/Mattias

ie · 2007-11-16, 15:29

I had the same problem. Turning on the SQL browser solved it for me. Just before I also turned off the firewall. Doesn't know yet if I can turn it on again.

/Ingvar

2007-11-14, 10:26	#1 (permalink)
dsd Portal Member Join Date: Oct 2007 Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Could not connect to database Hello, I'm having some trouble with the latest TVEngine (downloaded yeasterdays build). The version of Media Portal is RC3 with the latest SVN (from yeasterday). I get a message saying (when I enter the IP adress (in media portal) to the TV engine) : TV Server connected Could not connect to database. I've checked the settings on the server and the SQL Server Express is set to allow connections from other computers. And I can also connect to the SQL Server from the client through ODBC. I've also deleted the database and started from scratch but I still get the same error. Any help would be very much aprreciated. Thanks in advance. Regards

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't connect to database	kenneta	fixed TV-Server / Client Bugs	20	2008-05-08 14:27
Cannot Connect to Database	rmartes	Installation, configuration support	10	2007-08-31 11:10
unable to connect to database	shanizar	Get Support	0	2007-04-10 19:09
Unable to connect to database	grandalf	Get Support	5	2007-02-02 18:41
Controller:Unable to connect to database	fpeters	Get Support	1	2006-12-27 23:13

2007-11-15, 15:14	#2 (permalink)
jan_chu Portal Member Join Date: Oct 2007 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Country:	did you set the sql browser for automatic startup under services ??? this did the trix from me. //Jan Chu

2007-11-15, 15:59	#3 (permalink)
dsd Portal Member Join Date: Oct 2007 Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Hello, thank you for the suggestion but that did not help... How does the Media Portal client know which SQL user to use when logging in to SQL Server? Are there a predefined useraccount I should use? I shoud perhaps mention that I'm using a existing SQL Server 2005 Express. Thanks in advance. Regards /Mattias

2007-11-16, 15:29	#4 (permalink)
ie Portal Member Join Date: Feb 2006 Location: Stockholm, Sweden Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts	I had the same problem. Turning on the SQL browser solved it for me. Just before I also turned off the firewall. Doesn't know yet if I can turn it on again. /Ingvar