Failed to create database (1 Viewer)

[link1896]

TV-Server Version:
MediaPortal Version: 2.3.0
MediaPortal Skin: none?
Windows Version: vista home premium
CPU Type: amd x2 4400+
HDD: seagate 500gb sata
Memory: 2gb ddr800
Motherboard: gigiabyte ga-m57sli-s4
Motherboard Chipset: nvidia m55
Motherboard Bios: AWARD, version FE
Video Card: xfx 7600gs
Video Card Driver: 169.21
Sound Card: Sound Blaster xfi extreme music
Sound Card AC3: coax
Sound Card Driver: 2.09.0007
1. TV Card: leadtek dib7700
1. TV Card Type: dvb-t
1. TV Card Driver: 3.10.0.0
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: main concept
MPEG2 Audio Codec: main concept
Satelite/CableTV Provider:
HTPC Case: yum cha
Cooling: home made water cooling, including water cooled psu
Power Supply: enhance 450watt, water cooled
Remote: mouse for now
TV: epson tw1000 1080p projector
TV - HTPC Connection: dvi>hdmi


I have followed the video tutorials to the letter, and when it comes to running mediaportal tv server I get the "failed to create database" error.

all sql services are running
made sure I set MS sql 2005 authentication mode to mixed mode and set a password
my gentle.config file has looks like this:


<DefaultProvider name="SQLServer" connectionString="Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=HTPC\SQLEXPRESS;"


datasource was set to nothing, doesn't work either way


thanks for any help, i've tried everything, gone back to older builds of tvserver, still no joy

 

[naich]

Hi link 1896!

yes i have solved my problem

Please take a look in the setup of SQL ...
1) sql server browser/ service - is startet and set to auto
2) SQL database engine - is set to "allow tcp/ip" / activ


Both settings you'll find in "SQL Server 2005 Surface Area Configuration"
// START/Programs/microsoft SQL ... /konfigurationstools/
Unfortunately, i have a German xp version. I hope menues are conform.


cu

 

[link1896]

Thanks for the reply naich,

I have both services running and set to auto, and SQL database engine - is set to "allow tcp/ip"

I'm at a loss here.

anyone?

 

[charli181]

have you disabled the firewall on VIsta, or atleast opened up the ports required?

TV-Engine 0.3/config-firewall - MediaPortal Wiki Documentation

 

[link1896]

sorry should have added this is single seat, and yes firewall is disabled

 

[charli181]

If you open SQL Server Management studio and enter the creditials, Do you see a database called TvLibrary under the databases folder?

If so maybe try deleting it and try starting TV Setup again.

Also have you tried a reboot?

 

[link1896]

i have rebooted

here is a screen shot of sql server management studio

no database present.

 

[charli181]

your above test confirms that there is no comms problem for SQL server on the stand alone machine and that TV Server has not hit the DB yet.

what TV Server SVN are you trying to install? (maybe go back a few days from the version you have downloaded if it is the latest)

I am assuming that when you get the setup screen for all the credentials and click test button all the text boxes are green?

make sure credentials are correct, case sensitve and if you use numpad numbers in assigning password, than use them again for setting credientials (stranger things have happened).

 

[link1896]

have tried rev 18215, rev 18207, rev 17745, rev 17601

upon first running of tv server configuration the database test passes with green boxes, but when i click save i get "failed to create database"

 

[charli181]

I would now suggesting posting your full logs on here, everything looks OK for the TV server side of things.

from the SQL management window, can you create a database with the "sa" user account. That's the only last thing I can think of. Maybe create a new account just for the TV Server with full rights, although sa should have them already.

Is the SQL services running as administrator rights. I don;t have vista myself but could this be an issue with creating new database files?