Problem connecting to db on setuptv install

RoninTech · 2007-03-18, 00:11

MediaPortal Version: MediaPortal-svn--03-15-2007--01-06-Rev13416.exe
tvserver Version: tvengine3-03-15-2007--01-16h--Rev13416.zip
Windows Version: XP SP2

Followed the tvserver FAQ steps to install MS SQl Server 2005, configure firewall etc. When I run setuptv.exe and then press the test button, I get "Connection Failed! Login failed for user 'sa' "

My sqlserver and browser service are running and I'm stumped as to why I cannot connect to the db. I don't have a tvservice file in my SQL server data directory. Any ideas?

Cheers,
Ronin

Joche · 2007-03-18, 00:58

I know the sample pictures in the FAQ said 'sa' both as username and password. When I installed some hours ago I couldn't set 'sa' ass password but was forced to have a more complex password. Could it be that you entered another password than 'sa'?

RoninTech · 2007-03-18, 01:04

Hmmm, I don't recall setting any password. I thought sa/sa was a default account that exists after the SQL installation?

Joche · 2007-03-18, 06:45

That was how my installation looked like. I might have messed around somewhere, but the result was a working connection.

UPDATE: I made a re-install now and I suspect that you missed the correct settings in "Authentication mode" in the wiki:

[quote]
Authentication mode

* The next screen is important!!!
* Choose mixed mode and fill in a password for the sql server administrator account
* Write down the password, we will need it later on!

RoninTech · 2007-04-09, 20:15

Fixed: Reinstalled and wrote down what password I used....

The_Stig · 2007-04-10, 08:47

As stated in the tutorial video :-P

2007-03-18, 00:11	#1 (permalink)
RoninTech Portal User Join Date: Mar 2007 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Problem connecting to db on setuptv install MediaPortal Version: MediaPortal-svn--03-15-2007--01-06-Rev13416.exe tvserver Version: tvengine3-03-15-2007--01-16h--Rev13416.zip Windows Version: XP SP2 Followed the tvserver FAQ steps to install MS SQl Server 2005, configure firewall etc. When I run setuptv.exe and then press the test button, I get "Connection Failed! Login failed for user 'sa' " My sqlserver and browser service are running and I'm stumped as to why I cannot connect to the db. I don't have a tvservice file in my SQL server data directory. Any ideas? Cheers, Ronin Last edited by RoninTech; 2007-04-09 at 20:16.

2007-03-18, 06:45	#4 (permalink)
Joche Portal Member Join Date: Feb 2007 Location: Stockholm Age: 39 Posts: 46 Thanks: 0 Thanked 0 Times in 0 Posts Country:	That was how my installation looked like. I might have messed around somewhere, but the result was a working connection. UPDATE: I made a re-install now and I suspect that you missed the correct settings in "Authentication mode" in the wiki: [quote] Authentication mode * The next screen is important!!! * Choose mixed mode and fill in a password for the sql server administrator account * Write down the password, we will need it later on! Last edited by Joche; 2007-03-18 at 07:17.

2007-04-10, 08:47	#6 (permalink)
The_Stig Portal Tester Join Date: Apr 2005 Posts: 722 Thanks: 19 Thanked 2 Times in 2 Posts My System	As stated in the tutorial video :-P __________________ Some say he works as a tester for Team Mediaportal and some say that he smells bugs, even before they are written into the Code. All we know is, he's called The Stig.

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 2 pcs together	bugsbunny14	HTPC Projects	3	2007-04-02 08:06
Can't Run Setuptv.exe	beckkl	Get Support	4	2007-01-12 14:38
TVEngine-3.0: Error in SetupTV-App	kuehnch	fixed TV-Server / Client Bugs	10	2006-10-19 03:36
Problem to Install Media Portal	puttekock500	MediaPortal 1 Talk	4	2006-10-08 10:11
0.2.0.0 install on dotnet 2.0SP1 install doesnt work	SOS_Denmark	Installation, configuration support	2	2006-09-08 12:57

2007-03-18, 00:58	#2 (permalink)
Joche Portal Member Join Date: Feb 2007 Location: Stockholm Age: 39 Posts: 46 Thanks: 0 Thanked 0 Times in 0 Posts Country:	I know the sample pictures in the FAQ said 'sa' both as username and password. When I installed some hours ago I couldn't set 'sa' ass password but was forced to have a more complex password. Could it be that you entered another password than 'sa'?

2007-03-18, 01:04	#3 (permalink)
RoninTech Portal User Join Date: Mar 2007 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Hmmm, I don't recall setting any password. I thought sa/sa was a default account that exists after the SQL installation?

2007-04-09, 20:15	#5 (permalink)
RoninTech Portal User Join Date: Mar 2007 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Fixed: Reinstalled and wrote down what password I used....