TV-Service starts before SQL-Server | Page 2

Discussion in 'fixed TV-Server / Client Bugs' started by Patric, November 1, 2006.

  1. infinite.loop
    • Premium Supporter

    infinite.loop Retired Team Member

    Joined:
    December 26, 2004
    Messages:
    16,163
    Likes Received:
    3,861
    Gender:
    Male
    Location:
    127.0.0.1
    Ratings:
    +4,154 / 7
    Home Country:
    Austria Austria
    Show System Specs
    -Uninstall the TV-Server
    -restart the PC
    -install latest version of TV-Server
    -check that SQL server is started
    -launch the TV-Server
    -enter IP-ADRESS of the SQL server
    -enter correct password for the SA user
    -click TEST


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Patric

    Patric Portal Pro

    Joined:
    August 27, 2004
    Messages:
    84
    Likes Received:
    2
    Ratings:
    +2 / 0
    Home Country:
    Germany Germany
    Show System Specs
    Hi Chris!

    Everything works fine doing what you suggest (as it did before).

    But after restarting (so that the SQL- and TV-Service start automatically) the same error as before appears (this time I explicitly chose the IP address instead of the machine name):
    Code (Text):
    1. 02.11.2006 21:25:12 !!!Controller:Unable to connect to database!!!
    2. 02.11.2006 21:25:12 Controller: database connection string:Password=mediaportal;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=192.168.100.13\SQLEXPRESS;
    3. 02.11.2006 21:25:12 Sql error:The database backend (provider SQLServer) could not be reached.
    4. Check the connection string: Password=mediaportal;Persist Security Info=True;User ID=sa;Initial Catalog=TvLibrary;Data Source=192.168.100.13\SQLEXPRESS;
    Patric
     
  4. Marcusb
    • Premium Supporter

    Marcusb Retired Team Member

    Joined:
    February 16, 2005
    Messages:
    1,995
    Likes Received:
    29
    Location:
    Melbourne
    Ratings:
    +29 / 0
    Hi Patric,
    I think people are missing your point. It seems everything is set up correctly, as you can connect succesfuly as long as the SQL server starts a few seconds before th TV service and not straight before.
    It seems the TV Service tries to connect while the database is still starting, so is unable to make a connection and then fails (but doesn't stop, so "Auto Restart" will not work).

    Unfortunatlely I can't offer any help, but thought that restating your issue may point people in the right direction.
     
  5. Patric

    Patric Portal Pro

    Joined:
    August 27, 2004
    Messages:
    84
    Likes Received:
    2
    Ratings:
    +2 / 0
    Home Country:
    Germany Germany
    Show System Specs
    Hi Marcus,

    at least you got my point :)

    Already thought I couldn't make myself clear...

    Patric
     
  6. infinite.loop
    • Premium Supporter

    infinite.loop Retired Team Member

    Joined:
    December 26, 2004
    Messages:
    16,163
    Likes Received:
    3,861
    Gender:
    Male
    Location:
    127.0.0.1
    Ratings:
    +4,154 / 7
    Home Country:
    Austria Austria
    Show System Specs
    Frodo knows about this issue and is working on a solution. :)
     
  7. Patric

    Patric Portal Pro

    Joined:
    August 27, 2004
    Messages:
    84
    Likes Received:
    2
    Ratings:
    +2 / 0
    Home Country:
    Germany Germany
    Show System Specs
    Chris,

    great info and thx for letting me know.
    Best wishes to Erwin!

    Patric

    BTW: Was machst du um 6 Uhr schon wieder am Rechner? :)
     
  8. Patric

    Patric Portal Pro

    Joined:
    August 27, 2004
    Messages:
    84
    Likes Received:
    2
    Ratings:
    +2 / 0
    Home Country:
    Germany Germany
    Show System Specs
    Just to popup this thread again.

    Because my harddisc is beginning to fail I decided to plugin a new one and do a complete reinstall of the system.
    I just installed WXP with all patches and the needed hardware drivers. The only software I threw in was MP (latest SVN), SQL Server Express and TV-Service.

    What should I say. The problem persists. The TV-Service still logs the same error message about not being able to connect to the SQL Server.

    But I also found two identical entries in the system log (both the same time):
    Code (Text):
    1. Ereignistyp:    Fehler
    2. Ereignisquelle: MSSQL$SQLEXPRESS
    3. Ereigniskategorie:  (4)
    4. Ereigniskennung:    17187
    5. Datum:      09.11.2006
    6. Zeit:       08:21:57
    7. Benutzer:       Nicht zutreffend
    8. Computer:   DIGN
    9. Beschreibung:
    10. SQL Server ist nicht zum Annehmen neuer Clientverbindungen bereit. Die Verbindung wurde geschlossen. Warten Sie vor dem Wiederholen des Vorgangs einige Minuten. Falls Sie über Zugriff auf das Fehlerprotokoll verfügen, suchen Sie vor einem erneuten Verbindungsversuch die Informationsmeldung, die besagt, dass SQL Server bereit ist. [CLIENT: <local machine>]
    11.  
    12. Weitere Informationen über die Hilfe- und Supportdienste erhalten Sie unter http://go.microsoft.com/fwlink/events.asp.
    If a translation is needed I'll provide one.
    Hope there's a fix in the near future for this...

    Patric
     
  9. varesino

    varesino Portal Member

    Joined:
    January 18, 2005
    Messages:
    38
    Likes Received:
    0
    Location:
    Europe
    Ratings:
    +0 / 0
    Is it possible that you have a delay getting the IP Address on your network card?

    Remember that the connection between SQL Server DB and TV server is done via TCP-IP, if you are using a DHCP server and your network card delay in initialization no communication can be done.

    Try with a fixed ip address.

    Regards
    Varesino
     
  10. patrick

    patrick Portal Pro

    Joined:
    April 20, 2005
    Messages:
    608
    Likes Received:
    45
    Location:
    Southeast
    Ratings:
    +45 / 0
    Home Country:
    United States of America United States of America
    Hi,

    I guess a work-around would be to set the tv server service to manual
    and run a batch file @ in startup with a sleep timer of say 2 minutes and
    then launch the tvserver service from the the batch file command line.


    HTH,
    patrick
     
  11. Patric

    Patric Portal Pro

    Joined:
    August 27, 2004
    Messages:
    84
    Likes Received:
    2
    Ratings:
    +2 / 0
    Home Country:
    Germany Germany
    Show System Specs
    varesino
    Just tried your suggestion even though I didn't think it had to do with because the SQL Server seems to respond but denies the connection (see post above).
    But setting a fixed IP didn't solve the problem either.

    patrick
    Just thought about something like starting the service via FireDaemon or something similar where you can set a delay for starting. We'll see...
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!