Home Forums SQL Server 2005 Administering SQLSERVERAGENT service on Local Computer started and then stopped RE: SQLSERVERAGENT service on Local Computer started and then stopped

  • October 23, 2009 at 1:14 am

    #1069825

    It appears that the VIA protocol for MSSQLSERVER is Enabled.

    If you disable it, MSSQLSERVER will start.

    Location for disabling VIA protocol:

    Computer Managment -> Services and Applications

    -> SQL Sever Configuration Manager ->

    SQL Server 2005 Network Configuration ->

    Protocols for MSSQLSERVER -> VIA (if Enabled, disable it.)

    If MSSQLSERVER, still does not start, try starting the service: Distributed Transaction Coordinator from (Run) services.msc. After that disable VIA. 😉 It worked for me.