Upgrade issues v1.0.2 with TV service (1 Viewer)

[wildworld76]

just upgraded from version 1.0.0 to version 1.0.2 and had a couple issues with TV server/cleint after install. Worked great in v 1.0.0. Running XP Pro SP3 w/ a dual core AMD 2.6ghz/ 2GB RAM.

TV Server & Client are on the same box, the XP firewall disabled.

When XP starts, the TV Service hangs, does not start properly even after attmepting to manually restart the service. Once I open MP, the start up screen notes: "waiting for the TV service to start"

In the TV module, error is that it cannot connect to the database and to chk the windows firewall rules.

db is MS SQL Express
.net 3.5 SP1 installed

HELP!! Any suggestions on how to fix?

 

[Alzie]

same problem

 

[wildworld76]

I fixed my issue. Turns out my MS SQL password got hosed during the re-install, I had to reset the sa password.

Open TV server configuration after you upgrade and test the connection w/ the sql db, re-enter he password if necessary.

also see
How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition