?
Solved

sql server 2005 error 65535 when connecting with sql agent

Posted on 2009-02-02
7
Medium Priority
?
4,422 Views
Last Modified: 2013-11-19
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:
[298] SQLServer Error: 65535, SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. [SQLSTATE 08001]

[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]

 [298] 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]

[382] 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?
0
Comment
Question by:leos_
  • 4
  • 2
7 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 23533707
who is the owner of the "job"?
does that owner have sysadmin rights on the server?
0
 
LVL 29

Accepted Solution

by:
QPR earned 1500 total points
ID: 23533713
0
 
LVL 3

Author Comment

by:leos_
ID: 23541366
the owner of the job does have sysadmin rights on the server
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 3

Author Comment

by:leos_
ID: 23541764
the article http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx did pose some interesting questions.  I'm not sure whether or not things are connecting right.  So I went into ODBC connections and tried to make a System DNS connection.  I noticed there that one of the connections to the server had "/sql2005" appended to it.  Since this server only runs sql2005 we don't need this, so I removed it.  Now I'm getting a whole new set of errors:

[298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000]

[382] Logon to server 'COMPUTERNAME' failed (ConnAttemptCachableOp)

Suggestions?
0
 
LVL 3

Author Comment

by:leos_
ID: 23553041
OK, so I solved the issue.  Somehow in the SQL server Configuration Manager, an alias got made pointing our machine name to the DNS we used to connect remotely to the machine.  Once this was removed, everything worked fine.  I'm not sure how this was added since I wasn't the one who installed and initially configured the database.  Thanks for your help.
0
 
LVL 3

Author Closing Comment

by:leos_
ID: 31541979
Thanks for your help.  The website you directed me to eventually led me the the answer.
0
 

Expert Comment

by:GemOss
ID: 39659682
What did it for me was deleting/renaming the 'SQLAGENT.OUT' file and then restarting the SQL Server Agent service. After the succesfull restart, a new file was created.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question