December 15, 2009 at 6:57 am
Hi Experts,
I am not able to start SQL Agent.When checked i also find that when clicking on SQL Server Logs folder its throwing an error.
A severe error occurred on the current command. The results, if any, should be discarded. (.Net SqlClient Data Provider)
Please Help
TIA
December 15, 2009 at 7:53 am
Are there any errors in the Windows Event Logs?
What account is the SQL Server Agent running under?
I doubt I'll have the answer, but these are some things I'd check.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 15, 2009 at 8:03 am
Have you tried retrieving the error logs from the \LOG directory using a text exitor?
What does it shows in the current error log?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 15, 2009 at 10:21 pm
Jack Corbett (12/15/2009)
Are there any errors in the Windows Event Logs?What account is the SQL Server Agent running under?
I doubt I'll have the answer, but these are some things I'd check.
1.SQLServerAgent could not be started (reason: Unable to connect to server 'CY1160'; SQLServerAgent cannot start).
2.Agent running under local system account
December 15, 2009 at 10:30 pm
Jack Corbett (12/15/2009)
Are there any errors in the Windows Event Logs?What account is the SQL Server Agent running under?
I doubt I'll have the answer, but these are some things I'd check.
1.SQLServerAgent could not be started (reason: Unable to connect to server 'CY1160'; SQLServerAgent cannot start).
2.Agent running under local system account
December 15, 2009 at 10:33 pm
Bru Medishetty (12/15/2009)
Have you tried retrieving the error logs from the \LOG directory using a text exitor?What does it shows in the current error log?
2009-12-15 19:27:19 - ! [298] SQLServer Error: 21, Encryption not supported on the client. [SQLSTATE 08001]
2009-12-15 19:27:19 - ! [298] SQLServer Error: 21, Client unable to establish connection [SQLSTATE 08001]
2009-12-15 19:27:19 - ! [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-12-15 19:27:19 - ! [000] Unable to connect to server 'CY1160'; SQLServerAgent cannot start
2009-12-15 19:27:19 - ! [298] SQLServer Error: 21, Encryption not supported on the client. [SQLSTATE 08001]
2009-12-15 19:27:19 - ! [298] SQLServer Error: 21, Client unable to establish connection [SQLSTATE 08001]
2009-12-15 19:27:19 - ! [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-12-15 19:27:19 - ! [382] Logon to server 'CY1160' failed (DisableAgentXPs)
2009-12-15 19:27:20 - ? [098] SQLServerAgent terminated (normally)
December 16, 2009 at 12:14 am
It is because the server is not able to connect properly. Check the port number and the servername (should match with My Computer --> properties --> Network Identification--> Name) in the SQL network utility. If the agent is running under Local System and the same account is removed from the logins of SQL server then make SQL Server Agent to run under some login having proper permissions.
Thanks
December 16, 2009 at 7:05 am
Is the SQL Server accepting connections actively when you have this issue?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 16, 2009 at 7:08 am
Is the SQL Server service running?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 16, 2009 at 7:13 am
Jack Corbett (12/16/2009)
Is the SQL Server service running?
Good Question Jack .
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 17, 2009 at 12:11 am
SQL Server is up and running ..
No issues with connections
December 17, 2009 at 12:24 am
I have faced a similar issue when SQL Service was started with a different account.
Is SQL Service running under same Local admin account. If nt start under it and try starting the agent.
Regards,
Raj
December 17, 2009 at 1:01 am
2009-12-15 19:27:19 - ! [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-12-15 19:27:19 - ! [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]
2 (normally)
Is your SQL Server enables to allow remote connections under Connections? Is it a default instance? If not, have you got SQL Browser enabled for the service?
Have you gone through surface area configuration settings and check the remote connections protocol?
Have you gone through this article?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277[\url]
December 17, 2009 at 5:07 am
I checked SQL Native Client configuration under SQL Server Configuration Manager and found that all the protocols are missing and if i right clicked and selected properties and getting nothing.
Please find the attachment.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply