Failed to create database - Page 2

ronilse · 2008-03-24, 12:22

Hi,
Just a litle one, you don't use "sa" as pasword, if you do i have seen issues with this not allowed

Regards
Roy

dingo · 2008-03-24, 23:54

hello. I had the same problem, but in the error log I could se there was still some files left from my pevious setup in c:\program files\microsoft SQL Server\MSSQL.1\MSSQL\DATA\ so I deleted the tv files from there. After that setup worked

link1896 · 2008-03-25, 10:55

as usual coming back to the problem the next day fresh has helped

I deleted the TvLibrary database file and got into tvserver config, and can now run mp.

but...

I can record tv to disc and watch the ts file in vlc no worries, but mp won't let me watch live tv or watch recorded files, i'll work this out tomorrow night. getting closer.

thanks for the help so far guys, much appreciated. mp really does look like the answer to my problems, wife acceptance, when it comes to pc's my wife is a dumb blonde, combining a pc and tv has been the cause of some tension shall we say.

MadMagpie · 2008-03-29, 04:48

w00t Thanx a bagfull dewds, have been pulling what hair I had left out over this, I'm lost in databases, thanx again deleting the files worked a treat

almartin · 2008-04-03, 21:56

link1896,

The "failed to create database" error appears maybe... because the database already exists and therefore it cannot be created again.
One reason for that is that even if you uninstall SQL Server, the database you created will still remain in data subfolder, as the uninstall process of Windows is not complete. You do not see it under SQL Server management console, but it is still there... To clean up, you need to go in Programmes\Microsoft SQL Server\MSSQL.1\MSSQL\Data and check. If it is there, well... the best (what I did) is to complete SQL Server uninstallation by removing all Microsoft SQL Server folders and sub-folders and then re-install SQL Server.
Then you will of course need to reinstall TV Server, but that is a snap...

If TVLibrary DB is not there, you may want to have a look at Logs folder under Programmes\Microsoft SQL Server\MSSQL.1\MSSQL\, there are ERRORLOG files worth reading...

Hope it helps, good luck,

Alexis.

link1896 · 2008-04-05, 07:39

Quote:

Originally Posted by almartin

link1896,

The "failed to create database" error appears maybe... because the database already exists and therefore it cannot be created again.
One reason for that is that even if you uninstall SQL Server, the database you created will still remain in data subfolder, as the uninstall process of Windows is not complete. You do not see it under SQL Server management console, but it is still there... To clean up, you need to go in Programmes\Microsoft SQL Server\MSSQL.1\MSSQL\Data and check. If it is there, well... the best (what I did) is to complete SQL Server uninstallation by removing all Microsoft SQL Server folders and sub-folders and then re-install SQL Server.
Then you will of course need to reinstall TV Server, but that is a snap...

If TVLibrary DB is not there, you may want to have a look at Logs folder under Programmes\Microsoft SQL Server\MSSQL.1\MSSQL\, there are ERRORLOG files worth reading...

Hope it helps, good luck,

Alexis.

yep the database file already existed. Hope this helps others on their journey.

charli181 · 2008-04-05, 13:08

This fix has been added to the wiki now in the FAQ for TV Server. Thanks all !!!!!

jonywee · 2008-11-06, 22:26

Same error here, with RC3 and MysQL. All fixed, but just to let you know:

In the TVServer configuration I changed the database name to mediaportal-rc3. The dash in the database name made the SQL statements to error out. (See C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal TV Server\log\tv.log for the SQL errors). TV configuration can't start and you can't change your database name anymore.

To change database name: Open a text editor and find your database name in C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal TV Server\Gentle.config. Remove the dash, save and start TV configuration again. You might want to review permissions on the database server first.

2008-04-05, 13:08	#17 (permalink)
charli181 Docs Team Join Date: Aug 2007 Location: Sydney Age: 36 Posts: 721 Thanks: 40 Thanked 40 Times in 33 Posts Country: My System	This fix has been added to the wiki now in the FAQ for TV Server. Thanks all !!!!! __________________ Bubble wrap is the solution to all of life's problems...!!!

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
Connecting the database failed	LinuZZ	Get Support	3	2008-12-16 18:36
Connection succeeded, but: "unable te create database;logon failed for user sa	jgevaert	Get Support	2	2008-03-11 14:30
failed to create the database	naich	Get Support	0	2007-11-24 22:33
Failed to open database	defcon5	Get Support	2	2007-02-22 09:03
Failed to create graph	AberDino	The old Bugreport Forum	33	2006-02-01 19:53

2008-03-24, 12:22	#11 (permalink)
ronilse Portal Tester Join Date: Jul 2005 Posts: 3,386 Thanks: 23 Thanked 99 Times in 84 Posts Country: My System	Hi, Just a litle one, you don't use "sa" as pasword, if you do i have seen issues with this not allowed Regards Roy

2008-03-24, 23:54	#12 (permalink)
dingo Portal Member Join Date: Oct 2006 Age: 28 Posts: 10 Thanks: 5 Thanked 0 Times in 0 Posts Country:	hello. I had the same problem, but in the error log I could se there was still some files left from my pevious setup in c:\program files\microsoft SQL Server\MSSQL.1\MSSQL\DATA\ so I deleted the tv files from there. After that setup worked

2008-03-25, 10:55	#13 (permalink)
link1896 Portal Member Join Date: Feb 2008 Posts: 16 Thanks: 0 Thanked 0 Times in 0 Posts Country:	as usual coming back to the problem the next day fresh has helped I deleted the TvLibrary database file and got into tvserver config, and can now run mp. but... I can record tv to disc and watch the ts file in vlc no worries, but mp won't let me watch live tv or watch recorded files, i'll work this out tomorrow night. getting closer. thanks for the help so far guys, much appreciated. mp really does look like the answer to my problems, wife acceptance, when it comes to pc's my wife is a dumb blonde, combining a pc and tv has been the cause of some tension shall we say.

2008-03-29, 04:48	#14 (permalink)
MadMagpie Portal Member Join Date: Apr 2007 Posts: 49 Thanks: 15 Thanked 3 Times in 2 Posts Country:	w00t Thanx a bagfull dewds, have been pulling what hair I had left out over this, I'm lost in databases, thanx again deleting the files worked a treat

2008-04-03, 21:56	#15 (permalink)
almartin Portal User Join Date: Mar 2008 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	link1896, The "failed to create database" error appears maybe... because the database already exists and therefore it cannot be created again. One reason for that is that even if you uninstall SQL Server, the database you created will still remain in data subfolder, as the uninstall process of Windows is not complete. You do not see it under SQL Server management console, but it is still there... To clean up, you need to go in Programmes\Microsoft SQL Server\MSSQL.1\MSSQL\Data and check. If it is there, well... the best (what I did) is to complete SQL Server uninstallation by removing all Microsoft SQL Server folders and sub-folders and then re-install SQL Server. Then you will of course need to reinstall TV Server, but that is a snap... If TVLibrary DB is not there, you may want to have a look at Logs folder under Programmes\Microsoft SQL Server\MSSQL.1\MSSQL\, there are ERRORLOG files worth reading... Hope it helps, good luck, Alexis.

2008-11-06, 22:26	#18 (permalink)
jonywee Portal Member Join Date: Sep 2007 Posts: 12 Thanks: 1 Thanked 0 Times in 0 Posts Country:	Same error here, with RC3 and MysQL. All fixed, but just to let you know: In the TVServer configuration I changed the database name to mediaportal-rc3. The dash in the database name made the SQL statements to error out. (See C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal TV Server\log\tv.log for the SQL errors). TV configuration can't start and you can't change your database name anymore. To change database name: Open a text editor and find your database name in C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal TV Server\Gentle.config. Remove the dash, save and start TV configuration again. You might want to review permissions on the database server first.