none
sql agent 服务不能启动了 RRS feed

  • 问题

  • 请教:

    系统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 
    2011年8月6日 15:22

答案

  • 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.
    • 已标记为答案 ahing 2011年8月11日 4:25
    2011年8月6日 15:37

全部回复

  • 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.
    • 已标记为答案 ahing 2011年8月11日 4:25
    2011年8月6日 15:37
  • 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



    2011年8月6日 16:33
  • Hi:

    给您几个建议:

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

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


    Shadowと愉快なコード達
    2011年8月6日 19:00
  • 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.
    2011年8月6日 19:03
  • 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中的,


    2011年8月7日 2:03
  • 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..."

    2011年8月7日 2:12
  • 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?

    2011年8月7日 2:43
  • 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 .

     

    2011年8月7日 7:12
  • 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?
    2011年8月7日 21:36
  • Hi:

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


    Shadowと愉快なコード達
    2011年8月8日 14:41