sql agent 服务不能启动了

Question

请教：

系统2008 R2 std 英文版，SQL 2008 中文版，由于某些原因，要将SQL Server Management Studio 的管理界面改为英文版，于是安装了“ SQL Server® 2008 Express with Tools（英文版）”，并且安装时没出错；以为可以实现，谁知重新过后SQLAGENT服务不能启动，错误：the sql server agent(实例名）service on local computer started and then stopped.some services stop automatically if they are not in use by other services or programs.

-------------------------------------- 

事件日志：event id :103 ;sql serveragent could not be started(reason:unable to connect to server '服务器名';

sql serveragent cannot start)

-------------------------------------

log\sqlgent.out文件内容：

 

2011-08-06 23:12:49 - ! [000] Unable to connect to server 'SERVER04\NAV'; SQLServerAgent cannot start

2011-08-06 23:12:49 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 

2011-08-06 23:12:49 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 

2011-08-06 23:12:49 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 

2011-08-06 23:12:49 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 

2011-08-06 23:12:49 - ! [165] ODBC Error: 0, Data source name not found and no default driver specified [SQLSTATE IM002] 

2011-08-06 23:12:49 - ! [382] Logon to server 'SERVER04\NAV' failed (DisableAgentXPs)

2011-08-06 23:12:50 - ? [098] SQLServerAgent terminated (normally)

 

补充：数据库应用于NAV 

Answer 1

How many instances do you have on that machine? How many sql agent services did you see in sql server configuration manager? What's service startup account of sql agent? Express doesn't support sql agent by the way.

Answer 2

How many instances do you have on that machine? How many sql agent services did you see in sql server configuration manager? What's service startup account of sql agent? Express doesn't support sql agent by the way.

Think you for your reply  

How many instances do you have on that machine?  :  1

         How many sql agent services did you see in sql server configuration manager? : 1~2

         What's service startup account of sql agent? : by default : local service    , i tried to domain admins

          Doesn't express version,when i install “ SQL Server® 2008 Express with Tools（en）” before,it is OK.

My sql is chinese version , i want to change to english in Management Studio interface , so , i install the “ SQL Server® 2008 Express with Tools（en）” .

Now,NAV server manage can't connect server in MMC and SQL AGENT doesn't start . What should I do?

      How to uninstall the  “ SQL Server® 2008 Express with Tools（en）” ??

Think you again

Answer 3

Hi:

给您几个建议：

1.到sql server configuration manager去把SQL Agent尝试启动看看，如果您有装SQLEXPRESS的instance的话，其中一个应该是无法启动

2.请别装Express版本的SSMS，改装Standard版以上的SSMS，然后登入SQL Server看看是否可以透过SSMS来管理SQL Agent

---

Shadowと愉快なコード達

Answer 4

What do you mean 1~2 of sql agent service? Has one or two on the machine? What's sql instance name? Can remove express from control panel -> add or remove programs applet.

Answer 5

Hi:

给您几个建议：

1.到sql server configuration manager去把SQL Agent尝试启动看看，如果您有装SQLEXPRESS的instance的话，其中一个应该是无法启动

2.请别装Express版本的SSMS，改装Standard版以上的SSMS，然后登入SQL Server看看是否可以透过SSMS来管理SQL Agent

---

Shadowと愉快なコード達

在SQL管理器中也不能启动 ,没有安装sqlexpress 实例；

之前也有安装SSMSr ,只是中文版，我想把它换成英文版界面；

microsoft download上找到的ssms都是集成在express中的，

Answer 6

What do you mean 1~2 of sql agent service? Has one or two on the machine? What's sql instance name? Can remove express from control panel -> add or remove programs applet.

The instance name is NAV 

I can't found the programe about "...express..."

Answer 7

Only one instance NAV on the machine? Confused, should have 2 instances per your original post. Can you connect to it, run 'select @@version' and post result here?

Answer 8

Only one instance NAV on the machine? Confused, should have 2 instances per your original post. Can you connect to it, run 'select @@version' and post result here?

I have not permission to login the SQL Server by  Management Studio .

But i sure it isn't express version , because sql agent service can start before , when i install  "SQL Server® 2008 Express with Tools " , it  had broken down .

 

Answer 9

How many sql agent service did you see in sql server configuration manager? Are you dba of that sql server? If so, why don't have access permission? If not, why don't let your dba to figure it out?

Answer 10

Hi:

要不要考慮用修復安裝，把它修復回來看看?

---

Shadowと愉快なコード達