Re-installed SQL and TV Server. Now: "Failed to open database"

Joche · 2007-03-17, 22:11

MediaPortal Version: SVN
1. TV Card: Hauppauge WINTV HVR900 (DVB-T)

I got a crash and my SQL Server Express installation went bad. I reinstalled it (remove and the install) which gave me the "Failed to open database" error from TV Server setup.

Now I have uninstalled TV Server Setup and installed it again. I got the question about what DB i'm running and what credentials to use. But still I'm getting the "Failed to open database" error. What can I do?

Joche · 2007-03-17, 22:21

Solved. Deleted some files in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\

For example TvLibrary.mdf

chenks · 2007-03-17, 22:21

suspect you haven't re-enabled one of the 'allow incoming connections' options in the SQL express config.

infinityloop · 2007-03-17, 23:23

Quote:

Originally Posted by chenks

suspect you haven't re-enabled one of the 'allow incoming connections' options in the SQL express config.

if SQL server is uninstalled, the SQL-data files are not removed
when installing it again into the same folder, you can not create a db with the same name as the old one. because the olf files are still there

so its required to delete the old MS-SQL-db files first

Joche · 2007-03-17, 23:41

I think we posted at the same second in the thread above. My reply re: the files was probably not there when chenk added his post.

Anyway, thanks to both of you.

2007-03-17, 22:11	#1 (permalink)
Joche Portal Member Join Date: Feb 2007 Location: Stockholm Age: 39 Posts: 46 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Re-installed SQL and TV Server. Now: "Failed to open database" MediaPortal Version: SVN 1. TV Card: Hauppauge WINTV HVR900 (DVB-T) I got a crash and my SQL Server Express installation went bad. I reinstalled it (remove and the install) which gave me the "Failed to open database" error from TV Server setup. Now I have uninstalled TV Server Setup and installed it again. I got the question about what DB i'm running and what credentials to use. But still I'm getting the "Failed to open database" error. What can I do?

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
RTSPPlayer:Failed to open file:rtsp://server/stream2	gibman	Get Support	8	2007-07-14 09:17
Failed to open database?	Yucca	pre 1.0 RC1	3	2007-02-23 15:02
Failed to open database	defcon5	Get Support	2	2007-02-22 09:03
clean installed 0.2.2 - Bluetwo looks "ugly" (strange effect)	Al_Capone	General Support	0	2007-01-09 18:11
show defined folder "my music" open from beginning	tomtom21000	Improvement Suggestions	1	2004-05-02 03:35

2007-03-17, 22:21	#2 (permalink)
Joche Portal Member Join Date: Feb 2007 Location: Stockholm Age: 39 Posts: 46 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Solved. Deleted some files in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ For example TvLibrary.mdf

2007-03-17, 22:21	#3 (permalink)
chenks Portal Member Join Date: May 2006 Location: Scotland Age: 32 Posts: 728 Thanks: 1 Thanked 1 Time in 1 Post Country: My System	suspect you haven't re-enabled one of the 'allow incoming connections' options in the SQL express config.

2007-03-17, 23:41	#5 (permalink)
Joche Portal Member Join Date: Feb 2007 Location: Stockholm Age: 39 Posts: 46 Thanks: 0 Thanked 0 Times in 0 Posts Country:	I think we posted at the same second in the thread above. My reply re: the files was probably not there when chenk added his post. Anyway, thanks to both of you.