Home Forums SQL Server 2005 SQL Server 2005 General Discussion SQL Server Agent won't start RE: SQL Server Agent won't start

  • March 7, 2008 at 4:11 am

    #786536

    here is the content of SQLAgent.out

    2008-03-07 10:23:33 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]

    2008-03-07 10:23:33 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]

    2008-03-07 10:23:33 - ! [298] SQLServer Error: 2, An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [SQLSTATE 08001]

    2008-03-07 10:23:33 - ! [000] Unable to connect to server 'Starwars'; SQLServerAgent cannot start

    2008-03-07 10:24:03 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]

    2008-03-07 10:24:03 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]

    2008-03-07 10:24:03 - ! [298] SQLServer Error: 2, An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [SQLSTATE 08001]

    2008-03-07 10:24:03 - ! [382] Logon to server 'Starwars' failed (DisableAgentXPs)

    2008-03-07 10:24:04 - ? [098] SQLServerAgent terminated (normally

    ------------------------------------------------------------------------
    All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]