SQL Server agent startup issues

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server agent startup issues

Author

Topic

rubs_65
Posting Yak Master

144 Posts

Posted - 2009-01-29 : 17:01:22

Hi,

We are getting following error when starting SQL Server agent:
2009-01-29 22:36:29 - ! [298] SQLServer Error: 21, Encryption not supported on the client. [SQLSTATE 08001]
2009-01-29 22:36:29 - ! [298] SQLServer Error: 21, Client unable to establish connection [SQLSTATE 08001]
2009-01-29 22:36:29 - ! [165] ODBC Error: 0, 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]
2009-01-29 22:36:29 - ! [000] Unable to connect to server ‘Test\Inst1’; SQLServerAgent cannot start
2009-01-29 22:36:29 - ! [298] SQLServer Error: 21, Encryption not supported on the client. [SQLSTATE 08001]
2009-01-29 22:36:29 - ! [298] SQLServer Error: 21, Client unable to establish connection [SQLSTATE 08001]
2009-01-29 22:36:29 - ! [165] ODBC Error: 0, 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]
2009-01-29 22:36:29 - ! [382] Logon to server ‘Test\Inst1’ failed (DisableAgentXPs)
2009-01-29 22:36:29 - ? [098] SQLServerAgent terminated (normally)

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
9.00.3042.00 SP2 Standard Edition

This is non-cluster server but we are using named instance test\inst1.

TCP/IP,Named pipe and Shared memory network protocols are enabled. Somehow I don’t see any protocol under “client protocols”. Also if I disable the shared memory I can’t connect to SQL Server instance. I modified serverhost entry in registry but didn’t helped.

How to fix this SQL Server agent startup issue?

Thanks
--rubs

heavymind
Posting Yak Master

115 Posts

Posted - 2009-02-02 : 08:50:10

Do you mean your list under sql server native client configuration -> client protocols in sql server configuration manager?

SQLServer Error: 21, Encryption not supported on the client. [SQLSTATE 08001] makes me think that sql server requires encryption. try to turn it off

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources