sql server 2005 error 65535 when connecting with sql agent
Posted on 2009-02-02
I'm trying to get SQL server agent running on my sql server 2005. It appears to start up fine, but when I try to run a job, I get the following errors:
 SQLServer Error: 65535, SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. [SQLSTATE 08001]
 ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
 SQLServer Error: 65535, 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]
 Logon to server 'COMPUTERNAME' failed (ConnAttemptCachableOp)
I've looked at the server and it does appear to allow remote connections. I'm wondering why I'd get this message though since sql agent is on the local server.
I've tried changing the account that SQL Server Agent uses and it doesn't seem to matter. Does anyone has any suggestions?