question

BLVPrasad avatar image
BLVPrasad asked

Migrated the SQL server 2014 to 2016.But the agent is not running even manually started

Migrated the SQL server 2014 to 2016. But the agent is not running even manually started ,after some inter-well it got stopped running.We have changed the running status to Automatic. I have changed the AgentXps to 1 ,but agent is abruptly stopped working. Below is the error i have.Please help me to resolve the issue. 2019-07-15 19:28:19 - ? [100] Microsoft SQLServerAgent version 13.0.4001.0 (X64 unicode retail build) : Process ID 16064 2019-07-15 19:28:19 - ? [495] The SQL Server Agent startup service account is PARADISE\administrator. 2019-07-15 19:28:19 - ! [150] SQL Server does not accept the connection (error: 0). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start. 2019-07-15 19:28:49 - ! [150] SQL Server does not accept the connection (error: 0). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start. 2019-07-15 19:29:19 - ! [150] SQL Server does not accept the connection (error: 0). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start. 2019-07-15 19:29:49 - ! [150] SQL Server does not accept the connection (error: 0). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start. 2019-07-15 19:30:19 - ! [150] SQL Server does not accept the connection (error: 0). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start. 2019-07-15 19:30:19 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start 2019-07-15 19:30:19 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 2019-07-15 19:30:19 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 2019-07-15 19:30:19 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 2019-07-15 19:30:19 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 2019-07-15 19:30:19 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 2019-07-15 19:30:19 - ! [382] Logon to server '(local)' failed (DisableAgentXPs) 2019-07-15 19:30:19 - ? [098] SQLServerAgent terminated (normally)

sql server agent
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.